APPS.IGS_AS_VAL_NESO dependencies on IGS_LOOKUPS_VIEW

Line 25: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%type;

21: RETURN boolean IS
22: gv_other_detail VARCHAR2(255);
23: BEGIN
24: DECLARE
25: v_closed_ind IGS_LOOKUPS_VIEW.closed_ind%type;
26: s_unit_status IGS_PS_UNIT_STAT.s_unit_status%type;
27: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
28: CURSOR c_sgcmt IS
29: SELECT sgcmt.closed_ind

Line 30: FROM IGS_LOOKUPS_VIEW sgcmt

26: s_unit_status IGS_PS_UNIT_STAT.s_unit_status%type;
27: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;
28: CURSOR c_sgcmt IS
29: SELECT sgcmt.closed_ind
30: FROM IGS_LOOKUPS_VIEW sgcmt
31: WHERE sgcmt.LOOKUP_TYPE = p_s_grade_creation_method_type;
32: CURSOR c_uv IS
33: SELECT us.s_unit_status
34: FROM IGS_PS_UNIT_VER uv,