143: from per_people_v
144: where row_id = chartorowid(p_rowid);
145: --
146: cursor per1 is select *
147: from per_people_f
148: where rowid = chartorowid(p_rowid)
149: for update nowait;
150: --
151: -- Local variables.
404: --or (per_rec.work_telephone is null))
405: -- FIX for WWBUG 436781
406: -- GP
407: -- This is being done as the work telephone can be derived from either the
408: -- PER_PEOPLE_F table or from the PER_PHONES table. If the PER_PHONES table
409: -- is used then the lock fails as the database value is different from the
410: -- form value and thus the lock assumes an update has occured so asks you
411: -- to requery the record. This never occurs if the work_telephone is entered
412: -- on the form as then the lock succeeds.