APPS.IGS_PS_US_PRENR_CFG_PKG dependencies on IGS_EN_UNIT_SET_ALL

Line 192: FROM IGS_EN_UNIT_SET_ALL us,IGS_EN_UNIT_SET_STAT uss

188: )as
189:
190: CURSOR cur_rowid IS
191: SELECT us.rowid
192: FROM IGS_EN_UNIT_SET_ALL us,IGS_EN_UNIT_SET_STAT uss
193: WHERE unit_set_cd = x_unit_set_cd
194: AND (expiry_dt is NULL or expiry_dt >= SYSDATE)
195: AND us.unit_set_status = uss.unit_set_status AND
196: uss.s_unit_set_status = 'ACTIVE' ;