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:
Source: GB Pensions Automatic Enrollment not applied
Short Name: PYGBPAENR
DB package:
Run
PAY GB Pensions Automatic Enrollment not applied and other Oracle EBS reports with Blitz Report™ on our demo environment
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' |
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 |