APPS.HXC_GENERIC_RETRIEVAL_PKG dependencies on HXC_PAY_LATEST_DETAILS

Line 652: FROM hxc_pay_latest_details tbb

648:
649: l_root_pay VARCHAR2(2500)
650: := '
651: SELECT DISTINCT tbb.resource_id
652: FROM hxc_pay_latest_details tbb
653: WHERE tbb.last_update_date > :p_since_date ';
654:
655:
656: l_root_day VARCHAR2 (2500)

Line 673: FROM hxc_pay_latest_details tbb

669:
670: l_root_day_pay VARCHAR2 (2500)
671: := '
672: SELECT DISTINCT tbb.resource_id
673: FROM hxc_pay_latest_details tbb
674: WHERE tbb.last_update_date > :p_since_date ';
675:
676: l_order_by VARCHAR2 (100) := ' ORDER BY 1';
677:

Line 1191: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'LATEST_DETAILS','HXC_PAY_LATEST_DETAILS');

1187: l_rdb_process_sql);
1188: ELSIF g_params.p_process IN ('BEE Retrieval Process','Apply Schedule Rules')
1189: AND hxc_upgrade_pkg.performance_upgrade_complete('RETRIEVAL_PAY')
1190: THEN
1191: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'LATEST_DETAILS','HXC_PAY_LATEST_DETAILS');
1192: l_rdb_process_sql := REPLACE(l_rdb_process_sql,'RETRIEVALPROCESS',''''||g_params.p_process||'''');
1193:
1194: mark_for_retrieval(TRUNC(SYSDATE) - fnd_profile.value('HXC_RETRIEVAL_CHANGES_DATE'),
1195: l_rdb_process_sql,

Line 1762: , hxc_pay_latest_details tbb_latest ';

1758: tbb_latest.time_building_block_id,
1759: tbb_latest.object_version_number insert_latest
1760: FROM hxc_retrieval_ranges rr
1761: , hxc_retrieval_range_resources rrr
1762: , hxc_pay_latest_details tbb_latest ';
1763:
1764:
1765:
1766: l_where VARCHAR2 (1500)

Line 7088: from Hxc_pay_latest_details tbb_latest

7084: FROM
7085: (select /*+ no_merge ordered */
7086: time_building_block_id,
7087: object_version_number
7088: from Hxc_pay_latest_details tbb_latest
7089: where tbb_latest.resource_id BETWEEN :p_lower_range and :p_upper_range
7090: and tbb_latest.approval_status <> ''ERROR''
7091: AND NOT EXISTS (select ''x''
7092: FROM hxc_transaction_details txd

Line 7168: hxc_pay_latest_details tbb_latest

7164: tbb_latest.time_building_block_id,
7165: tbb_latest.object_version_number
7166: from hxc_retrieval_ranges rr,
7167: hxc_retrieval_range_resources rrr,
7168: hxc_pay_latest_details tbb_latest
7169: where rr.retrieval_range_id = :p_rr_id AND
7170: rr.retrieval_range_id = rrr.retrieval_range_id AND
7171: tbb_latest.resource_id = rrr.resource_id AND
7172: tbb_latest.last_update_date > :p_since_date

Line 7239: , hxc_pay_latest_details hld

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
7240: , hxc_max_ovn detail_max_ovn';
7241:
7242:
7243:

Line 9524: DELETE FROM hxc_pay_latest_details

9520: -- Similar processing like projects above.
9521: -- Bug 12919783
9522: FORALL tx_error IN hxc_generic_retrieval_pkg.t_tx_detail_bb_id.FIRST ..
9523: hxc_generic_retrieval_pkg.t_tx_detail_bb_id.LAST
9524: DELETE FROM hxc_pay_latest_details
9525: WHERE time_building_block_id = hxc_generic_retrieval_pkg.t_tx_detail_bb_id(tx_error)
9526: AND hxc_generic_retrieval_pkg.t_tx_detail_status
9527: (tx_error) = 'SUCCESS'
9528: RETURNING