PAY GB Pensions Automatic Enrollment not applied

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: GB Pensions Automatic Enrollment not applied
Short Name: PYGBPAENR
DB package:
Run PAY GB Pensions Automatic Enrollment not applied and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
PAY Payroll Reconciliation Detail PAY P46 EDI Process v6 Output PQP Generate MCR CSV PAY P46EXP EDI Process v6 Output PAY Payroll Tax Report by Legal Employer PAY GB BIK Audit PAY RTI - Earlier Year Update Output 2014/15 PQP Teachers Pension MCR Reconciliation Report (Excel) PAY RTI ? Employer Alignment Submission Output
Blitz Report™

Blitz Report™ provides multiple benefits: