APPS.OKL_SETUPPRODUCTS_PVT dependencies on FND_APPLICATION

Line 1278: FROM FND_APPLICATION

1274: -- Get the valid application id from FND
1275: CURSOR c_get_app_id_csr
1276: IS
1277: SELECT APPLICATION_ID
1278: FROM FND_APPLICATION
1279: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
1280:
1281: -- Get the Transaction Type Id from OAM
1282: -- modification of where condn by dcshanmu for bug 5999276 starts

Line 1286: fnd_application_id

1282: -- modification of where condn by dcshanmu for bug 5999276 starts
1283: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
1284: IS
1285: SELECT transaction_type_id,
1286: fnd_application_id
1287: FROM ame_transaction_types_v
1288: WHERE DESCRIPTION='OKL LP Product Approval Process';
1289: -- modification of where condn by dcshanmu for bug 5999276 starts
1290:

Line 1308: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

1304: l_key VARCHAR2(240);
1305: l_event_name VARCHAR2(240);
1306: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1307:
1308: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
1309: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
1310: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1311:
1312: l_requester VARCHAR2(200);