[Home] [Help]
206: CURSOR c_check_frml(
207: cp_adplans_id igf_aw_awd_dist_plans.adplans_id%TYPE
208: ) IS
209: SELECT adplans_id
210: FROM igf_aw_awd_frml_det
211: WHERE adplans_id = cp_adplans_id;
212:
213: -- check if a distribution plan is associated with a award
214: CURSOR c_check_awd(