APPS.PA_PROJECT_UTILS dependencies on PA_PROJECT_STATUSES

Line 23: from pa_project_statuses

19: , x_err_stack IN OUT NOCOPY varchar2) --File.Sql.39 bug 4440895
20: is
21: cursor c1 is
22: select project_status_code
23: from pa_project_statuses
24: where project_status_name = x_project_status;
25:
26: c1_rec c1%rowtype;
27: old_stack varchar2(630);

Line 859: FROM pa_project_assignments ppa, pa_project_statuses pps

855: -- Bug 5750624: Cursor to check the project is allowed to deleted from PJR assignments
856: -- We should not allow to delete project with Confirmed Assignment or if it had any Confirmed assignments in the past which is not Confirmed now.
857: CURSOR c_is_pjr_delete_allowed(l_project_id IN NUMBER) IS
858: SELECT 'N'
859: FROM pa_project_assignments ppa, pa_project_statuses pps
860: WHERE ppa.project_id = l_project_id
861: AND ppa.assignment_type = 'STAFFED_ASSIGNMENT'
862: AND pps.status_type = 'STAFFED_ASGMT'
863: AND ppa.status_code = pps.project_status_code

Line 867: FROM pa_project_assignments ppa, pa_assignments_history pph, pa_project_statuses pps, pa_project_statuses pps1

863: AND ppa.status_code = pps.project_status_code
864: AND pps.project_system_status_code = 'STAFFED_ASGMT_CONF'
865: UNION
866: SELECT 'N'
867: FROM pa_project_assignments ppa, pa_assignments_history pph, pa_project_statuses pps, pa_project_statuses pps1
868: WHERE ppa.project_id = l_project_id
869: AND ppa.assignment_id = pph.assignment_id
870: AND ppa.assignment_type = 'STAFFED_ASSIGNMENT'
871: -- AND pph.assignment_type = 'STAFFED_ASSIGNMENT' -- Not required since a staffed assignment in present is checked with staffed assignment in the past