PAY Gender Pay Gap

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: Gender Pay Gap Report
Short Name: PYGBGPGREP
DB package:
Run PAY Gender Pay Gap and other Oracle EBS reports with Blitz Report™ on our demo environment
					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 (+)
Parameter Name SQL text Validation
Archive request ID 
 
 LOV Oracle
Download
Related Blitz Reports
PAY IE Cheque Listing RKD Employee Element History PAY Void Payments PAY Earnings Audit PAY Business Payrolls Survey PAY NACHA BEN Back-out Life Events Summary BEN Back-out Life Events Audit Log PAY Payroll Reconciliation Detail
Blitz Report™

Blitz Report™ provides multiple benefits: