APPS.IGS_GE_PRC_TRANSFER dependencies on DUAL

Line 133: FROM DUAL ;

129: LOOP
130: EXIT WHEN c_get_todo_rec_for_update%NOTFOUND;
131: v_insert_not_req_flag := TRUE;
132: SELECT IGS_PE_STD_TODO_SEQ_NUM_S.NEXTVAL INTO L_VAL
133: FROM DUAL ;
134: IGS_PE_STD_TODO_PKG.UPDATE_ROW(
135: x_rowid => v_existing_st_record.ROWID ,
136: X_PERSON_ID => v_existing_st_record.PERSON_ID,
137: X_S_STUDENT_TODO_TYPE => v_existing_st_record.S_STUDENT_TODO_TYPE,

Line 162: FROM DUAL ;

158: RETURN;
159: END IF;
160: --- Insert a record into the IGS_PE_STD_TODO table using the parameters.
161: SELECT IGS_PE_STD_TODO_SEQ_NUM_S.nextval INTO L_VAL
162: FROM DUAL ;
163: IGS_PE_STD_TODO_PKG.INSERT_ROW (
164: X_ROWID => L_ROWID,
165: x_person_id =>p_person_id,
166: x_s_student_todo_type =>p_s_student_todo_type,