APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_THESIS_SEQ_NUM_S

Line 77: SELECT igs_re_thesis_seq_num_s.nextval

73: WHERE person_id = cp_person_id
74: AND ca_sequence_number = cp_ca_sequence_number;
75:
76: CURSOR c_get_thesis_sequence IS
77: SELECT igs_re_thesis_seq_num_s.nextval
78: FROM dual;
79:
80: l_get_thesis_sequence igs_re_thesis_all.sequence_number%TYPE;
81: