APPS.HXC_SELF_SERVICE_TIME_DEPOSIT dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 1044: ,hxc_time_attribute_usages tau

1040: ,p_time_building_block_id in number
1041: ) is
1042: select 'Y'
1043: from hxc_time_building_blocks tbb
1044: ,hxc_time_attribute_usages tau
1045: ,hxc_time_attributes ta
1046: where ta.time_attribute_id = tau.time_attribute_id
1047: and tau.time_building_block_id = tbb.time_building_block_id
1048: and tau.time_building_block_ovn = tbb.object_version_number

Line 1062: ,hxc_time_attribute_usages tau

1058: (p_name_to_check in varchar2
1059: ,p_time_building_block_id in number) is
1060: select 'Y'
1061: from hxc_time_building_blocks tbb
1062: ,hxc_time_attribute_usages tau
1063: ,hxc_time_attributes ta
1064: where ta.time_attribute_id = tau.time_attribute_id
1065: and tau.time_building_block_id = tbb.time_building_block_id
1066: and tau.time_building_block_ovn = tbb.object_version_number

Line 5074: from hxc_time_attribute_usages tau,

5070: ,ta.ATTRIBUTE29 ta_ATTRIBUTE29
5071: ,ta.ATTRIBUTE30 ta_ATTRIBUTE30
5072: ,ta.BLD_BLK_INFO_TYPE_ID ta_INFO_TYPE
5073: ,ta.OBJECT_VERSION_NUMBER ta_OVN
5074: from hxc_time_attribute_usages tau,
5075: hxc_time_attributes ta,
5076: hxc_bld_blk_info_types bbit
5077: where tau.time_building_block_id = p_tbb_id
5078: and tau.time_building_block_ovn = p_tbb_ovn

Line 5166: hxc_time_attribute_usages tau

5162: cursor get_template_details(p_time_building_block_id in number)
5163: is
5164: select attribute2||'|'||tau.time_building_block_id
5165: from hxc_time_attributes ta,
5166: hxc_time_attribute_usages tau
5167: where ta.time_attribute_id=tau.time_attribute_id
5168: and ta.attribute_category='TEMPLATES'
5169: and tau.time_building_block_id=p_time_building_block_id;
5170:

Line 5655: hxc_time_attribute_usages htau,

5651: hta.attribute28, hta.attribute29, hta.attribute30,
5652: hta.bld_blk_info_type_id, hta.object_version_number, 'N' NEW,
5653: 'N' changed, 'N' process
5654: FROM hxc_time_attributes hta,
5655: hxc_time_attribute_usages htau,
5656: hxc_bld_blk_info_types hbbit
5657: WHERE htau.time_building_block_id = p_build_block_id
5658: AND htau.time_building_block_ovn = p_build_block_ovn
5659: AND htau.time_attribute_id = hta.time_attribute_id