APPS.OKL_VP_PA_WF dependencies on FND_APPLICATION

Line 227: FROM FND_APPLICATION

223:
224: -- Get the valid application id from FND
225: CURSOR c_get_app_id_csr IS
226: SELECT APPLICATION_ID
227: FROM FND_APPLICATION
228: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
229:
230: -- Get the Transaction Type Id from OAM
231: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS

Line 233: fnd_application_id

229:
230: -- Get the Transaction Type Id from OAM
231: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS
232: SELECT transaction_type_id,
233: fnd_application_id
234: FROM AME_CALLING_APPS
235: WHERE application_name = cp_trx_type;
236: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
237:

Line 244: l_application_id fnd_application.application_id%TYPE;

240:
241: l_requester VARCHAR2(200);
242: l_name VARCHAR2(200);
243:
244: l_application_id fnd_application.application_id%TYPE;
245: l_trans_appl_id ame_calling_apps.application_id%TYPE;
246: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
247:
248: l_api_version CONSTANT NUMBER DEFAULT 1.0;