APPS.HXC_TIMECARD_HOURS_PKG dependencies on HXC_MAPPING_ATTRIBUTES_V

Line 107: -- this is not elegant. View hxc_mapping_attributes_v should include building_block_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.
109:
110: cursor csr_element_location is
111: select ma.context context,

Line 114: from hxc_mapping_attributes_v ma,

110: cursor csr_element_location is
111: select ma.context context,
112: ma.segment segment,
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

Line 311: from hxc_mapping_attributes_v ma,

307: cursor csr_element_location is
308: select ma.context context,
309: ma.segment segment,
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