PAY GB Pensions Qualifying Scheme exists

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: GB Pensions Qualifying Scheme exists
Short Name: PYGBPAEQ
DB package:
Run PAY GB Pensions Qualifying Scheme exists and other Oracle EBS reports with Blitz Report™ on our demo environment
SELECT 
			 PAI.ACTION_INFORMATION14 FULL_NAME,
			 PAI.ACTION_INFORMATION15 ASSIGNMENT_NUMBER,
			 PAI.ACTION_INFORMATION1 PENSION_SCHEME_NAME,
			 PAI.ACTION_INFORMATION7 EMPLOYEE_CLASSIFICATION,
			 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION17) NOM_AUTO_ENROLLMENT_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 PAI.ACTION_INFORMATION9 IS NULL
			 AND PAI.ACTION_INFORMATION1 IS NOT NULL
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 GB Pensions Automatic Enrollment not applied 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: