PAY Pay Advice (China)

Description
Categories: BI Publisher, Human Resources
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
Business Group ID
 
Number
Sort Order 4
 
LOV Oracle
Sort Order 3
 
LOV Oracle
Sort Order 2
 
LOV Oracle
Sort Order 1
 
LOV Oracle
Payroll Payment Location
 
LOV Oracle
Consolidation Set
 
LOV Oracle
Payroll
 
LOV Oracle
PY_SRS_EFFECTIVE_DATE
 
Date
PY_SRS_START_DATE
 
Date