39: AND acai_sequence_number = cp_acai_sequence_number;
40:
41: CURSOR c_get_candidature_sequence IS
42: SELECT igs_re_candidature_seq_num_s.nextval
43: FROM dual;
44:
45: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
46:
47: CURSOR c_get_thesis (cp_person_id igs_re_thesis_all.person_id%TYPE,
52: AND ca_sequence_number = cp_ca_sequence_number;
53:
54: CURSOR c_get_thesis_sequence IS
55: SELECT igs_re_thesis_seq_num_s.nextval
56: FROM dual;
57:
58: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
59:
60: CURSOR c_get_cdt_fld_of_sy (cp_person_id igs_re_cdt_fld_of_sy.person_id%TYPE,