APPS.IGS_AD_VAL_ACAI dependencies on IGS_AD_CODE_CLASSES

Line 3644: FROM igs_ad_code_classes

3640: nominated_course_cd = p_nominated_course_cd AND
3641: sequence_number = p_acai_sequence_number AND
3642: final_decision_type = 'FINAL_INTERVIEW' AND
3643: EXISTS (SELECT 'x'
3644: FROM igs_ad_code_classes
3645: WHERE class = 'FINAL_INTERVIEW'
3646: AND name = final_decision_code
3647: AND system_status <> 'PENDING'
3648: AND CLASS_TYPE_CODE='ADM_CODE_CLASSES');