eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_TRX_PVT dependencies on OKL_SUBSIDY_POOLS_B

Line 51: FROM okl_subsidy_pools_b pool,

47: , pool.currency_conversion_type
48: , nvl(pool.total_budgets,0) total_budgets
49: , nvl(pool.total_subsidy_amount,0) total_subsidy_amount
50: , pool.subsidy_pool_name
51: FROM okl_subsidy_pools_b pool,
52: okl_subsidies_b sub
53: WHERE sub.subsidy_pool_id = pool.id
54: AND sub.id = p_sixv_rec.subsidy_id;
55: cv_pool_details c_get_pool_dates_csr%ROWTYPE;

Line 65: lv_total_subsidy_amt okl_subsidy_pools_b.total_subsidy_amount%TYPE;

61: lv_pool_expired VARCHAR2(1);
62: lv_conv_rate NUMBER;
63: lv_subsidy_pool_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
64: lv_subsidy_pool_round_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
65: lv_total_subsidy_amt okl_subsidy_pools_b.total_subsidy_amount%TYPE;
66:
67: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_TRX_PVT.CREATE_POOL_TRANSACTION';
68: l_debug_enabled VARCHAR2(10);
69: is_debug_procedure_on BOOLEAN;