PAY Pay Advice (Singapore)

select assignment_id,
          assignment_action_id,
          person_id,
          full_name,
          assignment_number,
          position_title,
          salary,
          location_id,
          location_code,
          expense_check_send_to_address,
          legal_employer,
          payroll_id,
          payroll_action_id,
          time_period_id,
          period_number,
          to_char(period_start_date,'DD-Mon-YYYY') period_start_date,
          to_char(period_end_date,'DD-Mon-YYYY') period_end_date,
          to_char(pay_advice_date,'DD-Mon-YYYY') pay_advice_date,
          to_char(date_earned,'DD-Mon-YYYY') date_earned,
          run_assignment_action_id,
          run_payroll_action_id, 
	PAY_PAYSGSOE_XMLP_PKG.cf_address_line1formula(expense_check_send_to_address, person_id, location_id) CF_ADDRESS_LINE1, 
	PAY_PAYSGSOE_XMLP_PKG.cf_gross_pay_currformula(assignment_action_id, person_id) CF_GROSS_PAY_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_ADDRESS_LINE2_p CP_ADDRESS_LINE2,
	PAY_PAYSGSOE_XMLP_PKG.CP_ADDRESS_LINE3_p CP_ADDRESS_LINE3,
	PAY_PAYSGSOE_XMLP_PKG.CP_TOWN_p CP_TOWN,
	PAY_PAYSGSOE_XMLP_PKG.CP_POST_CODE_p CP_POST_CODE,
	PAY_PAYSGSOE_XMLP_PKG.CP_COUNTRY_p CP_COUNTRY,
	PAY_PAYSGSOE_XMLP_PKG.CP_GROSS_PAY_YTD_p CP_GROSS_PAY_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_STAT_DED_CURR_p CP_STAT_DED_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_STAT_DED_YTD_p CP_STAT_DED_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_OTHER_CURR_p CP_OTHER_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_OTHER_YTD_p CP_OTHER_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_NON_PAY_CURR_p CP_NON_PAY_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_NON_PAY_YTD_p CP_NON_PAY_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_NET_PAY_CURR_p CP_NET_PAY_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_NET_PAY_YTD_p CP_NET_PAY_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYEE_CPF_CURR_p CP_EMPLOYEE_CPF_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYEE_CPF_YTD_p CP_EMPLOYEE_CPF_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYER_CPF_CURR_p CP_EMPLOYER_CPF_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_EMPLOYER_CPF_YTD_p CP_EMPLOYER_CPF_YTD,
	PAY_PAYSGSOE_XMLP_PKG.CP_TOTAL_CPF_CURR_p CP_TOTAL_CPF_CURR,
	PAY_PAYSGSOE_XMLP_PKG.CP_TOTAL_CPF_YTD_p CP_TOTAL_CPF_YTD
from   pay_sg_asg_payment_runs_v
where business_group_id = :p_business_group_id
and     payroll_id              = :p_payroll_id
and     payroll_action_id   = :p_payroll_action_id
&cp_where_clause
&cp_order_by