PAY GB Pensions Automatic Enrollment not applied

Description
Categories: BI Publisher
Application: Payroll
Source: GB Pensions Automatic Enrollment not applied
Short Name: PYGBPAENR
DB package:
SELECT PAI.ACTION_INFORMATION15 ASSIGNMENT_NUMBER,
		 PAI.ACTION_INFORMATION14 FULL_NAME,
		 PAI.ACTION_INFORMATION7 EMPLOYEE_CLASSIFICATION,
		 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION8) FIRST_FOUND_ELIG_DATE,
		 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION6) POST_PERIOD_END_DATE
		 FROM PAY_ACTION_INFORMATION PAI,
		 PAY_ASSIGNMENT_ACTIONS PAA
		 WHERE PAI.ACTION_CONTEXT_TYPE='AAP'
		 AND PAI.ACTION_INFORMATION_CATEGORY='GB_ENROLL_PENSIONS'
		 AND PAI.ACTION_CONTEXT_ID=PAA.ASSIGNMENT_ACTION_ID
		 AND PAA.PAYROLL_ACTION_ID=:P_PAYROLL_ACTION_ID
		 AND fnd_date.canonical_to_date(PAI.ACTION_INFORMATION6) >= :P_PRP_END_DATE 
		 AND PAI.ACTION_INFORMATION9 IS NULL
		 AND PAI.ACTION_INFORMATION5='Eligible Job Holder Postponement'
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
 
Char
Payroll Name
 
Char
Period Name
 
Char