PAY GB Pensions Automatic Enrollment not applied
Description
- Categories
- BI Publisher
- Application
- Payroll
- Source
- GB Pensions Automatic Enrollment not applied
- Short Name
- PYGBPAENR
DB package:
SQL 15 lines
SELECT PAI.ACTION_INFORMATION15 ASSIGNMENT_NUMBER, PAI.ACTION_INFORMATION14 FULL_NAME, PAI.ACTION_INFORMATION7 EMPLOYEE_CLASSIFICATION, fnd_date.canonical_to_date(PAI.ACTION_INFORMATION8) FIRST_FOUND_ELIG_DATE, fnd_date.canonical_to_date(PAI.ACTION_INFORMATION6) POST_PERIOD_END_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 fnd_date.canonical_to_date(PAI.ACTION_INFORMATION6) >= :P_PRP_END_DATE AND PAI.ACTION_INFORMATION9 IS NULL AND PAI.ACTION_INFORMATION5='Eligible Job Holder Postponement' |
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 |