APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on PER_ABS_ATTENDANCE_TYPES_TL

Line 10: p_tc_abs_absence_type_id IN per_abs_attendance_types_tl.absence_attendance_type_id%TYPE) IS

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;
14: l_tc_abs_payroll_id pay_payrolls_f.payroll_id%TYPE;

Line 16: l_tc_abs_absence_type_id per_abs_attendance_types_tl.absence_attendance_type_id%TYPE;

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:
20: BEGIN

Line 66: per_abs_attendance_types_tl paatt,

62: acl.lookup_code absence_category,
63: acl.meaning absence_category_meaning
64: FROM hxc_absence_type_elements hae,
65: per_absence_attendance_types paat,
66: per_abs_attendance_types_tl paatt,
67: pay_element_types_f petf,
68: pay_element_types_f_tl petft,
69: hr_lookups ntl, -- NAME_TRANSLATIONS
70: hr_lookups acl -- ABSENCE_CATEGORY

Line 146: FROM per_abs_attendance_types_tl paatt,

142:
143: DELETE hxc_absence_type_elements_temp haet
144: WHERE haet.element_type_id NOT IN
145: (SELECT pivf.element_type_id
146: FROM per_abs_attendance_types_tl paatt,
147: per_absence_attendance_types paat,
148: pay_input_values_f pivf
149: WHERE paatt.absence_attendance_type_id = paat.absence_attendance_type_id
150: AND paat.absence_attendance_type_id = l_tc_abs_absence_type_id