PAY Pay Advice (Hong Kong)

➜ Back to Library
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
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
Download
Related Blitz Reports
PAY Pay Advice (Singapore) PAY Statement Of Earnings (New Zealand) PAY Pay Advice (Australia) PAY IR56B Control Listing ECC Projects, Projects Costing: Transactions, SQL1 PAY ROE Work Sheet PAY Tax Payments Listing PAY STP Archive Validation PAY MPF Remittance
Blitz Report™

Blitz Report™ provides multiple benefits: