APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_SOC_BEN_DETAILS

Line 3671: ,pay_ie_p45_soc_ben_details emp_soc

3667: ,pay_assignment_actions paa_payroll
3668: ,per_time_periods ptp
3669: ,pay_ie_p45_address_details emp_address
3670: ,pay_ie_p45_employee_details emp_details
3671: ,pay_ie_p45_soc_ben_details emp_soc
3672: ,pay_ie_p45_prsi_details emp_prsi
3673: ,pay_ie_p45_paye_details emp_paye
3674: ,pay_ie_p45_supp_details emp_supp
3675: WHERE paa.payroll_action_id = c_p45_arch_id

Line 3756: FROM pay_ie_p45_soc_ben_details emp_soc

3752: SELECT (round(to_number(nvl(emp_soc.disability_benefit,'0')),2)*100) benefit
3753: ,(round(to_number(nvl(emp_soc.red_tax_credit,'0')),2)*100) taxcreditreduction
3754: ,(round(to_number(nvl(emp_soc.red_std_cut_off,'0')),2)*100) cutoffreduction
3755: ,emp_soc.non_cummulative_basis noncumulative
3756: FROM pay_ie_p45_soc_ben_details emp_soc
3757: WHERE emp_soc.assignment_action_id = p_assignment_action_id;
3758: cur_p45_emp_soc_details_rec cur_p45_emp_soc_details%ROWTYPE;
3759: --
3760: --6615117