DBA Data[Home] [Help]

APPS.OE_VALIDATE_LINE dependencies on WF_ACTIVITIES

Line 2253: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A

2249: l_actdate := SYSDATE;
2250:
2251: select INSTANCE_ID
2252: into l_rootid
2253: from WF_PROCESS_ACTIVITIES PA, WF_ACTIVITIES A
2254: where A.ITEM_TYPE = OE_GLOBALS.G_WFI_LIN
2255: and A.NAME = 'ROOT'
2256: and l_actdate >= A.BEGIN_DATE
2257: and l_actdate < NVL(A.END_DATE, l_actdate+1)