PAY Pay Advice (Hong Kong)

Description
Categories: BI Publisher, Human Resources
Application: Payroll
Source: Pay Advice (Hong Kong) (XML)
Short Name: PAYHKSOE_XML
DB package: PAY_PAYHKSOE_XMLP_PKG
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
Business Group Id
 
Number
Sort Order 4
 
LOV Oracle
Sort Order 3
 
LOV Oracle
Sort Order 2
 
LOV Oracle
Sort Order 1
 
LOV Oracle
Date MPF Paid to Trustee
 
Date
Payment To Date
 
Date
Payment From Date
 
Date
Payroll
 
LOV Oracle
Consolidation Set
 
LOV Oracle