934: PROCEDURE get_award_dist_param (p_award_dist_option OUT NOCOPY VARCHAR2,
935: p_dist_award_number OUT NOCOPY VARCHAR2,
936: p_dist_award_id OUT NOCOPY NUMBER )
937: IS
938: l_award_dist_option gms_implementations_all.award_distribution_option%TYPE;
939: l_dist_award_number gms_implementations_all.default_dist_award_number%TYPE;
940: l_dist_award_id gms_implementations_all.default_dist_award_id%TYPE;
941: CURSOR c_default_award IS
942: SELECT award_distribution_option,
935: p_dist_award_number OUT NOCOPY VARCHAR2,
936: p_dist_award_id OUT NOCOPY NUMBER )
937: IS
938: l_award_dist_option gms_implementations_all.award_distribution_option%TYPE;
939: l_dist_award_number gms_implementations_all.default_dist_award_number%TYPE;
940: l_dist_award_id gms_implementations_all.default_dist_award_id%TYPE;
941: CURSOR c_default_award IS
942: SELECT award_distribution_option,
943: default_dist_award_number,
936: p_dist_award_id OUT NOCOPY NUMBER )
937: IS
938: l_award_dist_option gms_implementations_all.award_distribution_option%TYPE;
939: l_dist_award_number gms_implementations_all.default_dist_award_number%TYPE;
940: l_dist_award_id gms_implementations_all.default_dist_award_id%TYPE;
941: CURSOR c_default_award IS
942: SELECT award_distribution_option,
943: default_dist_award_number,
944: default_dist_award_id