PAY Statement Of Earnings (New Zealand)

select distinct registered_employer                                reg_employer_name,
           full_name                                                 emp_full_name,
           nvl(order_name, full_name)                                emp_order_name,
           assignment_number                                          ass_number,
           nvl(expense_check_send_to_address,'O') home_office_ind,
           location_id			location_id,
           location_code                                                       location_name,
           /* Removed for Bug #17207736
           cost_centre 			ass_cost_centre,
           cost_centre_proportion, */
           person_id			person_id,
           time_period_id                                          time_period_id,
           assignment_id                                          assignment_id,
           assignment_action_id                              assignment_action_id,
           run_assignment_action_id                       run_ass_action_id_link_from_q1,
           payroll_id                                                  payroll_id,
           salary,
           ird_number,
           to_char(date_earned,'dd-Mon-yyyy')                     date_earned,
           tax_code,
           to_char(pay_advice_date,'dd-Mon-yyyy')                 pay_date,
           period_number                                          period_num,
           to_char(period_start_date,'dd-Mon-yyyy')		period_start_date,
           to_char(period_end_date,'dd-Mon-yyyy')       period_end_date,
	PAY_PYNZSOE_XMLP_PKG.cf_get_miscellaneous_valuesfor(assignment_id, assignment_action_id, date_earned) CF_get_miscellaneous_values,
	PAY_PYNZSOE_XMLP_PKG.cf_net_this_payformula() CF_net_this_pay,
	PAY_PYNZSOE_XMLP_PKG.cf_net_ytdformula() CF_net_ytd,
	PAY_PYNZSOE_XMLP_PKG.f_get_detailsformula(assignment_number, assignment_id, date_earned, nvl ( expense_check_send_to_address , 'O' ), person_id, location_id) F_Get_Details
	,PAY_PYNZSOE_XMLP_PKG.P_Address_Line_1_p P_Address_Line_1,
	PAY_PYNZSOE_XMLP_PKG.P_Address_Line_2_p P_Address_Line_2,
	PAY_PYNZSOE_XMLP_PKG.P_Address_Line_3_p P_Address_Line_3,
	PAY_PYNZSOE_XMLP_PKG.P_Town_City_p P_Town_City,
	PAY_PYNZSOE_XMLP_PKG.P_PostCode_p P_PostCode,
	PAY_PYNZSOE_XMLP_PKG.P_Country_p P_Country,
	PAY_PYNZSOE_XMLP_PKG.P_Position_Name_p P_Position_Name,
    /* bug 18172201 begin */
	PAY_PYNZSOE_XMLP_PKG.P_Grade_Name_p P_Grade_Name,
	PAY_PYNZSOE_XMLP_PKG.P_Job_Name_p P_Job_Name,    
    /* bug 18172201 end */
	PAY_PYNZSOE_XMLP_PKG.CP_non_tax_allow_this_pay_p CP_non_tax_allow_this_pay,
	PAY_PYNZSOE_XMLP_PKG.CP_non_tax_allow_ytd_p CP_non_tax_allow_ytd,
	PAY_PYNZSOE_XMLP_PKG.CP_gross_ytd_p CP_gross_ytd,
	PAY_PYNZSOE_XMLP_PKG.CP_gross_this_pay_p CP_gross_this_pay,
	PAY_PYNZSOE_XMLP_PKG.CP_other_deductions_ytd_p CP_other_deductions_ytd,
	PAY_PYNZSOE_XMLP_PKG.CP_other_deductions_this_pay_p CP_other_deductions_this_pay,
	PAY_PYNZSOE_XMLP_PKG.CP_tax_deductions_ytd_p CP_tax_deductions_ytd,
	PAY_PYNZSOE_XMLP_PKG.CP_pre_tax_deductions_this_pa CP_pre_tax_deductions_this_pay,
	PAY_PYNZSOE_XMLP_PKG.CP_pre_tax_deductions_ytd_p CP_pre_tax_deductions_ytd,
	PAY_PYNZSOE_XMLP_PKG.CP_tax_deductions_this_pay_p CP_tax_deductions_this_pay,
	'A' dummy /*This is added because last function call was not executed*/
/*from_q1,
           payroll_id                                                  payroll_id,
           salary,
           ird_number,
          date_earned,
           tax_code,
           pay_advice_date                                      pay_date,
           period_number                                          period_num,
           period_start_date		period_start_date,
           period_end_date*/
from   pay_nz_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