APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_APPL_NOTES

Line 1547: igs_ad_appl_notes

1543: sequence_number ,
1544: note_type_id ,
1545: ref_notes_id
1546: FROM
1547: igs_ad_appl_notes
1548: WHERE
1549: person_id = cp_person_id and
1550: nominated_course_cd = cp_nominated_course_cd and
1551: sequence_number = cp_sequence_number and

Line 1950: igs_ad_appl_notes_pkg.INSERT_ROW(

1946:
1947: -- NOTES
1948: FOR c_notes_rec IN c_notes_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1949: l_last_error := 'IGS_AD_CHILD_APPL_NOTES';
1950: igs_ad_appl_notes_pkg.INSERT_ROW(
1951: X_ROWID => l_rowid,
1952: X_APPL_NOTES_ID => l_primary_key,
1953: X_PERSON_ID => c_notes_rec.person_id,
1954: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,