APPS.OKL_SUBSIDY_POOL_PVT dependencies on OKL_TRX_SUBSIDY_POOLS

Line 286: l_trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE;

282: IS_DEBUG_PROCEDURE_ON BOOLEAN;
283: l_sub_pool_rec subsidy_pool_rec ;
284: l_effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE ;
285: l_db_effective_to OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE ;
286: l_trx_date OKL_TRX_SUBSIDY_POOLS.TRX_DATE%TYPE;
287: l_status_code OKL_SUBSIDY_POOLS_B.DECISION_STATUS_CODE%TYPE ;
288: l_system_date DATE;
289: l_api_version NUMBER ;
290: l_init_msg_list VARCHAR2(1) ;

Line 320: FROM okl_trx_subsidy_pools

316:
317: -- Cursor for fetching the transaction date for the subsidy pool.
318: CURSOR c_get_trx_date (cp_pool_id IN okl_subsidy_pools_b.id%type) IS
319: SELECT max(TRUNC(trx_date))
320: FROM okl_trx_subsidy_pools
321: WHERE subsidy_pool_id = cp_pool_id;
322:
323:
324: