DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_EMPLOYEE_DETAILS

Line 4593: ,pay_ie_p45_employee_details emp_details

4589: ,pay_action_interlocks pai_arc
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

Line 4702: FROM pay_ie_p45_employee_details emp_details

4698: ,emp_details.address_line2 address_line2
4699: ,emp_details.address_line3 address_line3
4700: ,emp_details.address_line4 address_line4
4701: ,emp_details.kin_name kin_name
4702: FROM pay_ie_p45_employee_details emp_details
4703: WHERE emp_details.assignment_action_id = p_assignment_action_id;
4704: cur_p45_emp_details_rec cur_p45_emp_details%ROWTYPE;
4705: --
4706: CURSOR cur_p45_emp_address (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS