APPS.IGS_AS_VAL_NESO dependencies on IGS_PS_UNIT_STAT

Line 26: s_unit_status IGS_PS_UNIT_STAT.s_unit_status%type;

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
30: FROM IGS_LOOKUPS_VIEW sgcmt

Line 35: IGS_PS_UNIT_STAT us

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,
35: IGS_PS_UNIT_STAT us
36: WHERE uv.unit_cd = p_unit_cd AND
37: uv.version_number = p_version_number AND
38: us.UNIT_STATUS = uv.UNIT_STATUS;
39: CURSOR c_sca IS