ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713551A9E05362FB09050512Y 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) PAY PAYCNSOE_XML US PAY Pay Advice (China) 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 ZHS PAY 发薪通知（中国） Imported from BI Publisher Description: 打印的中国工资单 Application: 工资单 Source: 发薪通知（中国）(XML) Short Name: PAYCNSOE_XML DB package: PAY_PAYCNSOE_XMLP_PKG BI Publisher :assignment_action_id :cp_business_group_name :cp_consolidation_set_name :cp_end_date :cp_non_taxable_this_pay :cp_non_taxable_ytd :cp_order_by :cp_payroll_location :cp_payroll_name :cp_sort_order_1 :cp_sort_order_2 :cp_sort_order_3 :cp_sort_order_4 :cp_start_date :cp_statutory_this_pay :cp_statutory_ytd :cp_taxable_this_pay :cp_taxable_ytd :cp_voluntary_this_pay :cp_voluntary_ytd :p_business_group_id :p_conc_request_id :p_consolidation_set_id :p_end_date :p_end_date_disp :p_end_date_t :p_payout_location :p_payroll_id :p_sort_order_1 :p_sort_order_2 :p_sort_order_3 :p_sort_order_4 :p_start_date :p_start_date_disp :p_start_date_t 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group ID ZHS 业务组标识 2 10 :p_start_date Date Y US PY_SRS_START_DATE 3 20 :p_end_date Date Y US PY_SRS_EFFECTIVE_DATE 4 30 :p_payroll_id LOV Oracle PY_CN_ARCH_PAYROLL Y select pp.payroll_id id, pp.payroll_name value, null description from pay_payrolls pp where pp.business_group_id= fnd_global.per_business_group_id and pp.payroll_id in (select pcaa.payroll_id from pay_cn_arch_actions_v pcaa where pcaa.business_group_id= fnd_global.per_business_group_id and pcaa.effective_date between fnd_date.displaydate_to_date(:$flex$.py_srs_start_date.value) and fnd_date.displaydate_to_date(:$flex$.py_srs_effective_date.value)) order by value,description US Payroll ZHS 工资单 5 40 :p_consolidation_set_id LOV Oracle PY_CN_ARCH_CONSOLIDATION_SET Y select pcs.consolidation_set_id id, pcs.consolidation_set_name value, null description from pay_consolidation_sets pcs where pcs.consolidation_set_id in (select consolidation_set_id from pay_cn_arch_actions_v pcaa where pcaa.business_group_id= fnd_global.per_business_group_id and pcaa.effective_date between fnd_date.displaydate_to_date(:$flex$.py_srs_start_date.value) and fnd_date.displaydate_to_date(:$flex$.py_srs_effective_date.value)) and pcs.business_group_id=fnd_global.per_business_group_id order by value,description Select pcs.consolidation_set_name from pay_consolidation_sets pcs, pay_payrolls pay where pcs.consolidation_set_id = pay.consolidation_set_id and pay.payroll_id =:$flex$.payroll US Consolidation Set ZHS 合并集 6 50 :p_payout_location LOV Oracle HR_CN_PAYOUT_LOCATION Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='CN_PAYOUT_LOCATION' and enabled_flag='Y' order by value,description US Payroll Payment Location ZHS 工资单付款地点 7 60 :p_sort_order_1 LOV Oracle PY_CN_SOE_SORT_BY_1 Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='CN_SOE_SORT_BY' and enabled_flag='Y' order by value,description US Sort Order 1 ZHS 排序顺序 1 8 70 :p_sort_order_2 LOV Oracle PY_CN_SOE_SORT_BY_2 Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='CN_SOE_SORT_BY' and enabled_flag='Y' and substr(lookup_code,1,instr(lookup_code,' ',1,1)) not in (substr(:$flex$.py_cn_soe_sort_by_1,1,instr(:$flex$.py_cn_soe_sort_by_1.id,' ',1,1))) and :$flex$.py_cn_soe_sort_by_1 is not null order by value,description US Sort Order 2 ZHS 排序顺序 2 9 80 :p_sort_order_3 LOV Oracle PY_CN_SOE_SORT_BY_3 Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='CN_SOE_SORT_BY' and enabled_flag='Y' and substr(lookup_code,1,instr(lookup_code,' ',1,1)) not in (substr(:$flex$.py_cn_soe_sort_by_1.id,1,instr(:$flex$.py_cn_soe_sort_by_1.id,' ',1,1)),substr(:$flex$.py_cn_soe_sort_by_2.id,1,instr(:$flex$.py_cn_soe_sort_by_2.id,' ',1,1))) and :$flex$.py_cn_soe_sort_by_1 is not null and :$flex$.py_cn_soe_sort_by_2 is not null order by value,description US Sort Order 3 ZHS 排序顺序 3 10 90 :p_sort_order_4 LOV Oracle PY_CN_SOE_SORT_BY_4 Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='CN_SOE_SORT_BY' and enabled_flag='Y' and substr(lookup_code,1,instr(lookup_code,' ',1,1)) not in (substr(:$flex$.py_cn_soe_sort_by_1.id,1,instr(:$flex$.py_cn_soe_sort_by_1.id,' ',1,1)),substr(:$flex$.py_cn_soe_sort_by_2.id,1,instr(:$flex$.py_cn_soe_sort_by_2.id,' ',1,1)),substr(:$flex$.py_cn_soe_sort_by_3.id,1,instr(:$flex$.py_cn_soe_sort_by_3.id,' ',1,1))) and :$flex$.py_cn_soe_sort_by_1 is not null and :$flex$.py_cn_soe_sort_by_2 is not null and :$flex$.py_cn_soe_sort_by_3 is not null order by value,description US Sort Order 4 ZHS 排序顺序 4