APPS.PA_CONTROL_ITEMS_UTILS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 787: from wf_item_activity_statuses wias, pa_project_statuses pps

783: CURSOR get_wf_status IS
784: select 'Y' FROM dual
785: WHERE exists
786: (SELECT *
787: from wf_item_activity_statuses wias, pa_project_statuses pps
788: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
789: AND wias.item_key = l_item_key
790: AND wias.activity_status = 'ACTIVE'
791: AND pps.status_type = 'CONTROL_ITEM'