APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJECT_STATUSES

Line 9209: from pa_project_statuses

9205: CURSOR get_wf_info(c_status_code VARCHAR2) IS
9206: select enable_wf_flag, workflow_item_type,
9207: workflow_process, wf_success_status_code,
9208: wf_failure_status_code
9209: from pa_project_statuses
9210: where project_status_code = c_status_code;
9211: --status_code can be STRUCTURE_SUBMITTED, STRUCTURE_REJECTED,
9212: -- STRUCTURE_APPROVED, or STRUCTURE_PUBLISHED
9213:

Line 9514: from pa_project_statuses

9510: CURSOR get_wf_info(c_status_code VARCHAR2) IS
9511: select enable_wf_flag, workflow_item_type,
9512: workflow_process, wf_success_status_code,
9513: wf_failure_status_code
9514: from pa_project_statuses
9515: where project_status_code = c_status_code;
9516:
9517: CURSOR get_status_code(c_status_code VARCHAR2) IS
9518: select '1' from pa_project_statuses

Line 9518: select '1' from pa_project_statuses

9514: from pa_project_statuses
9515: where project_status_code = c_status_code;
9516:
9517: CURSOR get_status_code(c_status_code VARCHAR2) IS
9518: select '1' from pa_project_statuses
9519: where project_status_code = c_status_code
9520: and status_type = 'STRUCTURE';
9521:
9522: BEGIN

Line 9683: from pa_wf_processes pwp, pa_project_statuses pps

9679: /* Bug 2680486 -- Performance changes -- Added the join of wf_type_code to avoid full table scan on pa_wf_processes*/
9680:
9681: CURSOR get_item_key IS
9682: select MAX(pwp.item_key), max(pwp.item_type)
9683: from pa_wf_processes pwp, pa_project_statuses pps
9684: where pwp.item_type = pps.workflow_item_type
9685: and pps.status_type = 'STRUCTURE'
9686: and pps.project_status_code = 'STRUCTURE_SUBMITTED'
9687: and entity_key2 = p_structure_version_id

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'