DBA Data[Home] [Help]

APPS.IGS_UC_EXPORT_DECISION_REPLY dependencies on IGS_PS_US_PRENR_CFG

Line 121: IGS_PS_US_PRENR_CFG CFG

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
125: AND COUS.CRV_VERSION_NUMBER = P_CRV_VERSION_NUMBER

Line 146: IGS_PS_US_PRENR_CFG CFG

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
150: AND COOUS.CRV_VERSION_NUMBER = P_CRV_VERSION_NUMBER

Line 1550: IGS_PS_US_PRENR_CFG CFG

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
1554: AND COUS.CRV_VERSION_NUMBER = P_CRV_VERSION_NUMBER

Line 1575: IGS_PS_US_PRENR_CFG CFG

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
1579: AND COOUS.CRV_VERSION_NUMBER = P_CRV_VERSION_NUMBER