APPS.IGS_PR_GEN_004 dependencies on IGS_PS_UNIT_STAT

Line 3782: IGS_PS_UNIT_STAT us

3778: CURSOR c_uv (
3779: cp_unit_cd IGS_PS_UNIT_VER.unit_cd%TYPE) IS
3780: SELECT 'X'
3781: FROM IGS_PS_UNIT_VER uv,
3782: IGS_PS_UNIT_STAT us
3783: WHERE uv.unit_cd = cp_unit_cd AND
3784: uv.expiry_dt IS NULL AND
3785: us.unit_status = uv.unit_status AND
3786: us.s_unit_status = cst_active;