APPS.JTF_FM_REQUEST_GRP dependencies on JTF_FM_SERVICE_ALL

Line 80: FROM JTF_FM_SERVICE_ALL

76: JTF_FM_UTL_V.PRINT_MESSAGE('BEGIN' || l_full_name, JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,l_full_name);
77:
78: SELECT DECODE(p_request_type,'M', MASS_REQUEST_Q, 'B' , BATCH_REQUEST_Q, 'MP', MASS_PAUSE_Q, BATCH_PAUSE_Q)
79: INTO l_queue_name
80: FROM JTF_FM_SERVICE_ALL
81: WHERE SERVer_ID = p_server_id;
82:
83: JTF_FM_UTL_V.PRINT_MESSAGE('END function GET_QUEU_NAME', JTF_FM_UTL_V.G_LEVEL_PROCEDURE ,'JTF_FM_REQUEST_GRP.GET_QUEUE_NAME');
84:

Line 6303: FROM JTF_FM_SERVICE_ALL

6299:
6300:
6301: SELECT DECODE(l_request_type,'M', MASS_REQUEST_Q, 'B',BATCH_REQUEST_Q,'T',BATCH_REQUEST_Q, REQUEST_QUEUE_NAME)
6302: INTO l_request_queue
6303: FROM JTF_FM_SERVICE_ALL
6304: WHERE
6305: SERVER_ID = l_server_id;
6306:
6307: JTF_FM_UTL_V.PRINT_MESSAGE('Queue found ' || l_request_queue,JTF_FM_UTL_V.G_LEVEL_STATEMENT,l_full_name);