APPS.IGS_EN_GEN_005 dependencies on IGS_PS_UNIT_VER

Line 476: IGS_PS_UNIT_VER uv,

472: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
473: CURSOR c_uoo IS
474: SELECT uoo_id
475: FROM IGS_PS_UNIT_OFR_OPT uoo,
476: IGS_PS_UNIT_VER uv,
477: IGS_PS_UNIT_STAT us
478: WHERE uoo.unit_cd = p_unit_cd AND
479: uoo.cal_type = p_cal_type AND
480: uoo.ci_sequence_number = p_sequence_number AND

Line 493: IGS_PS_UNIT_VER uv,

489: CURSOR c_uoo2 IS
490: SELECT uoo.uoo_id,
491: um.s_unit_mode
492: FROM IGS_PS_UNIT_OFR_OPT uoo,
493: IGS_PS_UNIT_VER uv,
494: IGS_PS_UNIT_STAT us,
495: IGS_AS_UNIT_CLASS uc,
496: IGS_AS_UNIT_MODE um
497: WHERE uoo.unit_cd = p_unit_cd AND