PAY RTI - NINO Verification Request Process - NVR Output

						select     
                        paa.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID,
						addr.ACTION_INFORMATION5 ADDRESS_LINE1, 
						addr.ACTION_INFORMATION6 ADDRESS_LINE2, 
						addr.ACTION_INFORMATION7 ADDRESS_LINE3, 
						addr.ACTION_INFORMATION8 ADDRESS_LINE4,
						addr.ACTION_INFORMATION12 POSTAL_CODE,
						addr.ACTION_INFORMATION13 COUNTRY,
						person.ACTION_INFORMATION3 LAST_NAME,
						person.ACTION_INFORMATION4 FIRST_NAME,
						person.ACTION_INFORMATION5 SECOND_NAME,
						person.ACTION_INFORMATION6 TITLE,
						person.ACTION_INFORMATION7 NI_NUMBER,
						person.ACTION_INFORMATION8 DOB,
						person.ACTION_INFORMATION9 GENDER
						From pay_action_information person,
						pay_action_information addr,
						pay_assignment_actions paa
						where 
						paa.payroll_action_id = :PAYROLL_ACTION_ID
						and person.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID
						and person.ACTION_CONTEXT_TYPE = 'AAP'
						and person.ACTION_INFORMATION_CATEGORY = 'GB RTI EMPLOYEE DETAILS'
						and addr.ACTION_CONTEXT_ID = paa.ASSIGNMENT_ACTION_ID
						and addr.ACTION_CONTEXT_TYPE = 'AAP'
						and addr.ACTION_INFORMATION_CATEGORY = 'ADDRESS DETAILS'
                        order by ASSIGNMENT_ACTION_ID