DBA Data[Home] [Help]

APPS.IGS_EN_SPA_LGCY_PUB dependencies on DUAL

Line 889: CURSOR cur_re_seq IS SELECT igs_re_candidature_seq_num_s.NEXTVAL FROM DUAL;

885: CURSOR cur_re_prg(p_prg_type igs_ps_type.course_type%TYPE) IS
886: SELECT research_type_ind FROM igs_ps_type
887: WHERE course_type = p_prg_type;
888: --Cursor is to get the sequence number for the candidature.
889: CURSOR cur_re_seq IS SELECT igs_re_candidature_seq_num_s.NEXTVAL FROM DUAL;
890:
891: --local variables for flags
892: l_err_derive_flag VARCHAR2(1);
893: l_execution_flag1 VARCHAR2(1);