APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_TYPES_ALL

Line 979: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

975: x_end_no_mgr_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
976: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
977: l_error_occured VARCHAR2(50);
978: l_proj_status pa_projects_all.project_status_code%TYPE;
979: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
980: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
981: l_proj_start_date pa_projects_all.start_date%TYPE;
982: l_proj_end_date pa_projects_all.completion_date%TYPE;
983: l_person_id pa_project_players.person_id%TYPE;

Line 980: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966

976: x_error_occured OUT NOCOPY VARCHAR2) IS --File.Sql.39 bug 4440895
977: l_error_occured VARCHAR2(50);
978: l_proj_status pa_projects_all.project_status_code%TYPE;
979: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
980: l_proj_type pa_project_types_all.project_type%TYPE; -- Added for bug#5098966
981: l_proj_start_date pa_projects_all.start_date%TYPE;
982: l_proj_end_date pa_projects_all.completion_date%TYPE;
983: l_person_id pa_project_players.person_id%TYPE;
984: l_party_id pa_project_parties.project_party_id%TYPE;

Line 1218: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

1214: where project_id = p_project_id
1215: and project_role_id = 1;
1216:
1217: l_proj_status pa_projects_all.project_status_code%TYPE;
1218: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
1219: l_prj_mgr_count NUMBER := 0;
1220: l_start_no_mgr_date DATE;
1221: l_end_no_mgr_date DATE;
1222: