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')