PAY GB - DEO Payment Schedule Output

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: GB - DEO Payment Schedule Output
Short Name: PYGBDEOSOP
DB package:
					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
Parameter Name SQL text Validation
payroll_action_id