APPS.IGS_GE_GEN_003 dependencies on DUAL

Line 111: FROM DUAL;

107: BEGIN
108: -- this module inserts and entry into the
109: -- system logging structure
110: SELECT IGS_GE_S_ERROR_LOG_SEQ_NUM_S.nextval INTO L_VAL
111: FROM DUAL;
112:
113: IGS_GE_S_LOG_ENTRY_PKG.INSERT_ROW(
114: x_rowid => l_rowid ,
115: x_s_log_type => p_s_log_type,

Line 168: FROM DUAL;

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;
172: BEGIN

Line 345: FROM dual

341: FOR UPDATE
342: NOWAIT;
343: CURSOR c_chk_other_str_records IS
344: SELECT 'x'
345: FROM dual
346: WHERE EXISTS (
347: SELECT person_id
348: FROM IGS_PE_STD_TODO_REF
349: WHERE person_id = p_person_id AND

Line 463: FROM DUAL;

459: CLOSE c_dup;
460:
461: IF l_flag IS NULL THEN
462: SELECT IGS_PE_STD_TODO_REF_RF_NUM_S.NEXTVAL INTO l_reference_number
463: FROM DUAL;
464:
465: IGS_PE_STD_TODO_REF_PKG.INSERT_ROW (
466: x_rowid => l_rowid ,
467: X_person_id =>p_person_id,

Line 541: FROM dual;

537: ), ' ', NULL, SUBSTRB (USERENV ('CLIENT_INFO'),1,10)
538: )
539: ), NULL
540: )
541: FROM dual;
542: l_org_id NUMBER(15);
543: BEGIN
544: -- Commented out by jbegum as part of Enh bug #2222272
545: -- This code has been commented out to remove multi org functionality from OSS