APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_LATEST_DETAILS

Line 637: FROM hxc_latest_details tbb

633: l_range_caveat BOOLEAN := FALSE;
634: l_root VARCHAR2 (2500)
635: := '
636: SELECT DISTINCT tbb.resource_id
637: FROM hxc_latest_details tbb
638: WHERE tbb.last_update_date > :p_since_date ';
639:
640:
641: -- Bug 9394444

Line 659: FROM hxc_latest_details tbb

655:
656: l_root_day VARCHAR2 (2500)
657: := '
658: SELECT DISTINCT tbb.resource_id
659: FROM hxc_latest_details tbb
660: WHERE tbb.last_update_date > :p_since_date ';
661:
662:
663: -- Bug 9394444

Line 873: -- change. HXC_LATEST_DETAILS, which was the driving table for retrieval, is

869: END IF;
870:
871: -- Bug 9394444
872: -- Description : This bugfix is actually a performance upgrade thru a data model
873: -- change. HXC_LATEST_DETAILS, which was the driving table for retrieval, is
874: -- now replaced by two separate tables for Payroll and projects. The bug fix
875: -- only changes the name of the tables in all the dynamic queries used.
876: -- This new upgrade is dependant on the new profile option OTL: Use Upgraded
877: -- Retrieval Process and would work only if the respective upgrades are

Line 901: -- Picking up the Org id or BG id to trim hxc_latest_details.

897: END IF;
898:
899:
900: -- Bug 8888911
901: -- Picking up the Org id or BG id to trim hxc_latest_details.
902: -- do this only if the upgrade is complete.
903: IF g_params.p_process = 'Projects Retrieval Process'
904: AND hxc_upgrade_pkg.ret_upgrade_completed
905: THEN

Line 1741: , hxc_latest_details tbb_latest ';

1737: tbb_latest.time_building_block_id,
1738: tbb_latest.object_version_number insert_latest
1739: FROM hxc_retrieval_ranges rr
1740: , hxc_retrieval_range_resources rrr
1741: , hxc_latest_details tbb_latest ';
1742:
1743: -- Bug 9394444
1744: -- The Application specific version of the queries.
1745:

Line 2218: FROM hxc_latest_details tbb_det

2214: AND tx.transaction_id = txd.transaction_id
2215: AND txd.status = 'SUCCESS'
2216: AND EXISTS (
2217: SELECT 'x'
2218: FROM hxc_latest_details tbb_det
2219: WHERE tbb_det.start_time <= p_end_date
2220: AND tbb_det.stop_time >= p_start_date
2221: AND tbb_det.last_update_date > p_since_date
2222: AND tbb_det.time_building_block_id =

Line 2242: FROM hxc_latest_details tbb_det

2238: AND tx.transaction_id = txd.transaction_id
2239: AND txd.status = 'SUCCESS'
2240: AND EXISTS (
2241: SELECT 'x'
2242: FROM hxc_latest_details tbb_det
2243: WHERE tbb_det.time_building_block_id =
2244: txd.time_building_block_id
2245: AND tbb_det.last_update_date > p_since_date
2246: AND tbb_det.object_version_number >

Line 7042: from Hxc_latest_details tbb_latest

7038: FROM
7039: (select /*+ no_merge ordered */
7040: time_building_block_id,
7041: object_version_number
7042: from Hxc_latest_details tbb_latest
7043: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
7044: and tbb_latest.approval_status <> ''ERROR''
7045: AND NOT EXISTS (select ''x''
7046: FROM hxc_transaction_details txd

Line 7114: hxc_latest_details tbb_latest

7110: tbb_latest.time_building_block_id,
7111: tbb_latest.object_version_number
7112: from hxc_retrieval_ranges rr,
7113: hxc_retrieval_range_resources rrr,
7114: hxc_latest_details tbb_latest
7115: where rr.retrieval_range_id = :p_rr_id AND
7116: rr.retrieval_range_id = rrr.retrieval_range_id AND
7117: tbb_latest.resource_id = rrr.resource_id AND
7118: tbb_latest.last_update_date > :p_since_date

Line 7206: , hxc_latest_details hld

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
7207: , hxc_max_ovn detail_max_ovn';
7208: l_time VARCHAR2 (400)
7209: := '
7210: WHERE