APPS.HXC_RETRIEVE_ABSENCES dependencies on HXC_TRANSACTION_DETAILS

Line 2447: IS SELECT hxc_transaction_details_s.NEXTVAL

2443:
2444: l_index NUMBER;
2445:
2446: CURSOR c_transaction_detail_sequence
2447: IS SELECT hxc_transaction_details_s.NEXTVAL
2448: FROM DUAL;
2449:
2450: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
2451:

Line 2450: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;

2446: CURSOR c_transaction_detail_sequence
2447: IS SELECT hxc_transaction_details_s.NEXTVAL
2448: FROM DUAL;
2449:
2450: l_transaction_detail_id hxc_transaction_details.transaction_detail_id%TYPE;
2451:
2452: Begin
2453:
2454: l_index := g_detail_trans_tab.first;

Line 2464: INSERT INTO hxc_transaction_details

2460: OPEN c_transaction_detail_sequence;
2461: FETCH c_transaction_detail_sequence into l_transaction_detail_id;
2462: CLOSE c_transaction_detail_sequence;
2463:
2464: INSERT INTO hxc_transaction_details
2465: (transaction_detail_id
2466: ,time_building_block_id
2467: ,transaction_id
2468: ,created_by

Line 2819: FROM hxc_transaction_details htd,

2815:
2816: CURSOR get_transactions( p_bb_id IN NUMBER,
2817: p_bb_ovn IN NUMBER)
2818: IS SELECT htd.time_building_block_ovn
2819: FROM hxc_transaction_details htd,
2820: hxc_transactions ht
2821: WHERE htd.time_building_block_id = p_bb_id
2822: AND htd.time_building_block_ovn <= p_bb_ovn
2823: AND htd.transaction_id = ht.transaction_id