292:
293: l_alias_sql VARCHAR2(5000) :=
294: 'SELECT hav.attribute1,hav.attribute2
295: FROM hxc_alias_definitions had,
296: hxc_alias_values hav
297: WHERE had.alias_definition_id IN ALIASLIST
298: AND hav.alias_definition_id = had.alias_definition_id
299: AND hav.attribute_category = ''PAYROLL_ELEMENTS''
300: AND hav.attribute2 IS NOT NULL
4478: SELECT 'Y'
4479: INTO p_absence_element_flag
4480: FROM hxc_absence_type_elements
4481: WHERE element_type_id in ( SELECT attribute1
4482: FROM hxc_alias_values
4483: WHERE alias_value_id = p_alias_value_id);
4484: IF g_debug THEN
4485: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4486: END IF;