APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on HXC_ALIAS_DEFINITIONS_TL

Line 7: PROCEDURE ins_otl_abs_type_elements_temp(p_tc_abs_type_alias_def_id IN hxc_alias_definitions_tl.alias_definition_id%TYPE,

3:
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;

Line 13: l_tc_abs_type_alias_def_id hxc_alias_definitions_tl.alias_definition_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;
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:

Line 94: FROM hxc_alias_definitions_tl hadt,

90:
91: DELETE hxc_absence_type_elements_temp haet
92: WHERE to_char(haet.element_type_id) NOT IN
93: (SELECT hav.attribute1
94: FROM hxc_alias_definitions_tl hadt,
95: hxc_alias_definitions had,
96: hxc_alias_values hav
97: WHERE had.alias_context_code = 'PAYROLL_ELEMENTS'
98: AND hadt.alias_definition_id = had.alias_definition_id

Line 210: FROM hxc_alias_definitions_tl

206: BEGIN
207:
208: SELECT 'Y'
209: INTO l_exists
210: FROM hxc_alias_definitions_tl
211: WHERE alias_definition_name = l_alias_definition_name
212: AND LANGUAGE = userenv('LANG');
213:
214: IF g_debug THEN