DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on GME_RESOURCE_TXNS_GTMP

Line 53: FROM gme_resource_txns_gtmp

49:
50: CURSOR header_cursor
51: IS
52: SELECT DISTINCT doc_id batch_id
53: FROM gme_resource_txns_gtmp
54: ORDER BY batch_id;
55: BEGIN
56: IF g_debug <= gme_debug.g_log_procedure THEN
57: gme_debug.put_line ('Entering api ' || g_pkg_name || '.'

Line 1053: FROM gme_resource_txns_gtmp t, gme_resource_txns r

1049: /*end */
1050: CURSOR cur_get_trans_id (v_line_id NUMBER)
1051: IS
1052: SELECT r.*
1053: FROM gme_resource_txns_gtmp t, gme_resource_txns r
1054: WHERE action_code = 'NONE' AND t.line_id = v_line_id
1055: AND t.poc_trans_id = r.poc_trans_id;
1056:
1057: update_rsrc_usage EXCEPTION;