APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_TIME_ATTRIBUTES

Line 2833: hxc_time_attributes hta

2829: CURSOR pick_old_attribute(p_bb_id IN NUMBER,
2830: p_bb_ovn IN NUMBER)
2831: IS SELECT REPLACE(hta.attribute_category,'ELEMENT - ')
2832: FROM hxc_time_attribute_usages hau,
2833: hxc_time_attributes hta
2834: WHERE hau.time_building_block_id = p_bb_id
2835: AND hau.time_building_block_ovn = p_bb_ovn
2836: AND hta.time_attribute_id = hau.time_attribute_id
2837: AND hta.bld_blk_info_type_id = g_bld_blk_info;