PAY GB Pensions Automatic Re-enrolment

Description
Categories: BI Publisher
Columns: Assignment Number, Full Name, Age, Auto Reenrollment Date, Total Ear Prp, Opt Out End Date, Pension Scheme Name, Asg Act Id ...
Application: Payroll
Source: GB Pensions Automatic Re-enrolment Report
Short Name: PYGBPARER
DB package:
SELECT
			PAI.ACTION_INFORMATION15 ASSIGNMENT_NUMBER,
			PAI.ACTION_INFORMATION14 FULL_NAME,
			PAI.ACTION_INFORMATION18 AGE,
			fnd_date.canonical_to_date(nvl(PAI.ACTION_INFORMATION19,PAI.ACTION_INFORMATION9)) AUTO_REENROLLMENT_DATE,
			PAI.ACTION_INFORMATION13 TOTAL_EAR_PRP,
			fnd_date.canonical_to_date(PAI.ACTION_INFORMATION10) OPT_OUT_END_DATE,
			PAI.ACTION_INFORMATION1 PENSION_SCHEME_NAME,
			PAA.ASSIGNMENT_ACTION_ID ASG_ACT_ID
			FROM PAY_ACTION_INFORMATION PAI,
			PAY_ASSIGNMENT_ACTIONS PAA
			WHERE PAI.ACTION_CONTEXT_TYPE='AAP'
			AND PAI.ACTION_CONTEXT_ID=PAA.ASSIGNMENT_ACTION_ID
			AND PAA.PAYROLL_ACTION_ID=:P_PAYROLL_ACTION_ID
			AND PAI.ACTION_INFORMATION_CATEGORY='GB_ENROLL_PENSIONS'
			AND (PAI.ACTION_INFORMATION9 IS NOT NULL   or PAI.ACTION_INFORMATION19 IS NOT NULL )
			and not exists (
			select 1 from pay_message_lines pml
			where  pml.SOURCE_ID = PAA.ASSIGNMENT_ACTION_ID
			and    pml.MESSAGE_LEVEL = 'F')	
			order by ASSIGNMENT_NUMBER
Parameter Name SQL text Validation
Payroll Action Id
 
Number
Pay Start Date
 
Date
Pay End Date
 
Date
PRP Start Date
 
Date
PRP End Date
 
Date
Mode
 
Payroll Name
 
Period Name