APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_LATEST_DETAILS

Line 609: FROM hxc_latest_details tbb

605: l_range_caveat BOOLEAN := FALSE;
606: l_root VARCHAR2 (1500)
607: := '
608: SELECT DISTINCT tbb.resource_id
609: FROM hxc_latest_details tbb
610: WHERE tbb.last_update_date > :p_since_date ';
611:
612: l_root_day VARCHAR2 (1500)
613: := '

Line 615: FROM hxc_latest_details tbb

611:
612: l_root_day VARCHAR2 (1500)
613: := '
614: SELECT DISTINCT tbb.resource_id
615: FROM hxc_latest_details tbb
616: WHERE tbb.last_update_date > :p_since_date ';
617:
618: l_order_by VARCHAR2 (100) := ' ORDER BY 1';
619: BEGIN

Line 1313: , hxc_latest_details tbb_latest ';

1309: tbb_latest.time_building_block_id,
1310: tbb_latest.object_version_number insert_latest
1311: FROM hxc_retrieval_ranges rr
1312: , hxc_retrieval_range_resources rrr
1313: , hxc_latest_details tbb_latest ';
1314:
1315: l_where VARCHAR2 (1500)
1316: := '
1317: WHERE rr.retrieval_range_id = :p_rr_id

Line 1619: FROM hxc_latest_details tbb_det

1615: AND tx.transaction_id = txd.transaction_id
1616: AND txd.status = 'SUCCESS'
1617: AND EXISTS (
1618: SELECT 'x'
1619: FROM hxc_latest_details tbb_det
1620: WHERE tbb_det.start_time <= p_end_date
1621: AND tbb_det.stop_time >= p_start_date
1622: AND tbb_det.last_update_date > p_since_date
1623: AND tbb_det.time_building_block_id =

Line 1643: FROM hxc_latest_details tbb_det

1639: AND tx.transaction_id = txd.transaction_id
1640: AND txd.status = 'SUCCESS'
1641: AND EXISTS (
1642: SELECT 'x'
1643: FROM hxc_latest_details tbb_det
1644: WHERE tbb_det.time_building_block_id =
1645: txd.time_building_block_id
1646: AND tbb_det.last_update_date > p_since_date
1647: AND tbb_det.object_version_number >

Line 6307: from Hxc_latest_details tbb_latest

6303: FROM
6304: (select /*+ no_merge ordered */
6305: time_building_block_id,
6306: object_version_number
6307: from Hxc_latest_details tbb_latest
6308: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
6309: and tbb_latest.approval_status <> ''ERROR''
6310: AND NOT EXISTS (select ''x''
6311: FROM hxc_transaction_details txd

Line 6330: hxc_latest_details tbb_latest

6326: tbb_latest.time_building_block_id,
6327: tbb_latest.object_version_number
6328: from hxc_retrieval_ranges rr,
6329: hxc_retrieval_range_resources rrr,
6330: hxc_latest_details tbb_latest
6331: where rr.retrieval_range_id = :p_rr_id AND
6332: rr.retrieval_range_id = rrr.retrieval_range_id AND
6333: tbb_latest.resource_id = rrr.resource_id AND
6334: tbb_latest.last_update_date > :p_since_date

Line 6366: , hxc_latest_details hld

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
6367: , hxc_max_ovn detail_max_ovn';
6368: l_time VARCHAR2 (400)
6369: := '
6370: WHERE