APPS.OKL_VP_CR_WF dependencies on FND_APPLICATION

Line 276: FROM FND_APPLICATION

272: cv_get_cr_num c_get_cr_num_csr%ROWTYPE;
273: -- Get the valid application id from FND
274: CURSOR c_get_app_id_csr IS
275: SELECT APPLICATION_ID
276: FROM FND_APPLICATION
277: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
278:
279: -- Get the Transaction Type Id from OAM
280: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS

Line 283: fnd_application_id

279: -- Get the Transaction Type Id from OAM
280: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS
281: -- Updated the query for performance issue bug#5484903
282: select description transaction_type_id,
283: fnd_application_id
284: from AME_TRANSACTION_TYPES_V
285: where transaction_type_id=cp_trx_type;
286:
287: /* --commented out for performance issue bug#5484903

Line 289: fnd_application_id

285: where transaction_type_id=cp_trx_type;
286:
287: /* --commented out for performance issue bug#5484903
288: SELECT transaction_type_id,
289: fnd_application_id
290: FROM AME_CALLING_APPS
291: WHERE application_name = cp_trx_type; */
292: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
293:

Line 300: l_application_id fnd_application.application_id%TYPE;

296:
297: l_requester VARCHAR2(200);
298: l_name VARCHAR2(200);
299:
300: l_application_id fnd_application.application_id%TYPE;
301: l_trans_appl_id ame_calling_apps.application_id%TYPE;
302: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
303:
304: l_api_version CONSTANT NUMBER DEFAULT 1.0;