APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECT_TYPES

Line 976: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

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

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

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

Line 995: ,pa_project_types type

991: ,proj.start_date
992: ,proj.completion_date
993: from pa_projects_all proj
994: ,pa_project_statuses ps
995: ,pa_project_types type
996: where proj.project_status_code = ps.project_status_code
997: and proj.project_type = type.project_type
998: and proj.project_id = p_project_id
999: and ps.STATUS_TYPE = 'PROJECT';

Line 1190: ,pa_project_types type

1186: select ps.project_system_status_code
1187: ,type.project_type_class_code
1188: from pa_projects_all proj
1189: ,pa_project_statuses ps
1190: ,pa_project_types type
1191: where proj.project_status_code = ps.project_status_code
1192: and proj.project_type=type.project_type
1193: and proj.project_id = p_project_id
1194: and ps.STATUS_TYPE ='PROJECT';

Line 1204: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;

1200: where project_id = p_project_id
1201: and project_role_id = 1;
1202:
1203: l_proj_status pa_projects_all.project_status_code%TYPE;
1204: l_proj_type_class pa_project_types_all.project_type_class_code%TYPE;
1205: l_prj_mgr_count NUMBER := 0;
1206: l_start_no_mgr_date DATE;
1207: l_end_no_mgr_date DATE;
1208: