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: -- Get the Transaction Type Id from OAM
291: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)

Line 294: FND_APPLICATION_ID fnd_application_id

290: -- Get the Transaction Type Id from OAM
291: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
292: IS
293: SELECT DESCRIPTION transaction_type_id, -- for performance issue #5484903
294: FND_APPLICATION_ID fnd_application_id
295: FROM AME_TRANSACTION_TYPES_V
296: WHERE TRANSACTION_TYPE_ID=c_trx_type;
297:
298: /* --commented for performance issue#5484903

Line 300: fnd_application_id

296: WHERE TRANSACTION_TYPE_ID=c_trx_type;
297:
298: /* --commented for performance issue#5484903
299: SELECT transaction_type_id,
300: fnd_application_id
301: FROM AME_CALLING_APPS
302: WHERE application_name = c_trx_type; */
303:
304: CURSOR l_wf_item_key_csr IS

Line 323: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

319: l_msg_data VARCHAR2(2000);
320: l_parameter_list wf_parameter_list_t;
321: l_key VARCHAR2(240);
322: l_event_name VARCHAR2(240);
323: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
324: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
325: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
326: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
327: l_chrv_id OKC_K_HEADERS_V.ID%TYPE ;