APPS.IGS_ST_VAL_SNAPSHOT dependencies on IGS_OR_INST_STAT
Line 16: IGS_OR_INST_STAT ist,
12: v_results_flag CHAR;
13: CURSOR c_chk_institute_ou IS
14: SELECT 'x'
15: FROM IGS_OR_INSTITUTION ins, 16: IGS_OR_INST_STAT ist, 17: IGS_OR_UNIT ou
18: WHERE ins.local_institution_ind = 'Y' AND
19: ist.institution_status = ist.institution_status AND
20: ist.s_institution_status = 'ACTIVE' AND