DBA Data[Home] [Help]

APPS.IGS_AD_VAL_ACAI_FTR_OFFER dependencies on IGS_RE_CANDIDATURE_SEQ_NUM_S

Line 64: SELECT igs_re_candidature_seq_num_s.nextval

60: AND acai_nominated_course_cd = cp_acai_nominated_course_cd
61: AND acai_sequence_number = cp_acai_sequence_number;
62:
63: CURSOR c_get_candidature_sequence IS
64: SELECT igs_re_candidature_seq_num_s.nextval
65: FROM dual;
66:
67: l_get_candidature_sequence igs_re_candidature.sequence_number%TYPE;
68: