APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_PS_OF_OPT_UNT_ST

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

135: AND US.UNIT_SET_CAT = USC.UNIT_SET_CAT
136: AND USC.S_UNIT_SET_CAT ='PRENRL_YR'
137: AND US.UNIT_SET_CD = CFG.UNIT_SET_CD
138: AND CFG.SEQUENCE_NO = NVL(P_POINT_OF_ENTRY,1)
139: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
140: UNION ALL
141: SELECT US.UNIT_SET_CD,
142: US.VERSION_NUMBER US_VERSION_NUMBER
143: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

Line 143: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

139: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
140: UNION ALL
141: SELECT US.UNIT_SET_CD,
142: US.VERSION_NUMBER US_VERSION_NUMBER
143: FROM IGS_PS_OF_OPT_UNT_ST COOUS,
144: IGS_EN_UNIT_SET US,
145: IGS_EN_UNIT_SET_CAT USC,
146: IGS_PS_US_PRENR_CFG CFG
147: WHERE COOUS.UNIT_SET_CD = P_UNIT_SET_CD

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

1564: AND US.UNIT_SET_CAT = USC.UNIT_SET_CAT
1565: AND USC.S_UNIT_SET_CAT ='PRENRL_YR'
1566: AND US.UNIT_SET_CD = CFG.UNIT_SET_CD
1567: AND CFG.SEQUENCE_NO = NVL(P_POINT_OF_ENTRY,1)
1568: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
1569: UNION ALL
1570: SELECT US.UNIT_SET_CD,
1571: US.VERSION_NUMBER US_VERSION_NUMBER
1572: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

Line 1572: FROM IGS_PS_OF_OPT_UNT_ST COOUS,

1568: AND NOT EXISTS (SELECT COURSE_CD FROM IGS_PS_OF_OPT_UNT_ST COOUS WHERE COOUS.COO_ID = COO.COO_ID)
1569: UNION ALL
1570: SELECT US.UNIT_SET_CD,
1571: US.VERSION_NUMBER US_VERSION_NUMBER
1572: FROM IGS_PS_OF_OPT_UNT_ST COOUS,
1573: IGS_EN_UNIT_SET US,
1574: IGS_EN_UNIT_SET_CAT USC,
1575: IGS_PS_US_PRENR_CFG CFG
1576: WHERE COOUS.UNIT_SET_CD = P_UNIT_SET_CD