864:
865: -- cursor to fetch the pool status code from lookups.
866: CURSOR c_get_pool_stat_csr IS
867: SELECT '1' 868: FROM fnd_lookups 869: WHERE lookup_type = 'OKL_SUBSIDY_POOL_STATUS'
870: AND lookup_code = p_decision_status_code ;
871: lv_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
872: BEGIN