APPS.OKL_SUBSIDY_POOL_WF dependencies on FND_APPLICATION

Line 1309: FROM FND_APPLICATION

1305: -- Get the valid application id from FND
1306: CURSOR c_get_app_id_csr
1307: IS
1308: SELECT APPLICATION_ID
1309: FROM FND_APPLICATION
1310: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
1311:
1312: -- Get the Transaction Type Id from OAM
1313: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS

Line 1315: fnd_application_id

1311:
1312: -- Get the Transaction Type Id from OAM
1313: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS
1314: SELECT transaction_type_id,
1315: fnd_application_id
1316: FROM ame_transaction_types_v
1317: --WHERE transaction_type_id = cp_trx_type;
1318: -- 12754397: RGOOTY
1319: WHERE DESCRIPTION = cp_trx_type;

Line 1327: l_application_id fnd_application.application_id%TYPE;

1323: SELECT id
1324: FROM okl_trx_types_b
1325: WHERE trx_type_class = G_TRX_TYPE_POOL_APPROVAL;
1326:
1327: l_application_id fnd_application.application_id%TYPE;
1328: l_trans_appl_id ame_calling_apps.application_id%TYPE;
1329: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
1330:
1331: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.RAISE_POOL_EVENT_APPROVAL';

Line 1521: FROM FND_APPLICATION

1517: -- Get the valid application id from FND
1518: CURSOR c_get_app_id_csr
1519: IS
1520: SELECT APPLICATION_ID
1521: FROM FND_APPLICATION
1522: WHERE APPLICATION_SHORT_NAME = G_APP_NAME;
1523:
1524: -- Get the Transaction Type Id from OAM
1525: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS

Line 1527: fnd_application_id

1523:
1524: -- Get the Transaction Type Id from OAM
1525: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS
1526: SELECT transaction_type_id,
1527: fnd_application_id
1528: FROM ame_transaction_types_v
1529: --WHERE transaction_type_id = cp_trx_type;
1530: -- 12754397: RGOOTY
1531: WHERE description = cp_trx_type;

Line 1539: l_application_id fnd_application.application_id%TYPE;

1535: SELECT id
1536: FROM okl_trx_types_b
1537: WHERE trx_type_class = G_TRX_TYPE_POOL_APPROVAL;
1538:
1539: l_application_id fnd_application.application_id%TYPE;
1540: l_trans_appl_id ame_calling_apps.application_id%TYPE;
1541: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
1542:
1543: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.RAISE_BUDGET_EVENT_APPROVAL';