PAY GB Pensions Qualifying Scheme exists

Description

Categories
BI Publisher
Application
Payroll
Source
GB Pensions Qualifying Scheme exists
Short Name
PYGBPAEQ
DB package:

SQL 15 lines

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

Parameters 8

ParameterTypeList of values SQL
Payroll Action IdNumber
Pay Start DateDate
Pay End DateDate
PRP Start DateDate
PRP End DateDate
ModeChar
Payroll NameChar
Period NameChar