PAY Pay Advice (Hong Kong)
Description
Categories: BI Publisher
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
Description: Pay Advice (Hong Kong)
Application: Payroll
Source: Pay Advice (Hong Kong) (XML)
Short Name: PAYHKSOE_XML
DB package: PAY_PAYHKSOE_XMLP_PKG
Run
PAY Pay Advice (Hong Kong) and other Oracle EBS reports with Blitz Report™ on our demo environment
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 |
Parameter Name | SQL text | Validation | |
---|---|---|---|
Consolidation Set |
|
LOV Oracle | |
Payroll |
|
LOV Oracle | |
Payment From Date |
|
Date | |
Payment To Date |
|
Date | |
Date MPF Paid to Trustee |
|
Date | |
Sort Order 1 |
|
LOV Oracle | |
Sort Order 2 |
|
LOV Oracle | |
Sort Order 3 |
|
LOV Oracle | |
Sort Order 4 |
|
LOV Oracle |