1170: p_db_sixv_rec IN sixv_rec_type
1171: ) RETURN VARCHAR2 IS
1172: CURSOR c_get_sub_dates_csr IS
1173: SELECT effective_from_date, effective_to_date, name 1174: FROM okl_subsidies_b 1175: WHERE id = p_sixv_rec.subsidy_id;
1176: cv_get_sub_dates c_get_sub_dates_csr%ROWTYPE;
1177: CURSOR c_get_sub_pool_dates_csr IS
1178: SELECT effective_from_date, effective_to_date, subsidy_pool_name