eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HXC_SELF_SERVICE_TIMECARD dependencies on HXC_TRANSACTION_DETAILS

Line 5825: CURSOR c_get_transaction_id(l_bb_id hxc_transaction_details.time_building_block_id%TYPE,

5821: AND(det.measure IS NOT NULL OR(det.start_time IS NOT NULL AND det.stop_time IS NOT NULL))
5822: AND lat.time_building_block_id = det.time_building_block_id ;
5823:
5824:
5825: CURSOR c_get_transaction_id(l_bb_id hxc_transaction_details.time_building_block_id%TYPE,
5826: l_bb_ovn hxc_transaction_details.time_building_block_ovn%TYPE) IS
5827: SELECT ht.transaction_id,
5828: ht.transaction_process_id
5829: FROM hxc_transaction_details htd,

Line 5826: l_bb_ovn hxc_transaction_details.time_building_block_ovn%TYPE) IS

5822: AND lat.time_building_block_id = det.time_building_block_id ;
5823:
5824:
5825: CURSOR c_get_transaction_id(l_bb_id hxc_transaction_details.time_building_block_id%TYPE,
5826: l_bb_ovn hxc_transaction_details.time_building_block_ovn%TYPE) IS
5827: SELECT ht.transaction_id,
5828: ht.transaction_process_id
5829: FROM hxc_transaction_details htd,
5830: hxc_transactions ht

Line 5829: FROM hxc_transaction_details htd,

5825: CURSOR c_get_transaction_id(l_bb_id hxc_transaction_details.time_building_block_id%TYPE,
5826: l_bb_ovn hxc_transaction_details.time_building_block_ovn%TYPE) IS
5827: SELECT ht.transaction_id,
5828: ht.transaction_process_id
5829: FROM hxc_transaction_details htd,
5830: hxc_transactions ht
5831: WHERE htd.transaction_id = ht.transaction_id
5832: AND ht.type = 'RETRIEVAL'
5833: AND ht.status = 'SUCCESS'