APPS.HXC_TIMECARD_HOURS_PKG dependencies on HXC_BLD_BLK_INFO_TYPE_USAGES

Line 104: (select BLD_BLK_INFO_TYPE_ID from HXC_BLD_BLK_INFO_TYPE_USAGES

100: and tau_det.time_building_block_ovn = tbb_det.object_version_number
101: and tau_det.time_attribute_id = ta_det.time_attribute_id
102: and ta_det.attribute_category = nvl(p_element_context,ta_det.attribute_category)
103: and ta_det.BLD_BLK_INFO_TYPE_ID in
104: (select BLD_BLK_INFO_TYPE_ID from HXC_BLD_BLK_INFO_TYPE_USAGES
105: where BUILDING_BLOCK_CATEGORY=p_element_category);
106:
107: -- this is not elegant. View hxc_mapping_attributes_v should include building_block_category
108: -- so this can be tidied up.

Line 117: hxc_bld_blk_info_type_usages bbitu

113: bbitu.building_block_category category
114: from hxc_mapping_attributes_v ma,
115: hxc_deposit_processes dp,
116: hxc_mappings mp,
117: hxc_bld_blk_info_type_usages bbitu
118: where ma.map = mp.name
119: and mp.mapping_id = dp.mapping_id
120: and dp.name = 'OTL Deposit Process'
121: and ma.field_name = 'Dummy Element Context'

Line 127: l_element_category hxc_bld_blk_info_type_usages.building_block_category%TYPE;

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;
130: l_element_count number;
131:

Line 303: (select BLD_BLK_INFO_TYPE_ID from HXC_BLD_BLK_INFO_TYPE_USAGES

299: and tau_det.time_building_block_ovn = tbb_det.object_version_number
300: and tau_det.time_attribute_id = ta_det.time_attribute_id
301: and ta_det.attribute_category = nvl(p_element_context,ta_det.attribute_category)
302: and ta_det.BLD_BLK_INFO_TYPE_ID in
303: (select BLD_BLK_INFO_TYPE_ID from HXC_BLD_BLK_INFO_TYPE_USAGES
304: where BUILDING_BLOCK_CATEGORY=p_element_category);
305:
306:
307: cursor csr_element_location is

Line 314: hxc_bld_blk_info_type_usages bbitu

310: bbitu.building_block_category category
311: from hxc_mapping_attributes_v ma,
312: hxc_deposit_processes dp,
313: hxc_mappings mp,
314: hxc_bld_blk_info_type_usages bbitu
315: where ma.map = mp.name
316: and mp.mapping_id = dp.mapping_id
317: and dp.name = 'OTL Deposit Process'
318: and ma.field_name = 'Dummy Element Context'

Line 324: l_element_category hxc_bld_blk_info_type_usages.building_block_category%TYPE;

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;
327: l_element_count number;
328: