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