APPS.IGS_AD_ASSIGN_EVAL_AI_PKG dependencies on IGS_AD_OU_STAT

Line 51: FROM igs_ad_ou_stat ou

47: AND apl.nominated_course_cd = arp.nominated_course_cd
48: AND apl.sequence_number = arp.sequence_number
49: AND arp.appl_revprof_revgr_id IS NOT NULL
50: AND EXISTS (SELECT '1'
51: FROM igs_ad_ou_stat ou
52: WHERE ou.s_adm_outcome_status = 'PENDING'
53: AND apl.adm_outcome_status = ou.adm_outcome_status )
54: AND NOT EXISTS (SELECT '1'
55: FROM igs_ad_appl_eval aev

Line 77: FROM igs_ad_ou_stat ou

73: AND apl.nominated_course_cd = arp.nominated_course_cd
74: AND apl.sequence_number = arp.sequence_number
75: AND arp.appl_revprof_revgr_id IS NOT NULL
76: AND EXISTS (SELECT '1'
77: FROM igs_ad_ou_stat ou
78: WHERE ou.s_adm_outcome_status = 'PENDING'
79: AND apl.adm_outcome_status = ou.adm_outcome_status )
80: AND NOT EXISTS (SELECT '1'
81: FROM igs_ad_appl_eval aev

Line 104: FROM igs_ad_ou_stat ou

100: AND apl.nominated_course_cd = arp.nominated_course_cd
101: AND apl.sequence_number = arp.sequence_number
102: AND arp.appl_revprof_revgr_id IS NOT NULL
103: AND EXISTS (SELECT '1'
104: FROM igs_ad_ou_stat ou
105: WHERE ou.s_adm_outcome_status = 'PENDING'
106: AND apl.adm_outcome_status = ou.adm_outcome_status )
107: AND NOT EXISTS (SELECT '1'
108: FROM igs_ad_appl_eval aev