APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on PAY_ELEMENT_SETS

Line 9: p_tc_abs_element_set_id IN pay_element_sets_tl.element_set_id%TYPE,

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:
13: l_tc_abs_type_alias_def_id hxc_alias_definitions_tl.alias_definition_id%TYPE;

Line 15: l_tc_abs_element_set_id pay_element_sets_tl.element_set_id%TYPE;

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);
19:

Line 126: FROM pay_element_sets_tl pest,

122:
123: DELETE hxc_absence_type_elements_temp haet
124: WHERE haet.element_type_id NOT IN
125: (SELECT petr.element_type_id
126: FROM pay_element_sets_tl pest,
127: pay_element_sets pes,
128: pay_element_type_rules petr
129: WHERE pest.element_set_id = pes.element_set_id
130: AND pes.element_set_id = petr.element_set_id

Line 127: pay_element_sets pes,

123: DELETE hxc_absence_type_elements_temp haet
124: WHERE haet.element_type_id NOT IN
125: (SELECT petr.element_type_id
126: FROM pay_element_sets_tl pest,
127: pay_element_sets pes,
128: pay_element_type_rules petr
129: WHERE pest.element_set_id = pes.element_set_id
130: AND pes.element_set_id = petr.element_set_id
131: AND pes.element_set_id = l_tc_abs_element_set_id