Payroll details of employees with all the attributes.  SELECT TO_NUMBER (pap.employee_number) employee_number, INITCAP (pap.title) || ' ' || (pap.full_name) full_name, NVL (pet.attribute1, pet.element_name) Description, SUM(DECODE (pec.classification_name, 'Earnings', result_value, 'Deductions', result_value...

Get the details about the loan of employees. Change the effective date as required. SELECT DISTINCT papf.EMPLOYEE_NUMBER, papf.full_name, pbv.balance_name Loan_Detail, MAX (pbv.VALUE) Loan_Remaining_Amount, hou.name Department_Name FROM per_all_people_f papf, per_all_assignments_f paaf,...

List of employee with all the details like Name, Gender, Nationality, Department, Hire date & Address. /* Formatted on 8/21/2021 9:28:51 PM (QP5 v5.136.908.31019) */ SELECT papf.employee_number "Employee Number", papf.title...

Bank details of employees with bank name and account. SELECT DISTINCT a.employee_number, a.full_name employee_name, TRIM (d.segment1) bank_name, TRIM (d.segment2) bank_name_arabic, TRIM (d.segment6) IBAN FROM per_all_people_f a, per_all_assignments_f b, pay_personal_payment_methods_f c,...