APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_APPQUAL_CODE

Line 1628: FROM igs_ad_appqual_code

1624: cp_nominated_course_cd IGS_AD_PS_APPL_INST.NOMINATED_COURSE_CD%TYPE,
1625: cp_admission_appl_number IGS_AD_PS_APPL_INST.admission_appl_number%TYPE,
1626: cp_sequence_number IGS_AD_PS_APPL_INST.sequence_number%TYPE ) IS
1627: SELECT QUALIFYING_TYPE_CODE,QUALIFYING_CODE_ID,QUALIFYING_VALUE ,PERSON_ID,NOMINATED_COURSE_CD
1628: FROM igs_ad_appqual_code
1629: WHERE person_id = cp_person_id
1630: AND nominated_course_cd = cp_nominated_course_cd
1631: AND sequence_number = cp_sequence_number
1632: AND admission_appl_number = cp_admission_appl_number;

Line 2012: igs_ad_appqual_code_pkg.INSERT_ROW(

2008: l_rowid := NULL;
2009:
2010: FOR c_appl_qual_rec IN c_appl_qual_code(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
2011: l_last_error := 'IGS_AD_CHILD_QUAL_CODE';
2012: igs_ad_appqual_code_pkg.INSERT_ROW(
2013: x_rowid => l_rowid,
2014: x_person_id => c_appl_qual_rec.person_id,
2015: x_admission_appl_number => p_new_admission_appl_number,
2016: x_nominated_course_cd => c_appl_qual_rec.nominated_course_cd,