DBA Data[Home] [Help]

APPS.PA_CONTROL_ITEMS_UTILS dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 743: from wf_item_activity_statuses wias, pa_project_statuses pps

739: CURSOR get_wf_status IS
740: select 'Y' FROM dual
741: WHERE exists
742: (SELECT *
743: from wf_item_activity_statuses wias, pa_project_statuses pps
744: WHERE wias.item_type = pps.WORKFLOW_ITEM_TYPE
745: AND wias.item_key = l_item_key
746: AND wias.activity_status = 'ACTIVE'
747: AND pps.status_type = 'CONTROL_ITEM'