APPS.HXC_BUILDING_BLOCK_API dependencies on HXC_TIME_ATTRIBUTES

Line 59: hxc_time_attributes ta,

55: p_block_ovn hxc_time_building_blocks.object_version_number%type) is
56: select tau.time_attribute_id,
57: tbb.data_set_id
58: from hxc_time_attribute_usages tau,
59: hxc_time_attributes ta,
60: hxc_time_building_blocks tbb
61: where tau.time_building_block_id = p_block_id
62: and tau.time_building_block_ovn = p_block_ovn
63: and tau.time_building_block_id = tbb.time_building_block_id

Line 708: hxc_time_attributes hta

704:
705: cursor c_time_attribute_usage(p_ovn number, p_building_block_id number) is
706: SELECT htau.time_attribute_id time_attribute_id
707: FROM hxc_time_attribute_usages htau ,
708: hxc_time_attributes hta
709: WHERE htau.time_building_block_ovn = p_ovn
710: AND htau.time_building_block_id = p_building_block_id
711: AND hta.time_attribute_id = htau.time_attribute_id
712: AND hta.ATTRIBUTE_CATEGORY <> 'REASON';