APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on PAY_PAYROLLS_F

Line 8: p_tc_abs_payroll_id IN pay_payrolls_f.payroll_id%TYPE,

4: g_package varchar2(30) := 'hxc_absence_type_alias.';
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: PROCEDURE ins_otl_abs_type_elements_temp(p_tc_abs_type_alias_def_id IN hxc_alias_definitions_tl.alias_definition_id%TYPE,
8: p_tc_abs_payroll_id IN pay_payrolls_f.payroll_id%TYPE,
9: p_tc_abs_element_set_id IN pay_element_sets_tl.element_set_id%TYPE,
10: p_tc_abs_absence_type_id IN per_abs_attendance_types_tl.absence_attendance_type_id%TYPE) IS
11: PRAGMA AUTONOMOUS_TRANSACTION;
12:

Line 14: l_tc_abs_payroll_id pay_payrolls_f.payroll_id%TYPE;

10: p_tc_abs_absence_type_id IN per_abs_attendance_types_tl.absence_attendance_type_id%TYPE) IS
11: PRAGMA AUTONOMOUS_TRANSACTION;
12:
13: l_tc_abs_type_alias_def_id hxc_alias_definitions_tl.alias_definition_id%TYPE;
14: l_tc_abs_payroll_id pay_payrolls_f.payroll_id%TYPE;
15: l_tc_abs_element_set_id pay_element_sets_tl.element_set_id%TYPE;
16: l_tc_abs_absence_type_id per_abs_attendance_types_tl.absence_attendance_type_id%TYPE;
17:
18: l_proc VARCHAR2(100);

Line 114: FROM pay_payrolls_f papf,

110:
111: DELETE hxc_absence_type_elements_temp haet
112: WHERE haet.element_type_id NOT IN
113: (SELECT pelf.element_type_id
114: FROM pay_payrolls_f papf,
115: pay_element_links_f pelf
116: WHERE papf.payroll_id = pelf.payroll_id
117: AND papf.payroll_id = l_tc_abs_payroll_id);
118: