APPS.HXC_ABSENCE_TYPE_ALIAS dependencies on PAY_ELEMENT_TYPE_RULES
Line 128: pay_element_type_rules petr
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
132: AND pes.element_set_type = 'R'