APPS.IGS_AD_ADM_REQ dependencies on IGS_AD_GEN_002

Line 160: AND igs_ad_gen_002.check_adm_appl_inst_stat(apai.person_id,apai.admission_appl_number,apai.nominated_course_cd,

156: aa.admission_appl_number = apai.admission_appl_number AND
157: NVL(apai.appl_inst_status,aps.adm_appl_status) = aps.adm_appl_status AND
158: aps.s_adm_appl_status <> 'WITHDRAWN' AND -- igsm arvsrini instance withdrawn
159: aps.closed_ind = 'N'
160: AND igs_ad_gen_002.check_adm_appl_inst_stat(apai.person_id,apai.admission_appl_number,apai.nominated_course_cd,
161: apai.sequence_number,'Y')='Y';
162:
163: CURSOR get_dflt_active_track_stat_cur IS
164: SELECT tracking_status