APPS.OKL_CREDIT_LINE_WF dependencies on FND_APPLICATION

Line 287: FROM FND_APPLICATION

283: -- Get the valid application id from FND
284: CURSOR c_get_app_id_csr
285: IS
286: SELECT APPLICATION_ID
287: FROM FND_APPLICATION
288: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
289:
290: -- Modified cursor by bkatraga for bug 9118673
291: -- Get the Transaction Type Id from OAM

Line 295: B.FND_APPLICATION_ID

291: -- Get the Transaction Type Id from OAM
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'

Line 304: fnd_application_id

300: AND T.APPLICATION_NAME = c_trx_type;
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

Line 327: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

323: l_msg_data VARCHAR2(2000);
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 ;