APPS.IGS_AS_GEN_005 dependencies on IGS_PS_UNIT_STAT

Line 492: igs_ps_unit_stat ust,

488: CURSOR c_uai (cp_ass_id igs_as_unitass_item.ass_id%TYPE) IS
489: SELECT uai.ass_id
490: FROM igs_ca_stat cs,
491: igs_ca_inst ci,
492: igs_ps_unit_stat ust,
493: igs_ps_unit_ver uv,
494: igs_as_unitass_item uai
495: WHERE cs.s_cal_status <> 'INACTIVE'
496: AND ci.cal_status = cs.cal_status