ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F32F3869E053B46B63588994Y 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' PAY PYGBPAENR US PAY GB Pensions Automatic Enrollment not applied Application: Payroll Source: GB Pensions Automatic Enrollment not applied Short Name: PYGBPAENR DB package: BI Publisher :p_payroll_action_id :p_prp_end_date 1 10 :p_payroll_action_id Number US Payroll Action Id 2 20 :p_pay_start_date Date US Pay Start Date 3 30 :p_pay_end_date Date US Pay End Date 4 40 :p_prp_start_date Date US PRP Start Date 5 50 :p_prp_end_date Date US PRP End Date 6 60 :p_mode Char US Mode 7 70 :p_payroll_name Char US Payroll Name 8 80 :p_period_name Char US Period Name