APPS.OKL_SETUPPRODUCTS_PVT dependencies on FND_APPLICATION

Line 1261: FROM FND_APPLICATION

1257: -- Get the valid application id from FND
1258: CURSOR c_get_app_id_csr
1259: IS
1260: SELECT APPLICATION_ID
1261: FROM FND_APPLICATION
1262: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
1263:
1264: -- Get the Transaction Type Id from OAM
1265: -- modification of where condn by dcshanmu for bug 5999276 starts

Line 1269: fnd_application_id

1265: -- modification of where condn by dcshanmu for bug 5999276 starts
1266: CURSOR c_get_trx_type_csr(c_trx_type VARCHAR2)
1267: IS
1268: SELECT transaction_type_id,
1269: fnd_application_id
1270: FROM ame_transaction_types_v
1271: WHERE DESCRIPTION='OKL LP Product Approval Process';
1272: -- modification of where condn by dcshanmu for bug 5999276 starts
1273:

Line 1291: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;

1287: l_key VARCHAR2(240);
1288: l_event_name VARCHAR2(240);
1289: l_pdt_id OKL_PRODUCTS_V.ID%TYPE;
1290:
1291: l_application_id FND_APPLICATION.APPLICATION_ID%TYPE;
1292: l_trans_appl_id AME_CALLING_APPS.APPLICATION_ID%TYPE;
1293: l_trans_type_id AME_CALLING_APPS.TRANSACTION_TYPE_ID%TYPE;
1294:
1295: l_requester VARCHAR2(200);