DBA Data[Home] [Help]

APPS.PA_PROJECT_UTILS2 dependencies on PA_WF_PROCESSES

Line 718: FROM pa_wf_processes

714: AND ps.wf_failure_status_code is NOT NULL;
715:
716: CURSOR get_last_workflow_info(p_wf_item_type IN VARCHAR2) IS
717: SELECT MAX(item_key)
718: FROM pa_wf_processes
719: WHERE item_type = p_wf_item_type
720: AND entity_key1 = p_project_id
721: AND wf_type_code = 'PROJECT';
722:

Line 739: l_item_key pa_wf_processes.item_key%TYPE;

735:
736: l_diagramUrl VARCHAR2(2000);
737: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;
738: l_wf_process pa_project_statuses.workflow_process%TYPE;
739: l_item_key pa_wf_processes.item_key%TYPE;
740: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;
741: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;
742: l_comment pa_ci_comments.comment_text%TYPE;
743: