ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3263869E053B46B63588994Y select asg.ACTION_INFORMATION7 PERSON_ID, paa.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID, person.ACTION_INFORMATION3 FORE_NAME, person.ACTION_INFORMATION4 SUR_NAME, person.ACTION_INFORMATION5 NINO, person.ACTION_INFORMATION6 EMPLOYEE_NO, asg.ACTION_INFORMATION3 EMPLOYEE_REF_NUM, asg.ACTION_INFORMATION5 AMOUNT_PAID, asg.ACTION_INFORMATION4 MONTHLY_AMT_DUE, asg.ACTION_INFORMATION6 REASON From pay_action_information person, pay_action_information asg, pay_assignment_actions paa where paa.payroll_action_id = :PAYROLL_ACTION_ID and person.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID and asg.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID and person.ACTION_CONTEXT_TYPE = 'AAP' and asg.ACTION_CONTEXT_TYPE = 'AAP' and person.ACTION_INFORMATION_CATEGORY = 'GB DEO EMPLOYEE DETAILS' and asg.ACTION_INFORMATION_CATEGORY = 'GB DEO ASG DETAILS' and person.ACTION_INFORMATION7 = asg.ACTION_INFORMATION7 order by asg.ACTION_INFORMATION7 PAY PYGBDEOSOP US PAY GB - DEO Payment Schedule Output Application: Payroll Source: GB - DEO Payment Schedule Output Short Name: PYGBDEOSOP DB package: BI Publisher :payroll_action_id 1 10 :payroll_action_id Char US payroll_action_id