APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_ABSENCE_TYPE_ELEMENTS

Line 2586: FROM hxc_absence_type_elements

2582: IS
2583:
2584: CURSOR get_edit_status(p_element_type IN NUMBER)
2585: IS SELECT edit_flag,uom
2586: FROM hxc_absence_type_elements
2587: WHERE element_type_id = p_element_type;
2588:
2589:
2590: -- Bug 8829122

Line 2845: FROM hxc_absence_type_elements

2841: l_count NUMBER;
2842:
2843: CURSOR pick_abs_type(p_element IN NUMBER)
2844: IS SELECT 1
2845: FROM hxc_absence_type_elements
2846: WHERE element_type_id = p_element;
2847:
2848:
2849: BEGIN

Line 4330: FROM hxc_absence_type_elements hxc,

4326: INTO l_abs_type_id,
4327: l_inc_dec,
4328: l_name,
4329: l_uom
4330: FROM hxc_absence_type_elements hxc,
4331: per_absence_attendance_types per,
4332: per_abs_attendance_types_tl pertl
4333: WHERE hxc.element_type_id = p_element_type_id
4334: AND hxc.absence_attendance_type_id = per.absence_attendance_type_id

Line 4480: FROM hxc_absence_type_elements

4476: END IF;
4477:
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