APPS.IGS_AD_VAL_SAFT dependencies on IGS_OR_UNIT

Line 65: v_institution_cd IGS_OR_UNIT.institution_cd%TYPE;

61: -- INSTITUTION in not inactive.
62: DECLARE
63: cst_inactive CONSTANT VARCHAR2(10) := 'INACTIVE';
64: cst_active CONSTANT VARCHAR2(10) := 'ACTIVE';
65: v_institution_cd IGS_OR_UNIT.institution_cd%TYPE;
66: v_dummy VARCHAR2(1);
67: CURSOR c_ou_os IS
68: SELECT ou.institution_cd
69: FROM IGS_OR_UNIT ou,

Line 69: FROM IGS_OR_UNIT ou,

65: v_institution_cd IGS_OR_UNIT.institution_cd%TYPE;
66: v_dummy VARCHAR2(1);
67: CURSOR c_ou_os IS
68: SELECT ou.institution_cd
69: FROM IGS_OR_UNIT ou,
70: IGS_OR_STATUS os
71: WHERE ou.org_unit_cd = p_org_unit_cd AND
72: ou.start_dt = p_ou_start_dt AND
73: os.org_status = ou.org_status AND

Line 75: CURSOR c_ins_ist (cp_institution_cd IGS_OR_UNIT.institution_cd%TYPE) IS

71: WHERE ou.org_unit_cd = p_org_unit_cd AND
72: ou.start_dt = p_ou_start_dt AND
73: os.org_status = ou.org_status AND
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