APPS.IGS_EN_VAL_PIT dependencies on IGS_OR_INSTITUTION

Line 15: FROM IGS_OR_INSTITUTION ins,

11: DECLARE
12: v_s_ins_status IGS_OR_INST_STAT.s_institution_status%TYPE;
13: CURSOR c_get_s_ins_status IS
14: SELECT s_institution_status
15: FROM IGS_OR_INSTITUTION ins,
16: IGS_OR_INST_STAT ins_s
17: WHERE ins.institution_cd = p_institution_cd AND
18: ins.institution_status = ins_s.institution_status;
19: BEGIN