APPS.IGS_ST_GEN_001 dependencies on IGS_AS_UNIT_CLASS

Line 35: IGS_AS_UNIT_CLASS ucl,

31: CURSOR c_count_unit_mode IS
32: SELECT COUNT(UNIQUE um.s_unit_mode)
33: FROM IGS_ST_GVT_STDNTLOAD gslo,
34: IGS_EN_ST_SNAPSHOT ess,
35: IGS_AS_UNIT_CLASS ucl,
36: IGS_AS_UNIT_MODE um,
37: IGS_ST_GVT_SPSHT_CTL gsc
38: WHERE gslo.submission_yr = p_submission_yr AND
39: gslo.submission_number = p_submission_number AND

Line 63: IGS_AS_UNIT_CLASS ucl,

59: CURSOR c_chk_unit_mode IS
60: SELECT UNIQUE um.s_unit_mode
61: FROM IGS_ST_GVT_STDNTLOAD gslo,
62: IGS_EN_ST_SNAPSHOT ess,
63: IGS_AS_UNIT_CLASS ucl,
64: IGS_AS_UNIT_MODE um,
65: IGS_ST_GVT_SPSHT_CTL gsc
66: WHERE gslo.submission_yr = p_submission_yr AND
67: gslo.submission_number = p_submission_number AND