PAY GB Pensions Qualifying Scheme exists

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
Blitz Report™