APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 236: EXISTS ( select 1 from hxc_time_attribute_usages usage,

232: l_att_table_dot_column VARCHAR2 (2000);
233: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
234: l_detail_exists VARCHAR2 (400)
235: := '
236: EXISTS ( select 1 from hxc_time_attribute_usages usage,
237: hxc_time_attributes att
238: where usage.time_building_Block_id = detail_block.time_building_block_id AND
239: usage.time_building_block_ovn = detail_block.object_version_number
240: and

Line 245: EXISTS ( select 1 from hxc_time_attribute_usages usage,

241: att.time_attribute_id = usage.time_attribute_id and
242: att.';
243: l_exists VARCHAR2 (400)
244: := '
245: EXISTS ( select 1 from hxc_time_attribute_usages usage,
246: hxc_time_attributes att
247: where usage.time_building_Block_id = timecard_block.time_building_block_id AND
248: usage.time_building_block_ovn = timecard_block.object_version_number
249: and

Line 5464: hxc_time_attribute_usages tau,

5460: ta.attribute23, ta.attribute24, ta.attribute25,
5461: ta.attribute26, ta.attribute27, ta.attribute28,
5462: ta.attribute29, ta.attribute30
5463: FROM hxc_tmp_bld_blks tmp,
5464: hxc_time_attribute_usages tau,
5465: hxc_time_attributes ta
5466: WHERE tau.time_building_block_id = tmp.time_building_block_id
5467: AND tau.time_building_block_ovn = tmp.time_building_block_ovn
5468: AND ta.time_attribute_id = tau.time_attribute_id

Line 6299: , Hxc_time_attribute_usages detail_usage

6295: FROM
6296: hxc_time_building_blocks timecard_block
6297: , hxc_time_building_blocks day_block
6298: , Hxc_time_building_blocks detail_block
6299: , Hxc_time_attribute_usages detail_usage
6300: , Hxc_time_attributes detail_att';
6301: l_inline_view_range VARCHAR2 (800)
6302: := '
6303: FROM

Line 6352: , Hxc_time_attribute_usages detail_usage

6348: l_noloop_from VARCHAR2 (250)
6349: := '
6350: ) tbb
6351: , Hxc_time_building_blocks detail_block
6352: , Hxc_time_attribute_usages detail_usage
6353: , Hxc_time_attributes detail_att
6354: , hxc_time_building_blocks day_block
6355: , hxc_time_building_blocks timecard_block
6356: , hxc_max_ovn detail_max_ovn';

Line 6362: , Hxc_time_attribute_usages detail_usage

6358: := '
6359: FROM
6360: hxc_retrieval_range_blks tbb
6361: , Hxc_time_building_blocks detail_block
6362: , Hxc_time_attribute_usages detail_usage
6363: , Hxc_time_attributes detail_att
6364: , hxc_time_building_blocks day_block
6365: , hxc_time_building_blocks timecard_block
6366: , hxc_latest_details hld

Line 6439: , hxc_time_attribute_usages detail_usage

6435: l_rerun VARCHAR2 (1100)
6436: := '
6437: FROM
6438: hxc_time_attributes detail_att
6439: , hxc_time_attribute_usages detail_usage
6440: , hxc_time_building_blocks detail_block
6441: , hxc_time_building_blocks day_block
6442: , hxc_time_attributes timecard_att
6443: , hxc_transaction_details txd