APPS.PA_CONTROL_ITEMS_UTILS dependencies on PA_WF_PROCESSES

Line 730: from pa_wf_processes pwp, pa_project_statuses pps

726:
727:
728: CURSOR get_item_key IS
729: SELECT MAX(pwp.item_key), max(pwp.item_type)
730: from pa_wf_processes pwp, pa_project_statuses pps
731: where pwp.item_type = pps.WORKFLOW_ITEM_TYPE
732: and pps.status_type = 'CONTROL_ITEM'
733: and pps.project_status_code = 'CI_SUBMITTED'
734: AND entity_key2 = p_ci_id

Line 1804: FROM pa_wf_processes

1800: and ps.wf_failure_status_code is NOT NULL;
1801:
1802: CURSOR get_last_workflow_info(p_wf_item_type IN VARCHAR2, p_wf_process IN VARCHAR2) IS
1803: SELECT MAX(item_key)
1804: FROM pa_wf_processes
1805: WHERE item_type = p_wf_item_type
1806: AND description = p_wf_process
1807: AND entity_key2 = p_ci_id
1808: AND entity_key1 = p_project_id

Line 1814: l_item_key pa_wf_processes.item_key%TYPE;

1810:
1811: l_diagramUrl VARCHAR2(2000);
1812: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1813: l_wf_process pa_project_statuses.workflow_process%TYPE;
1814: l_item_key pa_wf_processes.item_key%TYPE;
1815:
1816: BEGIN
1817:
1818: OPEN c_wf_type;

Line 1865: FROM pa_wf_processes

1861: and ps.wf_failure_status_code is NOT NULL;
1862:
1863: CURSOR get_last_workflow_info(p_wf_item_type IN VARCHAR2, p_wf_process IN VARCHAR2) IS
1864: SELECT MAX(item_key)
1865: FROM pa_wf_processes
1866: WHERE item_type = p_wf_item_type
1867: AND description = p_wf_process
1868: AND entity_key2 = p_ci_id
1869: AND entity_key1 = p_project_id

Line 1886: l_item_key pa_wf_processes.item_key%TYPE;

1882:
1883: l_diagramUrl VARCHAR2(2000);
1884: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
1885: l_wf_process pa_project_statuses.workflow_process%TYPE;
1886: l_item_key pa_wf_processes.item_key%TYPE;
1887: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
1888: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
1889: l_comment pa_ci_comments.comment_text%TYPE;
1890: BEGIN