APPS.OKL_VP_OA_WF dependencies on FND_APPLICATION

Line 224: FROM FND_APPLICATION

220: cv_get_oa_num c_get_oa_num_csr%ROWTYPE;
221: -- Get the valid application id from FND
222: CURSOR c_get_app_id_csr IS
223: SELECT APPLICATION_ID
224: FROM FND_APPLICATION
225: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
226:
227: -- Get the Transaction Type Id from OAM
228: --Fixed Bug # 5484903

Line 231: fnd_application_id

227: -- Get the Transaction Type Id from OAM
228: --Fixed Bug # 5484903
229: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS
230: SELECT transaction_type_id,
231: fnd_application_id
232: FROM AME_TRANSACTION_TYPES_V
233: where transaction_type_id = cp_trx_type;
234: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
235:

Line 242: l_application_id fnd_application.application_id%TYPE;

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