APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on HXC_ABSENCE_TYPE_ELEMENTS_TEMP

Line 43: DELETE FROM hxc_absence_type_elements_temp;

39: hr_utility.trace('ABS:l_tc_abs_absence_type_id ::'||l_tc_abs_absence_type_id);
40: END IF;
41:
42:
43: DELETE FROM hxc_absence_type_elements_temp;
44:
45: INSERT INTO hxc_absence_type_elements_temp
46: (absence_attendance_type_id
47: ,absence_attendance_type_name

Line 45: INSERT INTO hxc_absence_type_elements_temp

41:
42:
43: DELETE FROM hxc_absence_type_elements_temp;
44:
45: INSERT INTO hxc_absence_type_elements_temp
46: (absence_attendance_type_id
47: ,absence_attendance_type_name
48: ,element_type_id
49: ,element_name

Line 91: DELETE hxc_absence_type_elements_temp haet

87:
88:
89: IF l_tc_abs_type_alias_def_id IS NOT NULL THEN
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,

Line 111: DELETE hxc_absence_type_elements_temp haet

107: END IF;
108:
109: IF l_tc_abs_payroll_id IS NOT NULL THEN
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

Line 123: DELETE hxc_absence_type_elements_temp haet

119: END IF;
120:
121: IF l_tc_abs_element_set_id IS NOT NULL THEN
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,

Line 143: DELETE hxc_absence_type_elements_temp haet

139: END IF;
140:
141: IF l_tc_abs_absence_type_id IS NOT NULL THEN
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,