APPS.IGS_EN_VAL_PIT dependencies on IGS_OR_INST_STAT

Line 12: v_s_ins_status IGS_OR_INST_STAT.s_institution_status%TYPE;

8: RETURN BOOLEAN AS
9: BEGIN -- enrp_val_pit_inst_cd
10: -- validate that the institution code for a person_id is active
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

Line 16: IGS_OR_INST_STAT ins_s

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
20: OPEN c_get_s_ins_status;