APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_SOC_BEN_DETAILS

Line 4594: ,pay_ie_p45_soc_ben_details emp_soc

4590: ,pay_assignment_actions paa_payroll
4591: ,per_time_periods ptp
4592: ,pay_ie_p45_address_details emp_address
4593: ,pay_ie_p45_employee_details emp_details
4594: ,pay_ie_p45_soc_ben_details emp_soc
4595: ,pay_ie_p45_prsi_details emp_prsi
4596: ,pay_ie_p45_paye_details emp_paye
4597: ,pay_ie_p45_supp_details emp_supp
4598: WHERE paa.payroll_action_id = c_p45_arch_id

Line 4683: FROM pay_ie_p45_soc_ben_details emp_soc

4679: SELECT (round(to_number(nvl(emp_soc.disability_benefit,'0')),2)*100) benefit
4680: ,(round(to_number(nvl(emp_soc.red_tax_credit,'0')),2)*100) taxcreditreduction
4681: ,(round(to_number(nvl(emp_soc.red_std_cut_off,'0')),2)*100) cutoffreduction
4682: ,emp_soc.non_cummulative_basis noncumulative
4683: FROM pay_ie_p45_soc_ben_details emp_soc
4684: WHERE emp_soc.assignment_action_id = p_assignment_action_id;
4685: cur_p45_emp_soc_details_rec cur_p45_emp_soc_details%ROWTYPE;
4686: --
4687: --6615117