APPS.IGS_AS_SU_SETATMPT_PKG dependencies on IGS_PS_OFR_OPT_UNIT_SET_V

Line 140: FROM IGS_PS_OFR_OPT_UNIT_SET_V usoo,

136: ) AS
137: -- check whether the unit set is a valid one for the prorgam offering option
138: CURSOR c_us_valid IS
139: SELECT 'x'
140: FROM IGS_PS_OFR_OPT_UNIT_SET_V usoo,
141: IGS_EN_STDNT_PS_ATT spa
142: WHERE spa.person_id = new_references.person_id
143: AND spa.course_cd = new_references.course_cd
144: AND usoo.unit_set_cd = new_references.unit_set_cd