ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F32B3869E053B46B63588994Y SELECT ppa.business_group_id business_group_id , decode (substr (pay_gb_eoy_archive.get_parameter (ppa.legislative_parameters, 'PAYE_REF'), 1, 20), NULL , 'All', substr (pay_gb_eoy_archive.get_parameter (ppa.legislative_parameters, 'PAYE_REF'), 1 , 20)) PAYE_REFERENCE , nvl (papf.payroll_name, 'All') PAYROLL_ID , to_char (fnd_date.canonical_to_date (pay_gb_eoy_archive.get_parameter (legislative_parameters, 'SNAP_DATE')),'dd-MON-yyyy') SNAP_DATE FROM pay_payroll_actions ppa , pay_all_payrolls_f papf WHERE ppa.payroll_action_id = :PAYROLL_ACTION_ID AND substr (pay_gb_eoy_archive.get_parameter (ppa.legislative_parameters, 'PAYROLL_ID'), 1 , 20) = papf.payroll_id (+) AND sysdate BETWEEN papf.effective_start_date (+) AND papf.effective_end_date (+) PAY PYGBGPGREP US PAY Gender Pay Gap Application: Payroll Source: Gender Pay Gap Report Short Name: PYGBGPGREP DB package: BI Publisher :payroll_action_id 1 10 :payroll_action_id LOV Oracle PAY_GB_GPG_EXCEL_REP Y select ppa.payroll_action_id id, substr(to_char(ppa.request_id) || ' (' || to_char(ppa.payroll_action_id) || ')',1,35) value, null description from pay_payroll_actions ppa where ppa.report_type in ('PAY_GB_GPG') and ppa.report_qualifier='GB' and ppa.action_status='C' and ppa.action_type='X' and ppa.business_group_id=fnd_global.per_business_group_id order by ppa.last_update_date desc US Archive request ID