ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN 82288223F3133869E053B46B63588994 SELECT PAI_ASG.ASSIGNMENT_ID PAI_ASG_ASSIGNMENT_ID, substr(PAI_ASG.ACTION_INFORMATION1,1,80) PAI_ASG_Full_name , PAI_ASG.ACTION_INFORMATION2 PAI_ASG_Assignment_Number, PAI_ASG.ACTION_INFORMATION3 PAI_ASG_Salary, PAI_ASG.ACTION_INFORMATION4 PAI_ASG_Grade_Step, PAI_ASG.ACTION_INFORMATION5 PAI_ASG_Standard_Hours, PAI_ASG.ACTION_INFORMATION6 PAI_ASG_Termination_Date, PAI_ASG.ACTION_INFORMATION7 PAI_ASG_Manual_PS_Year, PAI_ASG.ACTION_INFORMATION11 PAI_ASG_Organization_Name, PAI_ASG.ACTION_INFORMATION12 PAI_ASG_Legal_Employer_Name, PAI_ASG.ACTION_INFORMATION13 PAI_ASG_Payroll_Name, decode(PAI_ASG.ACTION_INFORMATION7,null,'N','Y') MANUAL_PS_ISSUED, PAY_PYAURECD_XMLP_PKG.cf_return_balancesformula(:ASG_TE, :ASG_NTE, :ASG_DED, :ASG_TAX, :ASG_NET, :ASG_CHG, :ASG_GE, :ASG_PT_DED, :ASG_DPAY, :ASG_GE_YTD, :ASG_PTDED_YTD, :ASG_DPAY_YTD, :ASG_TE_YTD, :ASG_NTE_YTD, :ASG_DED_YTD, :ASG_TAX_YTD, :ASG_NET_YTD, :ASG_CHG_YTD, decode ( PAI_ASG.ACTION_INFORMATION7 , null , 'N' , 'Y' ), :CS_PS_PSG, :CS_PS_WG, :CS_PS_RA, :CS_PS_ETP, :CS_PS_RFB, :CS_PS_AETP, :CS_PS_CDEP, :CS_PS_OI, :CS_PS_UF, :CS_PS_LPAY, :ASG_DNT, :ASG_DNT_YTD) CF_RETURN_BALANCES, PAY_PYAURECD_XMLP_PKG.CP_TAXABLE_EARNINGS_p CP_TAXABLE_EARNINGS, PAY_PYAURECD_XMLP_PKG.CP_NON_TAXABLE_EARNINGS_p CP_NON_TAXABLE_EARNINGS, PAY_PYAURECD_XMLP_PKG.CP_DEDUCTIONS_p CP_DEDUCTIONS, PAY_PYAURECD_XMLP_PKG.CP_PRE_TAX_DEDUCTIONS_p CP_PRE_TAX_DEDUCTIONS, PAY_PYAURECD_XMLP_PKG.CP_DIRECT_PAYMENTS_p CP_DIRECT_PAYMENTS, PAY_PYAURECD_XMLP_PKG.CP_TAX_p CP_TAX, PAY_PYAURECD_XMLP_PKG.CP_GROSS_EARNINGS_p CP_GROSS_EARNINGS, PAY_PYAURECD_XMLP_PKG.CP_NET_PAYMENT_p CP_NET_PAYMENT, PAY_PYAURECD_XMLP_PKG.CP_YTD_TAXABLE_EARNINGS_p CP_YTD_TAXABLE_EARNINGS, PAY_PYAURECD_XMLP_PKG.CP_YTD_NON_TAXABLE_EARNINGS_p CP_YTD_NON_TAXABLE_EARNINGS, PAY_PYAURECD_XMLP_PKG.CP_YTD_GROSS_EARNINGS_p CP_YTD_GROSS_EARNINGS, PAY_PYAURECD_XMLP_PKG.CP_YTD_PRE_TAX_DEDUCTIONS_p CP_YTD_PRE_TAX_DEDUCTIONS, PAY_PYAURECD_XMLP_PKG.CP_YTD_DIRECT_PAYMENTS_p CP_YTD_DIRECT_PAYMENTS, PAY_PYAURECD_XMLP_PKG.CP_YTD_DEDUCTIONS_p CP_YTD_DEDUCTIONS, PAY_PYAURECD_XMLP_PKG.CP_YTD_TAX_p CP_YTD_TAX, PAY_PYAURECD_XMLP_PKG.CP_YTD_NET_PAYMENT_p CP_YTD_NET_PAYMENT, PAY_PYAURECD_XMLP_PKG.CP_EMP_CHG_p CP_EMP_CHG, PAY_PYAURECD_XMLP_PKG.CP_YTD_EMP_CHG_p CP_YTD_EMP_CHG, PAY_PYAURECD_XMLP_PKG.CP_ASG_DEATH_NON_TAX_p CP_ASG_DEATH_NON_TAX_EARN, PAY_PYAURECD_XMLP_PKG.CP_ASG_YTD_DEATH_NON_TAX_p CP_ASG_YTD_DEATH_NON_TAX_EARN FROM PAY_ACTION_INFORMATION PAI_ASG --WHERE PAI_ASG.ACTION_CONTEXT_ID = :P_PAYROLL_ACTION_ID WHERE PAI_ASG.ACTION_CONTEXT_ID = :LP_PAYROLL_ACTION_ID AND PAI_ASG.ACTION_INFORMATION_CATEGORY = 'AU_EMPLOYEE_RECON_DETAILS' AND PAI_ASG.ACTION_CONTEXT_TYPE = 'PA' &orderby_clause --; Y PAY PYAUREPSR_XML US PAY End of Year Reconciliation Detail Application: Payroll Source: End of Year Reconciliation Detail (XML) Short Name: PYAUREPSR_XML DB package: PAY_PYAURECD_XMLP_PKG BI Publisher &orderby_clause :asg_chg :asg_chg_ytd :asg_ded :asg_ded_ytd :asg_dnt :asg_dnt_ytd :asg_dpay :asg_dpay_ytd :asg_ge :asg_ge_ytd :asg_net :asg_net_ytd :asg_nte :asg_nte_ytd :asg_pt_ded :asg_ptded_ytd :asg_tax :asg_tax_ytd :asg_te :asg_te_ytd :cp_asg_death_non_tax_earn :cp_asg_ytd_death_non_tax_earn :cp_deductions :cp_direct_payments :cp_emp_chg :cp_end_report :cp_gross_earnings :cp_input_value_name :cp_man_ps_assessable_etp :cp_man_ps_cdep :cp_man_ps_etp :cp_man_ps_lumpsum_payments :cp_man_ps_other_income :cp_man_ps_paysum_gross :cp_man_ps_rep_allowances :cp_man_ps_rfb :cp_man_ps_union_fees :cp_man_ps_workplace_giving :cp_manual_count :cp_net_payment :cp_no_data_found :cp_non_taxable_earnings :cp_pre_tax_deductions :cp_printed_count :cp_ps_assessable_etp :cp_ps_cdep :cp_ps_etp :cp_ps_lumpsum_payments :cp_ps_other_income :cp_ps_paysum_gross :cp_ps_rep_allowances :cp_ps_rfb :cp_ps_union_fees :cp_ps_workplace_giving :cp_tax :cp_taxable_earnings :cp_uom :cp_ytd_deductions :cp_ytd_direct_payments :cp_ytd_emp_chg :cp_ytd_gross_earnings :cp_ytd_net_payment :cp_ytd_non_taxable_earnings :cp_ytd_pre_tax_deductions :cp_ytd_tax :cp_ytd_taxable_earnings :cs_ps_aetp :cs_ps_cdep :cs_ps_etp :cs_ps_lpay :cs_ps_oi :cs_ps_psg :cs_ps_ra :cs_ps_rfb :cs_ps_uf :cs_ps_wg :lp_assignment_id :lp_assignment_set :lp_assignment_set_id :lp_business_group_id :lp_delete_actions :lp_employee_type :lp_end_date :lp_end_date_d :lp_lst_year_term :lp_negative_records :lp_organization_id :lp_payroll_action_id :lp_payroll_id :lp_payroll_run_id :lp_paysum_flag :lp_period_end_date :lp_period_end_date_d :lp_registered_employer :lp_sort_order_1 :lp_sort_order_2 :lp_sort_order_3 :lp_sort_order_4 :lp_start_date :lp_start_date_d :lp_ytd_totals :lp_zero_records :orderby_clause :p_assignment_id :p_assignment_set_id :p_business_group_id :p_conc_request_id :p_delete_actions :p_employee_type :p_end_date :p_lst_year_term :p_negative_records :p_organization_id :p_payroll_action_id :p_payroll_id :p_payroll_run_id :p_paysum_flag :p_period_end_date :p_registered_employer :p_sort_order_1 :p_sort_order_2 :p_sort_order_3 :p_sort_order_4 :p_start_date :p_ytd_totals :p_zero_records