ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3253869E053B46B63588994 select paaf.ASSIGNMENT_number ASSIGNMENT_NUMBER, asg.ACTION_INFORMATION2 NI_NUMBER, asg.ACTION_INFORMATION3 EMP_NAME, asg.ACTION_INFORMATION4 DEA_REF_NUMBER, to_number(asg.ACTION_INFORMATION5) DEA_DEDUCTION_PTD, to_number(asg.ACTION_INFORMATION6) DEA_DEDUCTION_ITD, asg.ACTION_INFORMATION10 REASON, hrl.DESCRIPTION ISSUING_AUTH From pay_payroll_actions ppa, pay_action_information asg, pay_assignment_actions paa, per_all_Assignments_f paaf, per_time_periods ptp, hr_lookups hrl where ppa.payroll_action_id = :PAYROLL_ACTION_ID and paa.payroll_action_id = :PAYROLL_ACTION_ID and ptp.time_period_id = to_number(pay_gb_eoy_archive.get_parameter(legislative_parameters, 'PERIOD_ID')) and asg.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID and asg.ACTION_CONTEXT_TYPE = 'AAP' and asg.ACTION_INFORMATION_CATEGORY = 'GB DEA ASG DETAILS' and ptp.regular_payment_date between paaf.effective_start_date and paaf.effective_end_date and paaf.assignment_id = paa.assignment_id and asg.action_information12 = :PERSON_ID and asg.action_information4 = :REF_NUMBER and hrl.LOOKUP_TYPE(+) = 'GB_DEA_ISSUING_AUTHORITY' and hrl.LOOKUP_CODE(+) = asg.ACTION_INFORMATION14 order by paaf.ASSIGNMENT_number Y PAY PYGBDEASOP US PAY GB - DEA Payment Schedule Output Application: Payroll Source: GB - DEA Payment Schedule Output Short Name: PYGBDEASOP DB package: BI Publisher :payroll_action_id :person_id :ref_number 1 10 :payroll_action_id Char US payroll_action_id