PAY Tax Register

 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_ptd6) 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