APPS.PA_PROJECT_UTILS2 dependencies on PA_PROJECT_STATUSES

Line 183: from pa_project_statuses

179:
180: IF x_new_value IS NOT NULL THEN
181: select project_system_status_code
182: into l_system_status_code
183: from pa_project_statuses
184: where project_status_code = X_new_value;
185: END IF;
186:
187: IF (l_system_status_code IN ('APPROVED', 'SUBMITTED')) THEN

Line 708: FROM pa_project_statuses ps,

704: x_msg_count OUT NOCOPY NUMBER,
705: x_msg_data OUT NOCOPY VARCHAR2 ) IS
706: CURSOR c_wf_type IS
707: SELECT ps.workflow_item_type
708: FROM pa_project_statuses ps,
709: pa_projects_all ppa
710: WHERE ppa.project_id = p_project_id
711: AND ppa.project_status_code = ps.project_status_code
712: AND ps.enable_wf_flag = 'Y'

Line 737: l_wf_item_type pa_project_statuses.workflow_item_type%TYPE;

733:
734: Invalid_Arg_Exc EXCEPTION;
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;

Line 738: l_wf_process pa_project_statuses.workflow_process%TYPE;

734: Invalid_Arg_Exc EXCEPTION;
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;