PAY RTI EYU Run Reconciliation

➜ Back to Library
Description
Categories: BI Publisher
Application: Payroll
Source: RTI EYU Run Reconciliation Report
Short Name: PYGBEYUREC
DB package:
Run PAY RTI EYU Run Reconciliation and other Oracle EBS reports with Blitz Report™ on our demo environment
        SELECT  paa.assignment_action_id assignment_action_id
              , papf.last_name last_name
              , papf.national_identifier ni_number
              , to_char(papf.date_of_birth,'DD-Mon-YYYY') dob
              , papf.sex gender
              , pai1.action_information10 rti_payroll_id
              , paaf.assignment_number assignment_number
              , nvl (papf.per_information10, 'N') aggregated_paye
              , nvl (papf.per_information9, 'N') aggregated_ni
              , pai1.action_information1 start_date
              , pai1.action_information2 end_date
              , nvl (papf.per_information2, 'N') director_ind
              , pai2.action_information7 payment_non_indiv
			  , NVL(pai2.action_information9,'N') flexibly_accessing_pension
              , pai1.action_information8 eea_citizen
              , pai1.action_information9 epm6
              , pai1.action_information11 recently_bereaved
              , pai1.action_information12 annual_pension
              , pai1.action_information13 TAX_CODE
              , pai1.action_information14 tax_basis
              , pai1.action_information4 stud_loan_ind
              , pai1.action_information5 over_six
              , to_number (nvl (pai1.action_information15, 0) * 0.01) tax_payd
              , to_number (nvl (pai1.action_information16, 0) * 0.01) tax_ded
              , pai1.action_information7 live_abroad
              , pai1.action_information6 less_six
              , to_number (nvl (pai1.action_information28, 0) * 0.01) post_tax_pension
              , to_number (nvl (pai1.action_information26, 0) * 0.01) pre_tax_pension
              , to_number (nvl (pai2.action_information8, 0) * 0.01) benefits_taxed
              , to_number (nvl (pai1.action_information17, 0) * 0.01) stud_loan_repayment
              , to_number (nvl (pai1.action_information18, 0) * 0.01) ssp
              , to_number (nvl (pai1.action_information19, 0) * 0.01) smp
              , to_number (nvl (pai1.action_information20, 0) * 0.01) ospp
              , to_number (nvl (pai1.action_information21, 0) * 0.01) sap
              , to_number (nvl (pai1.action_information22, 0) * 0.01) aspp
              , trunc (nvl (pai2.action_information2, 0)  * 0.01) trivial_amount_a
              , trunc (nvl (pai2.action_information4, 0)  * 0.01)  trivial_amount_b
              , trunc (nvl (pai2.action_information6, 0)  * 0.01)  trivial_amount_c
			  , NVL(pai2.action_information10,'N') PENSION_DEATH_BENEFIT
			  , (nvl (pai2.ACTION_INFORMATION11, 0)  * 0.01) FLEXIBLE_DRAWDOWN_TAXABLE
			  , (nvl (pai2.ACTION_INFORMATION12, 0)  * 0.01) FLEXIBLE_DRAWDOWN_NONTAXABLE	
        FROM    pay_assignment_actions paa
              , pay_action_information pai1
              , pay_action_information pai2
              , per_all_assignments_f paaf
              , per_all_people_f papf
        WHERE   paa.payroll_action_id = :PAYROLL_ACTION_ID
        AND     pai1.action_context_id = paa.assignment_action_id
        AND     pai1.action_context_type = 'AAP'
        AND     pai1.action_information_category = 'GB_RTI_EYU_ASG_DET'
        AND     pai2.action_context_id (+) = paa.assignment_action_id
        AND     pai2.action_context_type (+) = 'AAP'
        AND     pai2.action_information_category (+) = 'GB_RTI_EYU_ASG_DET1'
        AND     pai1.assignment_id = pai2.assignment_id
        AND     paaf.assignment_id = paa.assignment_id
        AND     papf.person_id = paaf.person_id
        AND     paaf.effective_start_date =  
                (
                SELECT  max (effective_start_date)
                FROM    per_all_assignments_f
                WHERE   assignment_id = paaf.assignment_id
                AND effective_start_date <= :DATE_RUN
                )
        AND     papf.effective_start_date =
                (
                SELECT  max (effective_start_date)
                FROM    per_all_people_f
                WHERE   person_id = papf.person_id
                AND effective_start_date <= :DATE_RUN
                )
        ORDER BY last_name, rti_payroll_id, assignment_number
Parameter Name SQL text Validation
Archive Request ID 
 
 LOV Oracle
Download
Related Blitz Reports
PAY Payroll Reconciliation Detail PAY GB BIK Class 1A NIC PAY Business Payrolls Survey PAY A8B Summary (1) PAY RTI - Year End P60 Report Process PAY Employee Run Results PAY Employee Run Results Report (CA) PAY RTI - Year End P60 Report Process (Multi Threaded) PAY GB BIK Audit
Blitz Report™

Blitz Report™ provides multiple benefits: