APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_TIME_ATTRIBUTE_USAGES

Line 251: EXISTS ( select 1 from hxc_time_attribute_usages usage,

247: l_att_table_dot_column VARCHAR2 (2000);
248: l_info_type_id hxc_bld_blk_info_types.bld_blk_info_type_id%TYPE;
249: l_detail_exists VARCHAR2 (400)
250: := '
251: EXISTS ( select 1 from hxc_time_attribute_usages usage,
252: hxc_time_attributes att
253: where usage.time_building_Block_id = detail_block.time_building_block_id AND
254: usage.time_building_block_ovn = detail_block.object_version_number
255: and

Line 260: EXISTS ( select 1 from hxc_time_attribute_usages usage,

256: att.time_attribute_id = usage.time_attribute_id and
257: att.';
258: l_exists VARCHAR2 (400)
259: := '
260: EXISTS ( select 1 from hxc_time_attribute_usages usage,
261: hxc_time_attributes att
262: where usage.time_building_Block_id = timecard_block.time_building_block_id AND
263: usage.time_building_block_ovn = timecard_block.object_version_number
264: and

Line 6199: hxc_time_attribute_usages tau,

6195: ta.attribute23, ta.attribute24, ta.attribute25,
6196: ta.attribute26, ta.attribute27, ta.attribute28,
6197: ta.attribute29, ta.attribute30
6198: FROM hxc_tmp_bld_blks tmp,
6199: hxc_time_attribute_usages tau,
6200: hxc_time_attributes ta
6201: WHERE tau.time_building_block_id = tmp.time_building_block_id
6202: AND tau.time_building_block_ovn = tmp.time_building_block_ovn
6203: AND ta.time_attribute_id = tau.time_attribute_id

Line 7034: , Hxc_time_attribute_usages detail_usage

7030: FROM
7031: hxc_time_building_blocks timecard_block
7032: , hxc_time_building_blocks day_block
7033: , Hxc_time_building_blocks detail_block
7034: , Hxc_time_attribute_usages detail_usage
7035: , Hxc_time_attributes detail_att';
7036: l_inline_view_range VARCHAR2 (800)
7037: := '
7038: FROM

Line 7192: , Hxc_time_attribute_usages detail_usage

7188: l_noloop_from VARCHAR2 (250)
7189: := '
7190: ) tbb
7191: , Hxc_time_building_blocks detail_block
7192: , Hxc_time_attribute_usages detail_usage
7193: , Hxc_time_attributes detail_att
7194: , hxc_time_building_blocks day_block
7195: , hxc_time_building_blocks timecard_block
7196: , hxc_max_ovn detail_max_ovn';

Line 7202: , Hxc_time_attribute_usages detail_usage

7198: := '
7199: FROM
7200: hxc_retrieval_range_blks tbb
7201: , Hxc_time_building_blocks detail_block
7202: , Hxc_time_attribute_usages detail_usage
7203: , Hxc_time_attributes detail_att
7204: , hxc_time_building_blocks day_block
7205: , hxc_time_building_blocks timecard_block
7206: , hxc_latest_details hld

Line 7223: , Hxc_time_attribute_usages detail_usage

7219: := '
7220: FROM
7221: hxc_retrieval_range_blks tbb
7222: , Hxc_time_building_blocks detail_block
7223: , Hxc_time_attribute_usages detail_usage
7224: , Hxc_time_attributes detail_att
7225: , hxc_time_building_blocks day_block
7226: , hxc_time_building_blocks timecard_block
7227: , hxc_pa_latest_details hld

Line 7235: , Hxc_time_attribute_usages detail_usage

7231: := '
7232: FROM
7233: hxc_retrieval_range_blks tbb
7234: , Hxc_time_building_blocks detail_block
7235: , Hxc_time_attribute_usages detail_usage
7236: , Hxc_time_attributes detail_att
7237: , hxc_time_building_blocks day_block
7238: , hxc_time_building_blocks timecard_block
7239: , hxc_pay_latest_details hld

Line 7306: , hxc_time_attribute_usages detail_usage

7302: l_rerun VARCHAR2 (1100)
7303: := '
7304: FROM
7305: hxc_time_attributes detail_att
7306: , hxc_time_attribute_usages detail_usage
7307: , hxc_time_building_blocks detail_block
7308: , hxc_time_building_blocks day_block
7309: , hxc_time_attributes timecard_att
7310: , hxc_transaction_details txd