ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F30C3869E053B46B63588994Y select arch.ACTION_INFORMATION1 FORE_NAME, arch.ACTION_INFORMATION2 SUR_NAME, arch.ACTION_INFORMATION3 NINO, arch.ACTION_INFORMATION4 GENDER, arch.ACTION_INFORMATION5 DOB, arch.ACTION_INFORMATION6 CPP1, arch.ACTION_INFORMATION7 CPP2, arch.ACTION_INFORMATION9 CEC2, arch.ACTION_INFORMATION8 CRC, arch.ACTION_INFORMATION10 CEC1, arch.ACTION_INFORMATION11 EAPC, arch.ACTION_INFORMATION12 EAVC, arch.ACTION_INFORMATION13 RAPC, arch.ACTION_INFORMATION14 RAVC, arch.ACTION_INFORMATION15 PP, arch.ACTION_INFORMATION17 asg_num From pay_action_information arch, pay_assignment_actions paa where paa.payroll_action_id = :PAYROLL_ACTION_ID and arch.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID and arch.ACTION_CONTEXT_TYPE = 'AAP' and arch.ACTION_INFORMATION_CATEGORY = 'PQP GB SC LGPS DETAILS' order by arch.ACTION_INFORMATION17 PAY PQGBSCLGPSROP US PAY PQP GB Scottish LGPS End of Year Report Output Application: Payroll Source: PQP GB Scottish LGPS End of Year Report Output Short Name: PQGBSCLGPSROP DB package: BI Publisher :payroll_action_id 1 10 :payroll_action_id Char US payroll_action_id