ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN C6E085D4713B51A9E05362FB09050512Y SELECT PYHKAPR.ASSIGNMENT_ID ASSIGNMENT_ID3, PYHKAPR.ASSIGNMENT_ACTION_ID ASSIGNMENT_ACTION_ID4, PYHKAPR.PAY_ADVICE_DATE, PYHKAPR.PAYMENT_DATE, PYHKAPR.ASSIGNMENT_NUMBER, PYHKAPR.TAX_UNIT_ID, PYHKAPR.ROW_ID, PYHKAPR.BUSINESS_GROUP_ID, PYHKAPR.BUSINESS_GROUP_NAME, PYHKAPR.FULL_NAME, PYHKAPR.EMPLOYEE_NUMBER, PYHKAPR.LOCATION_CODE, PYHKAPR.MAILSTOP, PYHKAPR.PAYROLL_ID PAYROLL_ID2, PYHKAPR.ORGANIZATION_NAME, PYHKAPR.CONSOLIDATION_SET_ID, PYHKAPR.PAYROLL_ACTION_ID, PYHKAPR.DATE_EARNED, PYHKAPR.PAY_ADVICE_DATE, PYHKAPR.PERIOD_START_DATE, PYHKAPR.PERIOD_END_DATE, PAY_PAYHKSOE_XMLP_PKG.cf_get_balances_totalsformula(PYHKAPR.ASSIGNMENT_ACTION_ID, PYHKAPR.TAX_UNIT_ID) CF_Get_Balances_Totals, PAY_PAYHKSOE_XMLP_PKG.cf_mpf_flag1formula() CF_MPF_Flag1, PAY_PAYHKSOE_XMLP_PKG.CP_Total_Earnings_This_Pay_p CP_Total_Earnings_This_Pay, PAY_PAYHKSOE_XMLP_PKG.CP_Total_Deductions_This_Pay_p CP_Total_Deductions_This_Pay, PAY_PAYHKSOE_XMLP_PKG.CP_Net_Pay_This_Pay_p CP_Net_Pay_This_Pay, PAY_PAYHKSOE_XMLP_PKG.CP_Direct_Payments_This_Pay_p CP_Direct_Payments_This_Pay, PAY_PAYHKSOE_XMLP_PKG.CP_Total_Payment_This_Pay_p CP_Total_Payment_This_Pay, PAY_PAYHKSOE_XMLP_PKG.CP_Total_Earnings_YTD_p CP_Total_Earnings_YTD, PAY_PAYHKSOE_XMLP_PKG.CP_Total_Deductions_YTD_p CP_Total_Deductions_YTD, PAY_PAYHKSOE_XMLP_PKG.CP_Net_Pay_YTD_p CP_Net_Pay_YTD, PAY_PAYHKSOE_XMLP_PKG.CP_Direct_Payments_YTD_p CP_Direct_Payments_YTD, PAY_PAYHKSOE_XMLP_PKG.CP_Total_Payment_YTD_p CP_Total_Payment_YTD, 'X' Dummy FROM PAY_HK_ASG_PAYMENT_RUNS_V PYHKAPR WHERE PYHKAPR.PAYMENT_DATE >= :p_Payments_From_Date AND PYHKAPR.PAYMENT_DATE <= :p_Payments_To_Date &cp_where_clause &cp_order_by PAY PAYHKSOE_XML US PAY Pay Advice (Hong Kong) Imported from BI Publisher Description: Pay Advice (Hong Kong) Application: Payroll Source: Pay Advice (Hong Kong) (XML) Short Name: PAYHKSOE_XML DB package: PAY_PAYHKSOE_XMLP_PKG ZHS PAY 发薪通知（香港） Imported from BI Publisher Description: 发薪通知（香港） Application: 工资单 Source: 发薪通知（香港）(XML) Short Name: PAYHKSOE_XML DB package: PAY_PAYHKSOE_XMLP_PKG BI Publisher &cp_order_by &cp_where_clause :cp_accrual :cp_accrual_end_date :cp_count :cp_direct_payments_this_pay :cp_direct_payments_ytd :cp_end_date :cp_net_entitlement :cp_net_pay_this_pay :cp_net_pay_ytd :cp_order_by :cp_sort_by :cp_start_date :cp_total_deductions_this_pay :cp_total_deductions_ytd :cp_total_earnings_this_pay :cp_total_earnings_ytd :cp_total_payment_this_pay :cp_total_payment_ytd :cp_where_clause :p_business_group_id :p_conc_request_id :p_consolidation_set :p_date_mpf_paid_to_trustee :p_payments_from_date :p_payments_from_date_disp :p_payments_to_date :p_payments_to_date_disp :p_payroll :p_sort_order_1 :p_sort_order_2 :p_sort_order_3 :p_sort_order_4 :print_mpf_flag 1 -20 :p_business_group_id Number fnd_profile.value('PER_BUSINESS_GROUP_ID') Y US Business Group Id ZHS 业务组标识 2 10 :p_consolidation_set LOV Oracle PY_SRS_CONSOLIDATION_SET Y select con.consolidation_set_id id, con.consolidation_set_name value, null description from pay_consolidation_sets con where con.business_group_id =fnd_global.per_business_group_id order by con.consolidation_set_name US Consolidation Set ZHS 合并集 3 20 :p_payroll LOV Oracle PY_SRS_PAYROLL Y select pay.payroll_id id, pay.payroll_name value, null description from pay_payrolls_f pay,fnd_sessions fnd where pay.business_group_id= fnd_global.per_business_group_id and fnd.session_id=userenv('sessionid') and fnd.effective_date between pay.effective_start_date and pay.effective_end_date order by pay.payroll_name Y US Payroll ZHS 工资单 4 30 :p_payments_from_date Date Y US Payment From Date ZHS 付款起始日期 5 40 :p_payments_to_date Date Y US Payment To Date ZHS 付款终止日期 6 50 :p_date_mpf_paid_to_trustee Date US Date MPF Paid to Trustee ZHS 向受托人支付 MPF 的日期 7 60 :p_sort_order_1 LOV Oracle PY_HK_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HK_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 1 ZHS 排序顺序 1 8 70 :p_sort_order_2 LOV Oracle PY_HK_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HK_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 2 ZHS 排序顺序 2 9 80 :p_sort_order_3 LOV Oracle PY_HK_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HK_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 3 ZHS 排序顺序 3 10 90 :p_sort_order_4 LOV Oracle PY_HK_SOE_SORT_BY Y select lookup_code id, meaning value, null description from hr_lookups where lookup_type='HK_SOE_SORT_BY' and enabled_flag='Y' order by meaning US Sort Order 4 ZHS 排序顺序 4