APPS.OE_COGS_GRP dependencies on WF_PROCESS_ACTIVITIES

Line 258: FROM WF_ITEM_ACTIVITY_STATUSES WAS, WF_PROCESS_ACTIVITIES WPA

254: END IF;
255:
256: BEGIN
257: SELECT 'Y' INTO l_inventory_interfaced
258: FROM WF_ITEM_ACTIVITY_STATUSES WAS, WF_PROCESS_ACTIVITIES WPA
259: WHERE WAS.PROCESS_ACTIVITY = WPA.INSTANCE_ID
260: AND WAS.ITEM_TYPE = 'OEOL'
261: AND WAS.ITEM_KEY = to_char(p_line_id)
262: AND WPA.ACTIVITY_NAME = 'INVENTORY_INTERFACE'