DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 9320: from wf_item_activity_statuses wias, pa_project_statuses pps

9316: and pwp.wf_type_code = 'WORKPLAN';
9317:
9318: CURSOR get_wf_status IS
9319: select 'Y'
9320: from wf_item_activity_statuses wias, pa_project_statuses pps
9321: where wias.item_type = pps.WORKFLOW_ITEM_TYPE
9322: and wias.item_key = l_item_key
9323: and wias.activity_status = 'ACTIVE'
9324: and pps.status_type = 'STRUCTURE'