APPS.IGS_AS_VAL_NESO dependencies on IGS_EN_STDNT_PS_ATT

Line 27: v_person_id IGS_EN_STDNT_PS_ATT.person_id%TYPE;

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
31: WHERE sgcmt.LOOKUP_TYPE = p_s_grade_creation_method_type;

Line 41: FROM IGS_EN_STDNT_PS_ATT sca

37: uv.version_number = p_version_number AND
38: us.UNIT_STATUS = uv.UNIT_STATUS;
39: CURSOR c_sca IS
40: SELECT sca.person_id
41: FROM IGS_EN_STDNT_PS_ATT sca
42: WHERE sca.person_id = p_person_id;
43: CURSOR c_sca2 IS
44: SELECT sca.person_id
45: FROM IGS_EN_STDNT_PS_ATT sca

Line 45: FROM IGS_EN_STDNT_PS_ATT sca

41: FROM IGS_EN_STDNT_PS_ATT sca
42: WHERE sca.person_id = p_person_id;
43: CURSOR c_sca2 IS
44: SELECT sca.person_id
45: FROM IGS_EN_STDNT_PS_ATT sca
46: WHERE sca.person_id = p_person_id AND
47: sca.course_cd = p_course_cd;
48: BEGIN
49: -- Validate the insert of a IGS_AS_NON_ENR_STDOT record.