APPS.IGS_EN_IVR_PUB dependencies on IGS_EN_SCA_V

Line 1902: FROM igs_en_sca_v

1898: CURSOR c_career_mode (lc_person_id igs_pe_person.person_id%TYPE) IS
1899: SELECT course_type,
1900: course_cd,
1901: version_number
1902: FROM igs_en_sca_v
1903: WHERE primary_program_type ='PRIMARY'
1904: AND Course_attempt_status IN ('ENROLLED','INACTIVE')
1905: AND person_id = lc_person_id;
1906:

Line 1914: FROM igs_en_sca_v

1910: CURSOR c_program_mode (lc_person_id igs_pe_person.person_id%TYPE) IS
1911: SELECT course_type,
1912: course_cd,
1913: version_number
1914: FROM igs_en_sca_v
1915: WHERE course_attempt_status IN ('ENROLLED','INACTIVE')
1916: AND person_id = lc_person_id;
1917:
1918: BEGIN -- main begin