APPS.IGS_GR_VAL_AWC dependencies on IGS_GR_AWD_CRM_UT_ST

Line 316: FROM IGS_GR_AWD_CRM_UT_ST acus

312: AND
313: (EXISTS
314: (SELECT acus.unit_set_cd,
315: acus.us_version_number
316: FROM IGS_GR_AWD_CRM_UT_ST acus
317: WHERE acus.grd_cal_type = acusg1.grd_cal_type AND
318: acus.grd_ci_sequence_number = acusg1.grd_ci_sequence_number AND
319: acus.ceremony_number = acusg1.ceremony_number AND
320: acus.award_course_cd = acusg1.award_course_cd AND

Line 327: FROM IGS_GR_AWD_CRM_UT_ST acus

323: acus.us_group_number = acusg1.us_group_number
324: MINUS
325: SELECT acus.unit_set_cd,
326: acus.us_version_number
327: FROM IGS_GR_AWD_CRM_UT_ST acus
328: WHERE acus.grd_cal_type = acusg2.grd_cal_type AND
329: acus.grd_ci_sequence_number = acusg2.grd_ci_sequence_number AND
330: acus.ceremony_number = acusg2.ceremony_number AND
331: acus.award_course_cd = acusg2.award_course_cd AND

Line 339: FROM IGS_GR_AWD_CRM_UT_ST acus

335: OR
336: EXISTS
337: (SELECT acus.unit_set_cd,
338: acus.us_version_number
339: FROM IGS_GR_AWD_CRM_UT_ST acus
340: WHERE acus.grd_cal_type = acusg2.grd_cal_type AND
341: acus.grd_ci_sequence_number = acusg2.grd_ci_sequence_number AND
342: acus.ceremony_number = acusg2.ceremony_number AND
343: acus.award_course_cd = acusg2.award_course_cd AND

Line 350: FROM IGS_GR_AWD_CRM_UT_ST acus

346: acus.us_group_number = acusg2.us_group_number
347: MINUS
348: SELECT acus.unit_set_cd,
349: acus.us_version_number
350: FROM IGS_GR_AWD_CRM_UT_ST acus
351: WHERE acus.grd_cal_type = acusg1.grd_cal_type AND
352: acus.grd_ci_sequence_number = acusg1.grd_ci_sequence_number AND
353: acus.ceremony_number = acusg1.ceremony_number AND
354: acus.award_course_cd = acusg1.award_course_cd AND