362:
363: cursor fetch_awards is
364: select award_id,
365: distribution_value
366: from gms_fp_distributions
367: where funding_pattern_id = p_funding_pattern_id
368: order by distribution_number ;
369:
370: get_awards_rec fetch_awards%ROWTYPE;
894:
895: cursor fetch_awards1 (x_funding_pattern_id in number) is
896: select award_id,
897: distribution_value
898: from gms_fp_distributions
899: where funding_pattern_id = x_funding_pattern_id
900: order by distribution_number ;
901:
902: get_awards_rec fetch_awards1%ROWTYPE;