APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_PR_MILESTONE_ALL

Line 103: CURSOR c_get_milestone (cp_person_id igs_pr_milestone_all.person_id%TYPE,

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,
104: cp_ca_sequence_number igs_pr_milestone_all.ca_sequence_number%TYPE) IS
105: SELECT *
106: FROM igs_pr_milestone_all
107: WHERE person_id = cp_person_id

Line 104: cp_ca_sequence_number igs_pr_milestone_all.ca_sequence_number%TYPE) IS

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,
104: cp_ca_sequence_number igs_pr_milestone_all.ca_sequence_number%TYPE) IS
105: SELECT *
106: FROM igs_pr_milestone_all
107: WHERE person_id = cp_person_id
108: AND ca_sequence_number = cp_ca_sequence_number;

Line 106: FROM igs_pr_milestone_all

102:
103: CURSOR c_get_milestone (cp_person_id igs_pr_milestone_all.person_id%TYPE,
104: cp_ca_sequence_number igs_pr_milestone_all.ca_sequence_number%TYPE) IS
105: SELECT *
106: FROM igs_pr_milestone_all
107: WHERE person_id = cp_person_id
108: AND ca_sequence_number = cp_ca_sequence_number;
109:
110: CURSOR c_get_supervisor (cp_ca_person_id igs_re_sprvsr.ca_person_id%TYPE,