APPS.PA_PROJECT_CORE1 dependencies on PA_PROJECT_TYPES

Line 777: FROM pa_project_types

773: DECLARE
774: CURSOR cur_pa_proj_type
775: IS
776: SELECT 'X'
777: FROM pa_project_types
778: WHERE project_type = l_project_type
779: AND org_project_flag = 'Y';
780:
781: l_dummy_char VARCHAR2(1);

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: