APPS.IGS_RE_GEN_002 dependencies on IGS_EN_SU_ATTEMPT

Line 288: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,

284: -- +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++--
285: -- Local function used to set start date to earliest research IGS_PS_UNIT enrolment
286:
287: FUNCTION respl_get_rsch_enrlmnt (
288: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
289: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)
290: RETURN DATE AS
291: BEGIN -- respl_get_rsch_enrlmnt
292: -- Set the start date to earliest research IGS_PS_UNIT enrolment.

Line 289: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)

285: -- Local function used to set start date to earliest research IGS_PS_UNIT enrolment
286:
287: FUNCTION respl_get_rsch_enrlmnt (
288: p_person_id IGS_EN_SU_ATTEMPT.person_id%TYPE,
289: p_course_cd IGS_EN_SU_ATTEMPT.course_cd%TYPE)
290: RETURN DATE AS
291: BEGIN -- respl_get_rsch_enrlmnt
292: -- Set the start date to earliest research IGS_PS_UNIT enrolment.
293: DECLARE

Line 301: FROM IGS_EN_SU_ATTEMPT sua,

297: v_teach_days NUMBER;
298: CURSOR c_sua IS
299: SELECT sua.cal_type,
300: sua.ci_sequence_number
301: FROM IGS_EN_SU_ATTEMPT sua,
302: IGS_PS_UNIT_VER uv
303: WHERE sua.person_id = p_person_id AND
304: sua.course_cd = p_course_cd AND
305: sua.unit_cd = uv.unit_cd AND