DBA Data[Home] [Help]

APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 9692: from wf_item_activity_statuses wias, pa_project_statuses pps

9688: and pwp.wf_type_code = 'WORKPLAN';
9689:
9690: CURSOR get_wf_status IS
9691: select 'Y'
9692: from wf_item_activity_statuses wias, pa_project_statuses pps
9693: where wias.item_type = pps.WORKFLOW_ITEM_TYPE
9694: and wias.item_key = l_item_key
9695: and wias.activity_status = 'ACTIVE'
9696: and pps.status_type = 'STRUCTURE'