PAY PQP GB Scottish LGPS End of Year Report Output

					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