APPS.IGS_AD_VAL_SAFT dependencies on IGS_OR_INST_STAT

Line 78: IGS_OR_INST_STAT ist

74: os.s_org_status <> cst_inactive;
75: CURSOR c_ins_ist (cp_institution_cd IGS_OR_UNIT.institution_cd%TYPE) IS
76: SELECT 'X'
77: FROM IGS_OR_INSTITUTION ins,
78: IGS_OR_INST_STAT ist
79: WHERE ins.institution_cd = cp_institution_cd AND
80: ins.local_institution_ind = 'Y' AND
81: ins.institution_status = ist.institution_status AND
82: ist.s_institution_status = cst_active;