PAY Tax Register

Description
Categories: BI Publisher
Columns: Rf Bal Name4, Rf Bal Code4, Assignment Action Id1, Rf Tot Ptd6, Rf Tot Mtd6, Rf Tot Ytd6 ...
Application: Payroll
Source: Tax Register Report (XML)
Short Name: PYZATXREGREP
DB package: PAY_ZA_TAX_REG_AR
 SELECT  
        decode (rf_bal_name4,
                'Gross Retirement Funding Income',
                'Gross Employment Income (Taxable)',
                'Gross Non Retirement Funding Income',
                'Gross Employment Income (Taxable)',
				'Directors Fees Resident NED',
				'Gross Employment Income (Taxable)',
                rf_bal_name4) rf_bal_name4,
        decode (rf_bal_code4,
				'3620',
				'3699',
				'3670',
				'3699',
                '3697',
                '3699',
                '3698',
                '3699',
                rf_bal_code4) rf_bal_code4,
        assignment_action_id1,
        sum (rf_tot_mtd6) rf_tot_ptd6,
        sum (rf_tot_mtd6) rf_tot_mtd6,
        sum (rf_tot_ytd6) rf_tot_ytd6
FROM    
        (
        SELECT  
                decode (pai.action_information16,
                        'RFIable Ann Pymt of EE Debt NTG',
                        'Total RFIable Annual Income',
                        'NRFIable Ann Pymt of EE Debt NTG',
                        'Total NRFIable Annual Income',
                        pai.action_information16) rf_bal_name4,
                pai.action_information12 assignment_action_id1,
                pai.action_information17 rf_bal_code4,
                sum (fnd_number.canonical_to_number (pai.action_information18)) rf_tot_ptd6,
                sum (fnd_number.canonical_to_number (pai.action_information19)) rf_tot_mtd6,
                sum (fnd_number.canonical_to_number (pai.action_information20)) rf_tot_ytd6
        FROM    
                pay_action_information pai,
                pay_assignment_actions paa
        WHERE   
                pai.action_context_id = paa.assignment_action_id
        AND     paa.payroll_action_id = :P_PAYROLL_ACTION_ID
        AND     paa.assignment_action_id = :assignment_action_id
        AND     pai.action_context_type = 'AAP'
        AND     pai.action_information_category = 'ZA_TAX_REG_REP'
        AND     pai.action_information21 = :payroll_id
        AND     pai.action_information17 IN (3620,3670,3696,3697,3698)
        GROUP BY
                decode (pai.action_information16,
                        'RFIable Ann Pymt of EE Debt NTG',
                        'Total RFIable Annual Income',
                        'NRFIable Ann Pymt of EE Debt NTG',
                        'Total NRFIable Annual Income',
                        pai.action_information16),
                pai.action_information12,
                pai.action_information17
        ORDER BY 
                pai.action_information17
        )
GROUP BY
        decode (rf_bal_name4,
                'Gross Retirement Funding Income',
                'Gross Employment Income (Taxable)',
                'Gross Non Retirement Funding Income',
                'Gross Employment Income (Taxable)',
				'Directors Fees Resident NED',
				'Gross Employment Income (Taxable)',
                rf_bal_name4),
        decode (rf_bal_code4,
				'3620',
				'3699',
				'3670',
				'3699',
                '3697',
                '3699',
                '3698',
                '3699',
                rf_bal_code4),
        assignment_action_id1
Parameter Name SQL text Validation
Payroll Name
 
LOV Oracle
Payroll Period
 
LOV Oracle
Include Assignments
 
LOV Oracle
Specific Assignment?
 
Number
Print PTD
 
LOV Oracle
Print MTD
 
LOV Oracle
Print YTD
 
LOV Oracle
Sort Order 1
 
LOV Oracle
Sort Order 2
 
LOV Oracle
Sort Order 3
 
LOV Oracle
Generate Detail Report?
 
LOV Oracle
Payroll Action ID
 
Legal Entity Name
 
DebugFlag
 
LOV Oracle
Start Period ID
 
Number
Payroll Name
 
End Period Date
 
Date