APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_STATUSES

Line 428: pa_project_statuses pps

424: ppa.funding_approval_status_code,
425: pps.project_system_status_code
426: from
427: pa_projects_all ppa,
428: pa_project_statuses pps
429: where
430: ppa.project_id = x_orig_project_id
431: and ppa.funding_approval_status_code = pps.project_status_code;
432:

Line 800: from pa_project_statuses ps

796:
797:
798: declare
799: cursor p1 is select project_system_status_code
800: from pa_project_statuses ps
801: where project_status_code = x_project_status_code;
802:
803: cursor p2 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code
804: from pa_project_statuses ps, pa_projects pp

Line 804: from pa_project_statuses ps, pa_projects pp

800: from pa_project_statuses ps
801: where project_status_code = x_project_status_code;
802:
803: cursor p2 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code
804: from pa_project_statuses ps, pa_projects pp
805: where ps.project_status_code = pp.project_status_code
806: and pp.project_id = x_orig_project_id;
807:
808: cursor p3 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code

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

805: where ps.project_status_code = pp.project_status_code
806: and pp.project_id = x_orig_project_id;
807:
808: cursor p3 is select ps.project_system_status_code, ps.starting_status_flag, ps.project_status_code
809: from pa_project_statuses ps, pa_project_types pt, pa_projects pp
810: where ps.project_status_code = pt.def_start_proj_status_code
811: and pt.project_type = pp.project_type
812: and pp.project_id = x_orig_project_id;
813: