APPS.IGS_SS_ENROLL_PKG dependencies on IGS_PS_VER

Line 1093: igs_ps_ver cv

1089:
1090: CURSOR cur_prg_atmpt(cp_program_cd igs_en_stdnt_ps_att.course_cd%TYPE) IS
1091: SELECT course_type
1092: FROM igs_en_stdnt_ps_att sca,
1093: igs_ps_ver cv
1094: WHERE sca.person_id = p_person_id
1095: AND sca.course_cd = cp_program_cd
1096: AND cv.course_cd = sca.course_cd
1097: AND cv.version_number = sca.version_number;

Line 1098: l_c_src_course_type igs_ps_ver.course_type%TYPE;

1094: WHERE sca.person_id = p_person_id
1095: AND sca.course_cd = cp_program_cd
1096: AND cv.course_cd = sca.course_cd
1097: AND cv.version_number = sca.version_number;
1098: l_c_src_course_type igs_ps_ver.course_type%TYPE;
1099: l_c_dest_course_type igs_ps_ver.course_type%TYPE;
1100:
1101: BEGIN
1102: IF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') = 'N' THEN

Line 1099: l_c_dest_course_type igs_ps_ver.course_type%TYPE;

1095: AND sca.course_cd = cp_program_cd
1096: AND cv.course_cd = sca.course_cd
1097: AND cv.version_number = sca.version_number;
1098: l_c_src_course_type igs_ps_ver.course_type%TYPE;
1099: l_c_dest_course_type igs_ps_ver.course_type%TYPE;
1100:
1101: BEGIN
1102: IF FND_PROFILE.VALUE('CAREER_MODEL_ENABLED') = 'N' THEN
1103: RETURN 'Y';