APPS.PA_PROJECT_UTILS2 dependencies on PA_OBJ_STATUS_CHANGES

Line 728: FROM pa_obj_status_changes

724: SELECT a.old_project_status_code, a.new_project_status_code
725: FROM ( SELECT obj_status_change_id,
726: old_project_status_code,
727: new_project_status_code
728: FROM pa_obj_status_changes
729: WHERE object_type = 'PA_PROJECTS'
730: AND object_id = p_project_id
731: ORDER BY obj_status_change_id DESC ) a
732: WHERE ROWNUM = 1;

Line 740: l_prev_status pa_obj_status_changes.old_project_status_code%TYPE;

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:
744: l_debug_mode VARCHAR2(1);

Line 741: l_curr_status pa_obj_status_changes.new_project_status_code%TYPE;

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:
744: l_debug_mode VARCHAR2(1);
745: l_calling_module VARCHAR2(50) := 'SSO_ABORT'; -- for the BUG # 6661144