APPS.IGS_PS_GEN_002 dependencies on IGS_PS_UNIT_VER

Line 235: FROM igs_ps_unit_ver uv

231: cul.unit_cd = p_unit_cd AND
232: cul.version_number = p_unit_version_number;
233: CURSOR c_uv IS
234: SELECT uv.unit_level
235: FROM igs_ps_unit_ver uv
236: WHERE uv.unit_cd = p_unit_cd AND
237: uv.version_number = p_unit_version_number;
238: BEGIN
239: -- Get the IGS_PS_UNIT level of a IGS_PS_UNIT attempt within a nominated IGS_PS_COURSE.

Line 242: -- 1. Search for a IGS_PS_UNIT_LVL record matching the IGS_PS_UNIT version and the

238: BEGIN
239: -- Get the IGS_PS_UNIT level of a IGS_PS_UNIT attempt within a nominated IGS_PS_COURSE.
240: -- Searches for the existence of a IGS_PS_UNIT_LVL record using the
241: -- IGS_PS_UNIT.level
242: -- 1. Search for a IGS_PS_UNIT_LVL record matching the IGS_PS_UNIT version and the
243: -- IGS_PS_COURSE type of the nominated IGS_PS_COURSE.
244: OPEN c_cul_crv;
245: FETCH c_cul_crv INTO v_unit_level;
246: IF (c_cul_crv%FOUND) THEN