APPS.OKL_SEC_AGREEMENT_WF dependencies on FND_APPLICATION

Line 315: FROM FND_APPLICATION

311: -- Get the valid application id from FND
312: CURSOR c_get_app_id_csr
313: IS
314: SELECT APPLICATION_ID
315: FROM FND_APPLICATION
316: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
317:
318: -- Get the Transaction Type Id from OAM
319: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)

Line 322: FND_APPLICATION_ID fnd_application_id

318: -- Get the Transaction Type Id from OAM
319: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
320: IS
321: SELECT DESCRIPTION transaction_type_id,
322: FND_APPLICATION_ID fnd_application_id
323: FROM AME_TRANSACTION_TYPES_V
324: WHERE TRANSACTION_TYPE_ID=c_trx_type;
325:
326: CURSOR l_wf_item_key_csr IS

Line 339: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

335: l_msg_data VARCHAR2(2000);
336: l_parameter_list wf_parameter_list_t;
337: l_key VARCHAR2(240);
338: l_event_name VARCHAR2(240);
339: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
340: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
341: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
342: l_agreement_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
343: l_agreement_id OKC_K_HEADERS_V.ID%TYPE;