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