PAY GB Pensions Automatic Re-enrolment

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: GB Pensions Automatic Re-enrolment Report
Short Name: PYGBPARER
DB package:
Run PAY GB Pensions Automatic Re-enrolment 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_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 
 
 Char
Payroll Name 
 
 Char
Period Name 
 
 Char
Download
Related Blitz Reports
PAY RTI YTD Reconciliation Report Output PAY GB Pensions Automatic Enrollment PAY Payroll Tax Report by Legal Employer PAY Payroll Report (Check List of Bonus Payment Notification for Health Ins/Welfare Pension Ins) PAY RTI - Year End P60 Report Process (Multi Threaded) PAY RTI - Year End P60 Report Process PAY Payroll Reconciliation Detail PQP Teachers Pension MCR Reconciliation Report (Excel) PAY RTI ? Employer Alignment Submission Output
Blitz Report™

Blitz Report™ provides multiple benefits: