APPS.IGS_RE_WORKFLOW dependencies on IGS_RE_THESIS_S

Line 28: p_seq_num igs_re_thesis.sequence_number%TYPE) IS

24: AND sequence_number = p_seq_num;
25:
26: CURSOR c_thesis ( p_person_id igs_pe_person.person_id%TYPE,
27: p_ca_seq_num igs_re_thesis.ca_sequence_number%TYPE,
28: p_seq_num igs_re_thesis.sequence_number%TYPE) IS
29: SELECT title, thesis_topic
30: FROM igs_re_thesis
31: WHERE person_id = p_person_id
32: AND ca_sequence_number=p_ca_seq_num

Line 273: SELECT igs_re_thesis_s.NEXTVAL

269:
270: -- Gets a unique sequence number
271:
272: CURSOR c_seq_num IS
273: SELECT igs_re_thesis_s.NEXTVAL
274: FROM dual;
275:
276:
277: -- Getting the Profile value for the profile IGS_WF_ENABLE, to check if workflow is installed in the environment