DBA Data[Home] [Help]

APPS.IEM_REROUTE_PUB dependencies on JTF_IH_WRAP_UPS

Line 147: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu

143: l_activity_rec.action_item_id := 45;-- EMAIL
144: BEGIN
145: select wu.outcome_id, wu.result_id, wu.reason_id INTO
146: l_activity_rec.outcome_id, l_activity_rec.result_id, l_activity_rec.reason_id
147: from jtf_ih_action_action_items aa, jtf_ih_wrap_ups wu
148: where aa.action_id =l_activity_rec.action_id
149: and aa.action_item_id = l_activity_rec.action_item_id
150: and aa.default_wrap_id = wu.wrap_id;
151: EXCEPTION WHEN OTHERS THEN