APPS.IGS_GE_GEN_004 dependencies on IGS_EN_UNIT_SET_STAT

Line 291: igs_en_unit_set_stat uss

287: FROM igs_en_unit_set us_out
288: WHERE us_out.unit_set_cd = cp_unit_set_cd
289: AND us_out.version_number = (SELECT version_number
290: FROM igs_en_unit_set us_in ,
291: igs_en_unit_set_stat uss
292: WHERE uss.unit_set_status = us_in.unit_set_status
293: AND us_in.unit_set_cd = us_out.unit_set_cd
294: AND uss.s_unit_set_status = 'ACTIVE'
295: AND rownum = 1);