APPS.IGS_AD_INT_RECONSIDER dependencies on IGS_RE_SCHOLARSHIP_ALL

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

70: FROM igs_re_cand_seo_cls
71: WHERE person_id = cp_person_id
72: AND ca_sequence_number = cp_ca_sequence_number;
73:
74: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,
75: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS
76: SELECT *
77: FROM igs_re_scholarship_all
78: WHERE person_id = cp_person_id

Line 75: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS

71: WHERE person_id = cp_person_id
72: AND ca_sequence_number = cp_ca_sequence_number;
73:
74: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,
75: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS
76: SELECT *
77: FROM igs_re_scholarship_all
78: WHERE person_id = cp_person_id
79: AND ca_sequence_number = cp_ca_sequence_number;

Line 77: FROM igs_re_scholarship_all

73:
74: CURSOR c_get_scholarship (cp_person_id igs_re_scholarship_all.person_id%TYPE,
75: cp_ca_sequence_number igs_re_scholarship_all.ca_sequence_number%TYPE) IS
76: SELECT *
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,