APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_AD_APPL_ARP

Line 1600: igs_ad_appl_arp

1596: sequence_number ,
1597: appl_rev_profile_id ,
1598: appl_revprof_revgr_id
1599: FROM
1600: igs_ad_appl_arp
1601: WHERE
1602: person_id = cp_person_id and
1603: nominated_course_cd = cp_nominated_course_cd and
1604: sequence_number = cp_sequence_number and

Line 1994: igs_ad_appl_arp_pkg.INSERT_ROW(

1990:
1991: -- Evaluators Review group
1992: FOR c_applrep_rec IN c_applrep_cur(p_person_id, p_nominated_course_cd, p_old_admission_appl_number, p_old_sequence_number) LOOP
1993: l_last_error := 'IGS_AD_CHILD_EVAL_RGRP';
1994: igs_ad_appl_arp_pkg.INSERT_ROW(
1995: X_ROWID => l_rowid,
1996: X_PERSON_ID => c_applrep_rec.person_id,
1997: X_ADMISSION_APPL_NUMBER => p_new_admission_appl_number,
1998: X_NOMINATED_COURSE_CD => c_applrep_rec.nominated_course_cd,