PAY Pay Advice (China)

Description
Categories: BI Publisher
Columns: Context Id Balances, Balance Org Name, Balances Name, Balances This Pay, Balances Ytd, Cf Balances, Cp Taxable This Pay, Cp Taxable Ytd, Cp Non Taxable This Pay, Cp Non Taxable Ytd ...
Application: Payroll
Source: Pay Advice (China) (XML)
Short Name: PAYCNSOE_XML
DB package: PAY_PAYCNSOE_XMLP_PKG
            SELECT
              pai.action_context_id context_id_balances
             ,pai.source_text balance_org_name
             ,pai.action_information1 balances_name
             , fnd_number.canonical_to_number(NVL( pai.action_information5,0 )) balances_this_pay
             ,fnd_number.canonical_to_number(NVL( pai.action_information4,0 )) balances_YTD,
                PAY_PAYCNSOE_XMLP_PKG.cf_balancesformula(pai.source_text, fnd_number.canonical_to_number ( NVL ( pai.action_information5 , 0 ) ), fnd_number.canonical_to_number ( NVL ( pai.action_information4 , 0 ) )) CF_Balances
            /*decode(pai.source_text, 'Taxable Earnings', fnd_number.canonical_to_number(NVL(pai.action_information5, 0))) CP_Taxable_This_Pay,
            decode(pai.source_text, 'Taxable Earnings', fnd_number.canonical_to_number(NVL(pai.action_information4, 0))) CP_Taxable_YTD,
            decode(pai.source_text, 'Non Taxable Earnings', fnd_number.canonical_to_number(NVL(pai.action_information5, 0))) CP_Non_Taxable_This_Pay,
            decode(pai.source_text, 'Non Taxable Earnings', fnd_number.canonical_to_number(NVL(pai.action_information4, 0))) CP_Non_Taxable_YTD,
            decode(pai.source_text, 'Voluntary Deductions', fnd_number.canonical_to_number(NVL(pai.action_information5, 0))) CP_Voluntary_This_Pay,
            decode(pai.source_text, 'Voluntary Deductions', fnd_number.canonical_to_number(NVL(pai.action_information4, 0))) CP_Voluntary_YTD,
            decode(pai.source_text, 'Statutory Deductions', fnd_number.canonical_to_number(NVL(pai.action_information5, 0))) CP_Statutory_This_Pay,
            decode(pai.source_text, 'Statutory Deductions', fnd_number.canonical_to_number(NVL(pai.action_information4, 0))) CP_Statutory_YTD*/
			,PAY_PAYCNSOE_XMLP_PKG.CP_Taxable_This_Pay_p CP_Taxable_This_Pay,
                PAY_PAYCNSOE_XMLP_PKG.CP_Taxable_YTD_p CP_Taxable_YTD,
                PAY_PAYCNSOE_XMLP_PKG.CP_Non_Taxable_This_Pay_p CP_Non_Taxable_This_Pay,
                PAY_PAYCNSOE_XMLP_PKG.CP_Non_Taxable_YTD_p CP_Non_Taxable_YTD,
                PAY_PAYCNSOE_XMLP_PKG.CP_Voluntary_This_Pay_p CP_Voluntary_This_Pay,
                PAY_PAYCNSOE_XMLP_PKG.CP_Voluntary_YTD_p CP_Voluntary_YTD,
                PAY_PAYCNSOE_XMLP_PKG.CP_Statutory_This_Pay_p CP_Statutory_This_Pay,
                PAY_PAYCNSOE_XMLP_PKG.CP_Statutory_YTD_p CP_Statutory_YTD
            FROM pay_action_information pai
            WHERE
              pai.action_information_category = 'APAC BALANCES'
              and pai.action_context_type = 'AAP'
             and pai.action_context_id=:ASSIGNMENT_ACTION_ID
            order by decode(nvl(pai.source_text, pai.action_information1), 'Taxable Earnings',1,'Non Taxable Earnings',2,
                                             'Statutory Deductions',3,'Voluntary Deductions',4,5)
Parameter Name SQL text Validation
PY_SRS_START_DATE
 
Date
PY_SRS_EFFECTIVE_DATE
 
Date
Payroll
 
LOV Oracle
Consolidation Set
 
LOV Oracle
Payroll Payment Location
 
LOV Oracle
Sort Order 1
 
LOV Oracle
Sort Order 2
 
LOV Oracle
Sort Order 3
 
LOV Oracle
Sort Order 4
 
LOV Oracle
Business Group ID
 
Number