APPS.IGS_UC_EXPORT_TO_OSS dependencies on IGS_PS_OF_OPT_UNT_ST

Line 194: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)

190: AND US.UNIT_SET_CAT = USC.UNIT_SET_CAT
191: AND USC.S_UNIT_SET_CAT ='PRENRL_YR'
192: AND US.UNIT_SET_CD = CFG.UNIT_SET_CD
193: AND CFG.SEQUENCE_NO = P_SEQ_NO
194: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
195: UNION ALL
196: SELECT US.UNIT_SET_CD,
197: US.VERSION_NUMBER US_VERSION_NUMBER
198: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

Line 198: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

194: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
195: UNION ALL
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

Line 1049: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)

1045: AND US.UNIT_SET_CAT = USC.UNIT_SET_CAT
1046: AND USC.S_UNIT_SET_CAT ='PRENRL_YR'
1047: AND US.UNIT_SET_CD = CFG.UNIT_SET_CD
1048: AND CFG.SEQUENCE_NO = P_SEQ_NO
1049: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
1050: UNION ALL
1051: SELECT US.UNIT_SET_CD,
1052: US.VERSION_NUMBER US_VERSION_NUMBER
1053: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

Line 1053: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

1049: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
1050: UNION ALL
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