APPS.IGS_HE_ST_UNT_VS_ALL_PKG dependencies on IGS_EN_SU_ATTEMPT

Line 250: CURSOR cur_unit_attempt(cp_unit_cd igs_en_su_attempt.course_cd%TYPE,

246:
247: END get_fk_igs_ps_unit_ver_all;
248:
249: PROCEDURE check_unit_attempt_exists AS
250: CURSOR cur_unit_attempt(cp_unit_cd igs_en_su_attempt.course_cd%TYPE,
251: cp_version igs_en_su_attempt.version_number%TYPE
252: ) IS
253: SELECT 'X' FROM igs_en_su_attempt
254: WHERE unit_cd = cp_unit_cd

Line 251: cp_version igs_en_su_attempt.version_number%TYPE

247: END get_fk_igs_ps_unit_ver_all;
248:
249: PROCEDURE check_unit_attempt_exists AS
250: CURSOR cur_unit_attempt(cp_unit_cd igs_en_su_attempt.course_cd%TYPE,
251: cp_version igs_en_su_attempt.version_number%TYPE
252: ) IS
253: SELECT 'X' FROM igs_en_su_attempt
254: WHERE unit_cd = cp_unit_cd
255: AND version_number = cp_version;

Line 253: SELECT 'X' FROM igs_en_su_attempt

249: PROCEDURE check_unit_attempt_exists AS
250: CURSOR cur_unit_attempt(cp_unit_cd igs_en_su_attempt.course_cd%TYPE,
251: cp_version igs_en_su_attempt.version_number%TYPE
252: ) IS
253: SELECT 'X' FROM igs_en_su_attempt
254: WHERE unit_cd = cp_unit_cd
255: AND version_number = cp_version;
256:
257: l_unit_attempt VARCHAR2(1);