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
| Parameter | Type | List of values SQL |
|---|---|---|
| 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 |