APPS.IGS_RE_VAL_THE dependencies on IGS_RE_THESIS_ALL

Line 676: FROM igs_re_thesis_all the,

672: || (reverse chronological order - newest change first)
673: */
674: CURSOR c_title IS
675: SELECT title
676: FROM igs_re_thesis_all the,
677: igs_re_candidature re
678: WHERE the.person_id = p_person_id
679: AND the.title = p_title
680: AND re.sequence_number = p_ca_sequence_number

Line 682: l_title igs_re_thesis_all.title%TYPE;

678: WHERE the.person_id = p_person_id
679: AND the.title = p_title
680: AND re.sequence_number = p_ca_sequence_number
681: AND re.person_id = the.person_id;
682: l_title igs_re_thesis_all.title%TYPE;
683:
684: BEGIN
685: OPEN c_title;
686: FETCH c_title INTO l_title;