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: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
1319:

Line 1325: l_application_id fnd_application.application_id%TYPE;

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

Line 1519: FROM FND_APPLICATION

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

Line 1525: fnd_application_id

1521:
1522: -- Get the Transaction Type Id from OAM
1523: CURSOR c_get_trx_type_csr(cp_trx_type VARCHAR2) IS
1524: SELECT transaction_type_id,
1525: fnd_application_id
1526: FROM ame_transaction_types_v
1527: WHERE transaction_type_id = cp_trx_type;
1528: c_get_trx_type_csr_rec c_get_trx_type_csr%ROWTYPE;
1529:

Line 1535: l_application_id fnd_application.application_id%TYPE;

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