APPS.OKL_KBK_APPROVALS_WF dependencies on FND_APPLICATION

Line 241: FROM FND_APPLICATION

237: -- Get the valid application id from FND
238: CURSOR c_get_app_id_csr
239: IS
240: SELECT APPLICATION_ID
241: FROM FND_APPLICATION
242: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
243:
244: -- nikshah -- Bug # 5484903 Fixed,
245: -- Changed CURSOR c_get_trx_type_csr SQL definition

Line 250: fnd_application_id

246: -- Get the Transaction Type Id from OAM
247: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
248: IS
249: SELECT description,
250: fnd_application_id
251: FROM AME_TRANSACTION_TYPES_V
252: WHERE transaction_type_id = c_trx_type;
253:
254: CURSOR l_wf_item_key_csr IS

Line 274: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

270: l_parameter_list wf_parameter_list_t;
271: l_key VARCHAR2(240);
272: l_event_name VARCHAR2(240);
273:
274: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
275: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
276: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
277:
278: l_contract_num OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;