[Home] [Help]
138: raise;
139: end;
140: -- update the doc_id value in JTF_IH_ACTIVITES for doc_ref
141: -- (object_code) values that populate doc_id with party_id values
142: update jtf_ih_activities
143: set doc_id = p_to_fk_id
144: where doc_id = p_from_fk_id
145: and doc_ref IN (
146: select object_code