APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on PA_PROJECT_STATUSES

Line 8837: from pa_project_statuses

8833: CURSOR get_wf_info(c_status_code VARCHAR2) IS
8834: select enable_wf_flag, workflow_item_type,
8835: workflow_process, wf_success_status_code,
8836: wf_failure_status_code
8837: from pa_project_statuses
8838: where project_status_code = c_status_code;
8839: --status_code can be STRUCTURE_SUBMITTED, STRUCTURE_REJECTED,
8840: -- STRUCTURE_APPROVED, or STRUCTURE_PUBLISHED
8841:

Line 9142: from pa_project_statuses

9138: CURSOR get_wf_info(c_status_code VARCHAR2) IS
9139: select enable_wf_flag, workflow_item_type,
9140: workflow_process, wf_success_status_code,
9141: wf_failure_status_code
9142: from pa_project_statuses
9143: where project_status_code = c_status_code;
9144:
9145: CURSOR get_status_code(c_status_code VARCHAR2) IS
9146: select '1' from pa_project_statuses

Line 9146: select '1' from pa_project_statuses

9142: from pa_project_statuses
9143: where project_status_code = c_status_code;
9144:
9145: CURSOR get_status_code(c_status_code VARCHAR2) IS
9146: select '1' from pa_project_statuses
9147: where project_status_code = c_status_code
9148: and status_type = 'STRUCTURE';
9149:
9150: BEGIN

Line 9311: from pa_wf_processes pwp, pa_project_statuses pps

9307: /* Bug 2680486 -- Performance changes -- Added the join of wf_type_code to avoid full table scan on pa_wf_processes*/
9308:
9309: CURSOR get_item_key IS
9310: select MAX(pwp.item_key), max(pwp.item_type)
9311: from pa_wf_processes pwp, pa_project_statuses pps
9312: where pwp.item_type = pps.workflow_item_type
9313: and pps.status_type = 'STRUCTURE'
9314: and pps.project_status_code = 'STRUCTURE_SUBMITTED'
9315: and entity_key2 = p_structure_version_id

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'