APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_STATUSES

Line 424: pa_project_statuses pps

420: ppa.funding_approval_status_code,
421: pps.project_system_status_code
422: from
423: pa_projects_all ppa,
424: pa_project_statuses pps
425: where
426: ppa.project_id = x_orig_project_id
427: and ppa.funding_approval_status_code = pps.project_status_code;
428:

Line 788: from pa_project_statuses ps

784:
785:
786: declare
787: cursor p1 is select project_system_status_code
788: from pa_project_statuses ps
789: where project_status_code = x_project_status_code;
790:
791: cursor p2 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code
792: from pa_project_statuses ps, pa_projects pp

Line 792: from pa_project_statuses ps, pa_projects pp

788: from pa_project_statuses ps
789: where project_status_code = x_project_status_code;
790:
791: cursor p2 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code
792: from pa_project_statuses ps, pa_projects pp
793: where ps.project_status_code = pp.project_status_code
794: and pp.project_id = x_orig_project_id;
795:
796: cursor p3 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code

Line 797: from pa_project_statuses ps, pa_project_types pt, pa_projects pp

793: where ps.project_status_code = pp.project_status_code
794: and pp.project_id = x_orig_project_id;
795:
796: cursor p3 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code
797: from pa_project_statuses ps, pa_project_types pt, pa_projects pp
798: where ps.project_status_code = pt.def_start_proj_status_code
799: and pt.project_type = pp.project_type
800: and pp.project_id = x_orig_project_id;
801: