APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_EN_UNIT_SET_CAT

Line 177: IGS_EN_UNIT_SET_CAT USC,

173: US.VERSION_NUMBER US_VERSION_NUMBER
174: FROM IGS_PS_OFR_UNIT_SET COUS,
175: IGS_PS_OFR_OPT COO,
176: IGS_EN_UNIT_SET US,
177: IGS_EN_UNIT_SET_CAT USC,
178: IGS_PS_US_PRENR_CFG CFG
179: WHERE COUS.COURSE_CD = P_COURSE_CD
180: AND COUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
181: AND COUS.CAL_TYPE = P_ACAD_CAL_TYPE

Line 200: IGS_EN_UNIT_SET_CAT USC,

196: SELECT US.UNIT_SET_CD,
197: US.VERSION_NUMBER US_VERSION_NUMBER
198: FROM IGS_PS_OF_OPT_UNT_ST COOUS,
199: IGS_EN_UNIT_SET US,
200: IGS_EN_UNIT_SET_CAT USC,
201: IGS_PS_US_PRENR_CFG CFG
202: WHERE COOUS.COURSE_CD = P_COURSE_CD
203: AND COOUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
204: AND COOUS.CAL_TYPE = P_ACAD_CAL_TYPE

Line 1032: IGS_EN_UNIT_SET_CAT USC,

1028: US.VERSION_NUMBER US_VERSION_NUMBER
1029: FROM IGS_PS_OFR_UNIT_SET COUS,
1030: IGS_PS_OFR_OPT COO,
1031: IGS_EN_UNIT_SET US,
1032: IGS_EN_UNIT_SET_CAT USC,
1033: IGS_PS_US_PRENR_CFG CFG
1034: WHERE COUS.COURSE_CD = P_COURSE_CD
1035: AND COUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
1036: AND COUS.CAL_TYPE = P_ACAD_CAL_TYPE

Line 1055: IGS_EN_UNIT_SET_CAT USC,

1051: SELECT US.UNIT_SET_CD,
1052: US.VERSION_NUMBER US_VERSION_NUMBER
1053: FROM IGS_PS_OF_OPT_UNT_ST COOUS,
1054: IGS_EN_UNIT_SET US,
1055: IGS_EN_UNIT_SET_CAT USC,
1056: IGS_PS_US_PRENR_CFG CFG
1057: WHERE COOUS.COURSE_CD = P_COURSE_CD
1058: AND COOUS.CRV_VERSION_NUMBER = P_VERSION_NUMBER
1059: AND COOUS.CAL_TYPE = P_ACAD_CAL_TYPE

Line 1139: igs_en_unit_set_cat usc,

1135: igs_uc_sys_calndrs ucal,
1136: igs_ad_appl_all apl,
1137: igs_ad_ps_appl_inst_all aplinst,
1138: igs_en_unit_set us,
1139: igs_en_unit_set_cat usc,
1140: igs_ps_us_prenr_cfg cnfg,
1141: igs_uc_map_out_stat mos,
1142: igs_uc_map_off_resp mor
1143: WHERE uac.app_no = cp_app_no