APPS.PA_PROJECT_PARTIES_UTILS dependencies on PA_PROJECTS_ALL

Line 39: from pa_projects_all

35: /* Bug 2636791 - changes begin */
36: /* Commenting this query and selecting start date from PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE */
37: /* select start_date, completion_date
38: into x_project_start_date, x_project_end_date
39: from pa_projects_all
40: where project_id = p_project_id; */
41:
42: SELECT PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(p_project_id), completion_date
43: INTO x_project_start_date, x_project_end_date

Line 44: FROM pa_projects_all

40: where project_id = p_project_id; */
41:
42: SELECT PA_PROJECT_DATES_UTILS.GET_PROJECT_START_DATE(p_project_id), completion_date
43: INTO x_project_start_date, x_project_end_date
44: FROM pa_projects_all
45: WHERE project_id = p_project_id;
46:
47: /* Bug 2636791 - changes end */
48:

Line 975: l_proj_status pa_projects_all.project_status_code%TYPE;

971: x_start_no_mgr_date OUT NOCOPY DATE, --File.Sql.39 bug 4440895
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;

Line 978: l_proj_start_date pa_projects_all.start_date%TYPE;

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;
982: l_start_date pa_project_players.start_date_active%TYPE;

Line 979: l_proj_end_date pa_projects_all.completion_date%TYPE;

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;
982: l_start_date pa_project_players.start_date_active%TYPE;
983: l_end_date pa_project_players.end_date_active%TYPE;

Line 993: from pa_projects_all proj

989: ,type.project_type_class_code
990: ,proj.project_type -- Added for bug#5098966
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

Line 1188: from pa_projects_all proj

1184: /* Changing the query to base tables instaed of pa_projects_v view to improve perfromance. Bug 4940945 */
1185: CURSOR c_prj IS
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

Line 1203: l_proj_status pa_projects_all.project_status_code%TYPE;

1199: from pa_project_parties
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;