DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_ADDRESS_DETAILS

Line 4592: ,pay_ie_p45_address_details emp_address

4588: ,pay_assignment_actions paa
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

Line 4710: FROM pay_ie_p45_address_details emp_address

4706: CURSOR cur_p45_emp_address (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS
4707: SELECT emp_address.address1 address1
4708: ,emp_address.address2 address2
4709: ,emp_address.address3 address3
4710: FROM pay_ie_p45_address_details emp_address
4711: WHERE emp_address.assignment_action_id = p_assignment_action_id;
4712: cur_p45_emp_address_rec cur_p45_emp_address%ROWTYPE;
4713: --
4714: CURSOR cur_p45_paye_prsi_details (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS