APPS.HXC_TIMECARD_HOURS_PKG dependencies on HXC_TIME_ATTRIBUTES

Line 91: hxc_time_attributes ta_det

87: tbb_det.scope
88: FROM hxc_time_building_blocks tbb_day,
89: hxc_time_building_blocks tbb_det,
90: hxc_time_attribute_usages tau_det,
91: hxc_time_attributes ta_det
92: WHERE tbb_det.scope = 'DETAIL'
93: and tbb_day.scope = 'DAY'
94: and tbb_det.date_to = hr_general.end_of_time
95: and tbb_det.parent_building_block_ovn = tbb_day.object_version_number

Line 125: l_element_context hxc_time_attributes.attribute_category%TYPE;

121: and ma.field_name = 'Dummy Element Context'
122: and bbitu.bld_blk_info_type_id=ma.bld_blk_info_type_id;
123:
124: l_running_total number;
125: l_element_context hxc_time_attributes.attribute_category%TYPE;
126: l_element_segment VARCHAR2(30);
127: l_element_category hxc_bld_blk_info_type_usages.building_block_category%TYPE;
128:
129: l_element_ids t_element_ids;

Line 288: hxc_time_attributes ta_det

284: tbb_det.scope
285: FROM hxc_time_building_blocks tbb_day,
286: hxc_time_building_blocks tbb_det,
287: hxc_time_attribute_usages tau_det,
288: hxc_time_attributes ta_det
289: WHERE tbb_det.scope = 'DETAIL'
290: and tbb_day.scope = 'DAY'
291: and tbb_day.date_to = hr_general.end_of_time
292: and tbb_det.date_to = hr_general.end_of_time

Line 322: l_element_context hxc_time_attributes.attribute_category%TYPE;

318: and ma.field_name = 'Dummy Element Context'
319: and bbitu.bld_blk_info_type_id=ma.bld_blk_info_type_id;
320:
321: l_running_total number;
322: l_element_context hxc_time_attributes.attribute_category%TYPE;
323: l_element_segment VARCHAR2(30);
324: l_element_category hxc_bld_blk_info_type_usages.building_block_category%TYPE;
325:
326: l_element_ids t_element_ids;