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