APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_SCHOLARSHIP_ALL

Line 96: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,

92: FROM igs_re_cand_seo_cls
93: WHERE person_id = cp_person_id
94: AND ca_sequence_number = cp_ca_sequence_number;
95:
96: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,
97: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS
98: SELECT *
99: FROM igs_re_scholarship_all
100: WHERE person_id = cp_person_id

Line 97: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS

93: WHERE person_id = cp_person_id
94: AND ca_sequence_number = cp_ca_sequence_number;
95:
96: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,
97: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS
98: SELECT *
99: FROM igs_re_scholarship_all
100: WHERE person_id = cp_person_id
101: AND ca_sequence_number = cp_ca_sequence_number;

Line 99: FROM igs_re_scholarship_all

95:
96: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,
97: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS
98: SELECT *
99: FROM igs_re_scholarship_all
100: WHERE person_id = cp_person_id
101: AND ca_sequence_number = cp_ca_sequence_number;
102:
103: CURSOR c_get_milestone (cp_person_id igs_pr_milestone_all.person_id%TYPE,