DBA Data[Home] [Help]

APPS.PO_SIGNATURE_PVT dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 3457: WF_ITEM_ACTIVITY_STATUSES WIA

3453: -- SQL Why :To find out the name of the Block activity that needs to be completed
3454: SELECT WPA.activity_name
3455: INTO l_activity_name
3456: FROM WF_PROCESS_ACTIVITIES WPA,
3457: WF_ITEM_ACTIVITY_STATUSES WIA
3458: WHERE WIA.item_type = 'POAPPRV'
3459: AND WIA.item_key = p_itemkey
3460: AND WIA.process_activity = WPA.INSTANCE_ID
3461: AND WPA.activity_name IN ('BLOCK_PREAPP','BLOCK_CHGAPP')