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: