DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 2714: WF_ITEM_ACTIVITY_STATUSES WIA

2710: -- SQL Why :To find out the name of the Block activity that needs to be completed
2711: SELECT WPA.activity_name
2712: INTO l_activity_name
2713: FROM WF_PROCESS_ACTIVITIES WPA,
2714: WF_ITEM_ACTIVITY_STATUSES WIA
2715: WHERE WIA.item_type = 'POAPPRV'
2716: AND WIA.item_key = p_itemkey
2717: AND WIA.process_activity = WPA.INSTANCE_ID
2718: AND WPA.activity_name IN ('BLOCK_PREAPP','BLOCK_CHGAPP')