APPS.HXC_ABS_RETRIEVAL_PKG dependencies on HXC_TRANSACTION_DETAILS

Line 112: NOT EXISTS (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)

108: AND TRUNC (absco.start_time) >= TRUNC (g_tc_start)
109: AND TRUNC (absco.stop_time) <= TRUNC (g_tc_stop)
110: AND absco.stage <> 'RET'
111: AND
112: NOT EXISTS (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
113: INDEX(ht HXC_TRANSACTIONS_PK)
114: INDEX(ht HXC_TRANSACTIONS_N3) */
115: 1
116: FROM hxc_transaction_details htd, hxc_transactions ht

Line 116: FROM hxc_transaction_details htd, hxc_transactions ht

112: NOT EXISTS (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
113: INDEX(ht HXC_TRANSACTIONS_PK)
114: INDEX(ht HXC_TRANSACTIONS_N3) */
115: 1
116: FROM hxc_transaction_details htd, hxc_transactions ht
117: WHERE absco.time_building_block_id = htd.time_building_block_id
118: AND htd.transaction_id = ht.transaction_id
119: AND ht.transaction_process_id = g_retrieval_process_id
120: AND ht.TYPE = 'RETRIEVAL'

Line 305: hxc_transaction_details htd,

301: WHERE (time_building_block_id,object_version_number)
302: IN ( SELECT co.time_building_block_id,
303: co.object_version_number
304: FROM hxc_abs_co_details co,
305: hxc_transaction_details htd,
306: hxc_transactions ht
307: WHERE co.resource_id = g_resource_id
308: AND co.start_time = g_tc_start
309: AND TRUNC(co.stop_time) = TRUNC(g_tc_stop)

Line 410: SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)

406: AND htau.time_attribute_id = hta.time_attribute_id
407: AND hta.attribute_category like 'ELEMENT - %'
408: AND to_number(SUBSTR(hta.attribute_category, 11)) = hate.element_type_id
409: AND NOT EXISTS (
410: SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
411: INDEX(ht HXC_TRANSACTIONS_PK)
412: INDEX(ht HXC_TRANSACTIONS_N3) */
413: 1
414: FROM hxc_transaction_details htd, hxc_transactions ht

Line 414: FROM hxc_transaction_details htd, hxc_transactions ht

410: SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
411: INDEX(ht HXC_TRANSACTIONS_PK)
412: INDEX(ht HXC_TRANSACTIONS_N3) */
413: 1
414: FROM hxc_transaction_details htd, hxc_transactions ht
415: WHERE latest.time_building_block_id = htd.time_building_block_id
416: AND latest.object_version_number = htd.time_building_block_ovn
417: AND htd.transaction_id = ht.transaction_id
418: AND ht.transaction_process_id = g_retrieval_process_id

Line 461: (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)

457: AND TRUNC (absco.stop_time) = TRUNC (g_tc_stop)
458: AND absco.absence_attendance_id IS NOT NULL
459: AND detail.time_building_block_id = absco.time_building_block_id
460: AND detail.object_version_number =
461: (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
462: INDEX(ht HXC_TRANSACTIONS_PK)
463: INDEX(ht HXC_TRANSACTIONS_N3) */
464: MAX (htd.time_building_block_ovn)
465: FROM hxc_transactions ht, hxc_transaction_details htd

Line 465: FROM hxc_transactions ht, hxc_transaction_details htd

461: (SELECT /*+ LEADING(htd HXC_TRANSACTION_DETAILS_FK1)
462: INDEX(ht HXC_TRANSACTIONS_PK)
463: INDEX(ht HXC_TRANSACTIONS_N3) */
464: MAX (htd.time_building_block_ovn)
465: FROM hxc_transactions ht, hxc_transaction_details htd
466: WHERE ht.transaction_process_id = g_retrieval_process_id
467: AND htd.time_building_block_id = absco.time_building_block_id
468: AND htd.transaction_id = ht.transaction_id
469: AND htd.status = 'SUCCESS'

Line 2423: SELECT hxc_transaction_details_s.NEXTVAL

2419: )
2420: IS
2421: CURSOR c_transaction_detail_sequence
2422: IS
2423: SELECT hxc_transaction_details_s.NEXTVAL
2424: FROM DUAL;
2425:
2426: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
2427: BEGIN

Line 2426: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;

2422: IS
2423: SELECT hxc_transaction_details_s.NEXTVAL
2424: FROM DUAL;
2425:
2426: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
2427: BEGIN
2428: -- insert into hxc_transaction_details
2429: FOR l_tx_index IN p_tbb_id.FIRST .. p_tbb_id.LAST
2430: LOOP

Line 2428: -- insert into hxc_transaction_details

2424: FROM DUAL;
2425:
2426: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
2427: BEGIN
2428: -- insert into hxc_transaction_details
2429: FOR l_tx_index IN p_tbb_id.FIRST .. p_tbb_id.LAST
2430: LOOP
2431: OPEN c_transaction_detail_sequence;
2432:

Line 2439: INSERT INTO hxc_transaction_details

2435:
2436: CLOSE c_transaction_detail_sequence;
2437:
2438:
2439: INSERT INTO hxc_transaction_details
2440: (transaction_detail_id,
2441: time_building_block_id,
2442: transaction_id,
2443: created_by,