APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_TYPES

Line 765: FROM pa_project_types

761: DECLARE
762: CURSOR cur_pa_proj_type
763: IS
764: SELECT 'X'
765: FROM pa_project_types
766: WHERE project_type = l_project_type
767: AND org_project_flag = 'Y';
768:
769: l_dummy_char VARCHAR2(1);

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: