DBA Data[Home] [Help]

APPS.IGS_GE_GEN_003 dependencies on IGS_PE_STD_TODO_SEQ_NUM_S

Line 167: SELECT IGS_PE_STD_TODO_SEQ_NUM_S.nextval

163: logical_delete_dt IS NULL AND
164: (todo_dt IS NULL OR
165: todo_dt <= cp_todo_dt);
166: CURSOR c_get_nxt_seq IS
167: SELECT IGS_PE_STD_TODO_SEQ_NUM_S.nextval
168: FROM DUAL;
169: v_st_rec c_st%ROWTYPE;
170: v_todo_compare IGS_PE_STD_TODO.todo_dt%TYPE;
171: v_sequence_num NUMBER;