APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_EN_UNIT_SET

Line 119: IGS_EN_UNIT_SET US,

115: SELECT US.UNIT_SET_CD,
116: US.VERSION_NUMBER US_VERSION_NUMBER
117: FROM IGS_PS_OFR_UNIT_SET COUS,
118: IGS_PS_OFR_OPT COO,
119: IGS_EN_UNIT_SET US,
120: IGS_EN_UNIT_SET_CAT USC,
121: IGS_PS_US_PRENR_CFG CFG
122: WHERE COUS.UNIT_SET_CD = P_UNIT_SET_CD
123: AND COUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER

Line 120: IGS_EN_UNIT_SET_CAT USC,

116: US.VERSION_NUMBER US_VERSION_NUMBER
117: FROM IGS_PS_OFR_UNIT_SET COUS,
118: IGS_PS_OFR_OPT COO,
119: IGS_EN_UNIT_SET US,
120: IGS_EN_UNIT_SET_CAT USC,
121: IGS_PS_US_PRENR_CFG CFG
122: WHERE COUS.UNIT_SET_CD = P_UNIT_SET_CD
123: AND COUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER
124: AND COUS.COURSE_CD = P_NOMINATED_COURSE_CD

Line 144: IGS_EN_UNIT_SET US,

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
148: AND COOUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER

Line 145: IGS_EN_UNIT_SET_CAT USC,

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
148: AND COOUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER
149: AND COOUS.COURSE_CD = P_NOMINATED_COURSE_CD

Line 1548: IGS_EN_UNIT_SET US,

1544: SELECT US.UNIT_SET_CD,
1545: US.VERSION_NUMBER US_VERSION_NUMBER
1546: FROM IGS_PS_OFR_UNIT_SET COUS,
1547: IGS_PS_OFR_OPT COO,
1548: IGS_EN_UNIT_SET US,
1549: IGS_EN_UNIT_SET_CAT USC,
1550: IGS_PS_US_PRENR_CFG CFG
1551: WHERE COUS.UNIT_SET_CD = P_UNIT_SET_CD
1552: AND COUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER

Line 1549: IGS_EN_UNIT_SET_CAT USC,

1545: US.VERSION_NUMBER US_VERSION_NUMBER
1546: FROM IGS_PS_OFR_UNIT_SET COUS,
1547: IGS_PS_OFR_OPT COO,
1548: IGS_EN_UNIT_SET US,
1549: IGS_EN_UNIT_SET_CAT USC,
1550: IGS_PS_US_PRENR_CFG CFG
1551: WHERE COUS.UNIT_SET_CD = P_UNIT_SET_CD
1552: AND COUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER
1553: AND COUS.COURSE_CD = P_NOMINATED_COURSE_CD

Line 1573: IGS_EN_UNIT_SET US,

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
1577: AND COOUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER

Line 1574: IGS_EN_UNIT_SET_CAT USC,

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
1577: AND COOUS.US_VERSION_NUMBER = P_US_VERSION_NUMBER
1578: AND COOUS.COURSE_CD = P_NOMINATED_COURSE_CD