DBA Data[Home] [Help]

APPS.PAY_IE_P45_ARCHIVE dependencies on PAY_IE_P45_EMPLOYEE_DETAILS

Line 3670: ,pay_ie_p45_employee_details emp_details

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

Line 3770: FROM pay_ie_p45_employee_details emp_details

3766: ,emp_details.deceased deceased
3767: ,to_char(emp_details.date_of_birth,'dd/mm/rrrr') dob
3768: ,to_char(emp_details.date_of_commencement,'dd/mm/rrrr') start1
3769: ,to_char(emp_details.date_of_leaving,'dd/mm/rrrr') end1
3770: FROM pay_ie_p45_employee_details emp_details
3771: WHERE emp_details.assignment_action_id = p_assignment_action_id;
3772: cur_p45_emp_details_rec cur_p45_emp_details%ROWTYPE;
3773: --
3774: CURSOR cur_p45_emp_address (p_assignment_action_id pay_assignment_actions.assignment_action_id%TYPE )IS