PAY GB Pensions Automatic Re-enrolment
Description
- Categories
- BI Publisher
- Application
- Payroll
- Source
- GB Pensions Automatic Re-enrolment Report
- Short Name
- PYGBPARER
DB package:
SQL 22 lines
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 |
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 |