eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_EN_WORKFLOW dependencies on IGS_RE_SPRVSR

Line 746: CURSOR cur_thesis_supervisor(cp_person_id igs_re_sprvsr.person_id%TYPE,

742: WHERE person_id = cp_person_id;
743:
744: l_cur_person_number cur_person_number%ROWTYPE;
745:
746: CURSOR cur_thesis_supervisor(cp_person_id igs_re_sprvsr.person_id%TYPE,
747: cp_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
748: SELECT person_id , sequence_number
749: FROM igs_re_sprvsr sup
750: WHERE ca_person_id = cp_person_id

Line 747: cp_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS

743:
744: l_cur_person_number cur_person_number%ROWTYPE;
745:
746: CURSOR cur_thesis_supervisor(cp_person_id igs_re_sprvsr.person_id%TYPE,
747: cp_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
748: SELECT person_id , sequence_number
749: FROM igs_re_sprvsr sup
750: WHERE ca_person_id = cp_person_id
751: AND ca_sequence_number = cp_sequence_number

Line 749: FROM igs_re_sprvsr sup

745:
746: CURSOR cur_thesis_supervisor(cp_person_id igs_re_sprvsr.person_id%TYPE,
747: cp_sequence_number igs_re_sprvsr.ca_sequence_number%TYPE) IS
748: SELECT person_id , sequence_number
749: FROM igs_re_sprvsr sup
750: WHERE ca_person_id = cp_person_id
751: AND ca_sequence_number = cp_sequence_number
752: AND (end_dt IS NULL OR end_dt > SYSDATE );
753: