APPS.IGS_AD_TI_COMP dependencies on IGS_AD_TRANSCRIPT

Line 140: FROM igs_ad_transcript c

136: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')
137: AND status = 'A'
138: AND exists (
139: SELECT 'x'
140: FROM igs_ad_transcript c
141: WHERE c.education_id = a.education_id
142: AND c.transcript_status = 'FINAL'
143: AND c.transcript_type ='OFFICIAL');
144:

Line 159: FROM igs_ad_transcript c

155: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')
156: AND status = 'A'
157: AND exists (
158: SELECT 'x'
159: FROM igs_ad_transcript c
160: WHERE c.education_id = a.education_id
161: AND c.transcript_status IN ('FINAL','PARTIAL')
162: AND c.transcript_type ='OFFICIAL');
163:

Line 178: FROM igs_ad_transcript c

174: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')
175: AND status = 'A'
176: AND exists (
177: SELECT 'x'
178: FROM igs_ad_transcript c
179: WHERE c.education_id = a.education_id
180: AND c.transcript_status = 'FINAL'
181: AND c.transcript_type ='UNOFFICIAL');
182:

Line 197: FROM igs_ad_transcript c

193: AND NVL(degree_earned,NVL(p_degree_earned,'*')) = NVL(p_degree_earned,'*')
194: AND status = 'A'
195: AND exists (
196: SELECT 'x'
197: FROM igs_ad_transcript c
198: WHERE c.education_id = a.education_id
199: AND c.transcript_status IN ('FINAL','PARTIAL')
200: AND c.transcript_type ='UNOFFICIAL');
201: