DBA Data[Home] [Help]

APPS.OKL_STRY_CALL_CO_PUB dependencies on IEX_STRATEGY_WORK_ITEMS

Line 620: select resource_id from iex_strategy_work_items

616: l_resource_id NUMBER;
617: l_wait_date DATE;
618:
619: cursor c_stry_wkitems (p_workitemid NUMBER) is
620: select resource_id from iex_strategy_work_items
621: where work_item_id =p_workitemid;
622:
623: BEGIN
624:

Line 631: --get resource_id from iex_strategy_work_items

627: return;
628: end if;
629:
630: --call api get vendor approval
631: --get resource_id from iex_strategy_work_items
632: OPEN c_stry_wkitems(itemkey);
633: FETCH c_stry_wkitems INTO l_resource_id;
634: CLOSE c_stry_wkitems;
635: