APPS.IGS_AS_GEN_004 dependencies on IGS_PS_VER

Line 1425: v_course_type igs_ps_ver.course_type%TYPE;

1421: v_dummy VARCHAR2 (1);
1422: v_level VARCHAR2 (10);
1423: v_message_name VARCHAR2 (30);
1424: v_attempt_number igs_as_su_atmpt_itm.attempt_number%TYPE;
1425: v_course_type igs_ps_ver.course_type%TYPE;
1426: v_creation_dt DATE;
1427: l_update_flag VARCHAR2 (20) := 'FALSE';
1428: -- l_grading_schema_cd igs_ps_unitass_item.grading_schema_cd%TYPE;
1429: -- l_gs_version_number igs_ps_unitass_item.gs_version_number%TYPE;

Line 1479: igs_ps_ver crv

1475: --
1476: CURSOR c_crv IS
1477: SELECT crv.course_type
1478: FROM igs_en_stdnt_ps_att sca,
1479: igs_ps_ver crv
1480: WHERE sca.person_id = p_person_id
1481: AND sca.course_cd = p_course_cd
1482: AND sca.course_cd = crv.course_cd
1483: AND sca.version_number = crv.version_number;