PAY Pay Advice (China)
Description
Categories: BI Publisher
Imported from BI Publisher
Description: China Printed Payslip
Application: Payroll
Source: Pay Advice (China) (XML)
Short Name: PAYCNSOE_XML
DB package: PAY_PAYCNSOE_XMLP_PKG
Description: China Printed Payslip
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 |