APPS.IGS_AV_VAL_AS dependencies on IGS_EN_STDNT_PS_ATT

Line 19: FROM IGS_EN_STDNT_PS_ATT spa

15: cp_person_id IGS_AV_ADV_STANDING.person_id%TYPE,
16: cp_course_cd IGS_AV_ADV_STANDING.course_cd%TYPE,
17: cp_version_number IGS_AV_ADV_STANDING.version_number%TYPE) IS
18: SELECT spa.course_cd
19: FROM IGS_EN_STDNT_PS_ATT spa
20: WHERE spa.person_id = cp_person_id AND
21: spa.course_cd = cp_course_cd AND
22: spa.version_number = cp_version_number AND
23: spa.course_attempt_status IN

Line 29: -- It must be contained within a IGS_EN_STDNT_PS_ATT by the nominated

25:
26: BEGIN
27: -- Validate that IGS_AV_ADV_STANDING.course_cd is valid for the purposes of
28: -- Advanced Standing.
29: -- It must be contained within a IGS_EN_STDNT_PS_ATT by the nominated
30: -- person_id, with a status of 'enrolled', 'inactive', 'intermit' or
31: -- 'unconfirm'.
32: p_message_name := null;
33: -- Validate input parameters.