APPS.OKL_CREDIT_LINE_WF dependencies on AME_CALLING_APPS

Line 296: FROM AME_CALLING_APPS B,

292: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
293: IS
294: SELECT B.TRANSACTION_TYPE_ID,
295: B.FND_APPLICATION_ID
296: FROM AME_CALLING_APPS B,
297: AME_CALLING_APPS_TL T
298: WHERE B.APPLICATION_ID = T.APPLICATION_ID
299: AND T.LANGUAGE = 'US'
300: AND T.APPLICATION_NAME = c_trx_type;

Line 297: AME_CALLING_APPS_TL T

293: IS
294: SELECT B.TRANSACTION_TYPE_ID,
295: B.FND_APPLICATION_ID
296: FROM AME_CALLING_APPS B,
297: AME_CALLING_APPS_TL T
298: WHERE B.APPLICATION_ID = T.APPLICATION_ID
299: AND T.LANGUAGE = 'US'
300: AND T.APPLICATION_NAME = c_trx_type;
301:

Line 305: FROM AME_CALLING_APPS

301:
302: /* --commented for performance issue#5484903
303: SELECT transaction_type_id,
304: fnd_application_id
305: FROM AME_CALLING_APPS
306: WHERE application_name = c_trx_type; */
307:
308: CURSOR l_wf_item_key_csr IS
309: SELECT okl_wf_item_s.NEXTVAL item_key

Line 328: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;

324: l_parameter_list wf_parameter_list_t;
325: l_key VARCHAR2(240);
326: l_event_name VARCHAR2(240);
327: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
328: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
329: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
330: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
331: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;
332: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;

Line 329: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;

325: l_key VARCHAR2(240);
326: l_event_name VARCHAR2(240);
327: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
328: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
329: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
330: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
331: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;
332: l_sts_code OKC_K_HEADERS_V.STS_CODE%TYPE;
333: l_requester VARCHAR2(200);