77: FROM igs_re_scholarship_all
78: WHERE person_id = cp_person_id
79: AND ca_sequence_number = cp_ca_sequence_number;
80:
81: CURSOR c_get_milestone (cp_person_id igs_pr_milestone_all.person_id%TYPE,
82: cp_ca_sequence_number igs_pr_milestone_all.ca_sequence_number%TYPE) IS
83: SELECT *
84: FROM igs_pr_milestone_all
85: WHERE person_id = cp_person_id
78: WHERE person_id = cp_person_id
79: AND ca_sequence_number = cp_ca_sequence_number;
80:
81: CURSOR c_get_milestone (cp_person_id igs_pr_milestone_all.person_id%TYPE,
82: cp_ca_sequence_number igs_pr_milestone_all.ca_sequence_number%TYPE) IS
83: SELECT *
84: FROM igs_pr_milestone_all
85: WHERE person_id = cp_person_id
86: AND ca_sequence_number = cp_ca_sequence_number;
80:
81: CURSOR c_get_milestone (cp_person_id igs_pr_milestone_all.person_id%TYPE,
82: cp_ca_sequence_number igs_pr_milestone_all.ca_sequence_number%TYPE) IS
83: SELECT *
84: FROM igs_pr_milestone_all
85: WHERE person_id = cp_person_id
86: AND ca_sequence_number = cp_ca_sequence_number;
87:
88: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,