DBA Data[Home] [Help]

APPS.IGS_GR_PRC_GAC dependencies on IGS_GR_AWD_CRM_UT_ST

Line 174: FROM IGS_GR_AWD_CRM_UT_ST acus

170: susa.end_dt IS NULL
171: MINUS
172: SELECT acus.unit_set_cd,
173: acus.us_version_number
174: FROM IGS_GR_AWD_CRM_UT_ST acus
175: WHERE acus.grd_cal_type = acusg.grd_cal_type AND
176: acus.grd_ci_sequence_number = acusg.grd_ci_sequence_number AND
177: acus.ceremony_number = acusg.ceremony_number AND
178: acus.award_course_cd = acusg.award_course_cd AND

Line 185: FROM IGS_GR_AWD_CRM_UT_ST acus

181: acus.us_group_number = acusg.us_group_number) AND
182: NOT EXISTS
183: (SELECT acus.unit_set_cd,
184: acus.us_version_number
185: FROM IGS_GR_AWD_CRM_UT_ST acus
186: WHERE acus.grd_cal_type = acusg.grd_cal_type AND
187: acus.grd_ci_sequence_number = acusg.grd_ci_sequence_number AND
188: acus.ceremony_number = acusg.ceremony_number AND
189: acus.award_course_cd = acusg.award_course_cd AND