ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3123869E053B46B63588994 select distinct ppa.assignment_id, PAY_PYAURECP_XMLP_PKG.assignment_action_id_p assignment_action_id, :lp_registered_employer tax_unit_id, 0 postjun83_tax, decode(pps.actual_termination_date,null,'C',decode(sign(pps.actual_termination_date - (:CP_fin_yr_end)),1,'C','T')) emp_type, pps.actual_termination_date term_date, PAY_PYAURECP_XMLP_PKG.DATE_EARNED_P date_earned, PAY_PYAURECP_XMLP_PKG.cf_calc_totalsformula(ppa.assignment_id, :lp_registered_employer, decode ( pps.actual_termination_date , null , 'C' , decode ( sign ( pps.actual_termination_date - ( :CP_fin_yr_end ) ) , 1 , 'C' , 'T' ) ), pps.actual_termination_date) CF_Calc_totals, PAY_PYAURECP_XMLP_PKG.cf_calc_group_totalsformula() CF_Calc_Group_Totals, PAY_PYAURECP_XMLP_PKG.MANUAL_PS_ISSUED_p MANUAL_PS_ISSUED, PAY_PYAURECP_XMLP_PKG.FOREIGN_PS_EXISTS_P FOREIGN_PS_EXISTS from per_assignments_f ppa, per_periods_of_service pps, pay_assignment_actions mpaa, pay_payroll_actions mppa where mppa.payroll_action_id=:LP_PAYROLL_ACTION_ID and mppa.payroll_action_id = mpaa.payroll_action_id and mppa.business_group_id = ppa.business_group_id and ppa.assignment_id = mpaa.assignment_id and ppa.period_of_service_id = pps.period_of_service_id and ppa.business_group_id = pps.business_group_id and ppa.business_group_id = :lp_business_group_id and nvl(pps.actual_termination_date, add_months(:CP_fin_yr_start,-12)) >= :CP_LST_YR_START AND ppa.effective_end_date = (SELECT max(effective_end_date) FROM per_assignments_f paf1 WHERE paf1.effective_end_date >= :CP_fbt_yr_start AND paf1.effective_start_date <= :CP_fin_yr_end AND paf1.business_group_id = :lp_business_group_id AND paf1.person_id = ppa.person_id and paf1.assignment_id = ppa.assignment_id ) &WHERECLAUSE --; Y PAY PYAURECPR_XML US PAY End of Year Reconciliation Summary Totals Application: Payroll Source: End of Year Reconciliation Summary Totals (XML) Short Name: PYAURECPR_XML DB package: PAY_PYAURECP_XMLP_PKG BI Publisher &whereclause :assignment_action_id :clause :cp_assgt_counter :cp_assgt_total :cp_assignment_number :cp_dimension :cp_emp_type :cp_fbt_global :cp_fbt_yr_end :cp_fbt_yr_start :cp_fin_yr_end :cp_fin_yr_start :cp_financial_year :cp_fw_total_allowance :cp_fw_total_ftid :cp_fw_total_gross :cp_fw_total_lumpsuma :cp_fw_total_lumpsumd :cp_fw_total_lumpsume :cp_fw_total_net_bal :cp_fw_total_resc :cp_fw_total_rfb :cp_fw_total_rfb_exempt :cp_fw_total_standard :cp_fw_total_sub_bal :cp_fw_total_tid :cp_fw_total_union_fees :cp_fw_total_workplace :cp_lst_yr_start :cp_lst_yr_term :cp_man_total_allowances :cp_man_total_assessable_income :cp_man_total_cdep :cp_man_total_curr_employees :cp_man_total_etp :cp_man_total_etp_tid :cp_man_total_foreign_income :cp_man_total_gross :cp_man_total_gross_etp :cp_man_total_jun_83_tax :cp_man_total_jun_83_unt :cp_man_total_jun_94_inv :cp_man_total_lumpsum_a_pay :cp_man_total_lumpsum_b_pay :cp_man_total_lumpsum_d_pay :cp_man_total_lumpsum_e_pay :cp_man_total_pre_jul_83 :cp_man_total_resc :cp_man_total_rfb :cp_man_total_rfb_exempt :cp_man_total_standard :cp_man_total_tax_free_comp :cp_man_total_taxable_comp :cp_man_total_term_employees :cp_man_total_tid :cp_man_total_union_fees :cp_man_total_workplace :cp_ml_global :cp_payroll_name :cp_reg_emp :cp_total_allowances :cp_total_assessable_income :cp_total_cdep :cp_total_current_employees :cp_total_etp :cp_total_etp_tid :cp_total_foreign_income :cp_total_gross :cp_total_gross_etp :cp_total_jun_83_tax :cp_total_jun_83_unt :cp_total_jun_94_inv :cp_total_lumpsum_a_pay :cp_total_lumpsum_b_pay :cp_total_lumpsum_d_pay :cp_total_lumpsum_e_pay :cp_total_net_bal :cp_total_pre_jul_83 :cp_total_resc :cp_total_rfb :cp_total_rfb_exempt :cp_total_standard :cp_total_tax_free_comp :cp_total_taxable_comp :cp_total_terminated_employees :cp_total_tid :cp_total_union_fees :cp_total_workplace :date_earned :foreign_ps_exists :lp_assignment_id :lp_assignment_set :lp_assignment_set_id :lp_business_group_id :lp_employee_type :lp_financial_year :lp_lst_yr_term :lp_payroll_action_id :lp_payroll_id :lp_registered_employer :manual_ps_issued :p_assignment_id :p_assignment_set_id :p_business_group_id :p_conc_request_id :p_employee_type :p_financial_year :p_lst_yr_term :p_payroll_action_id :p_payroll_id :p_registered_employer :whereclause