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 978: l_proj_status pa_projects_all.project_status_code%TYPE;

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

Line 981: l_proj_start_date pa_projects_all.start_date%TYPE;

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

Line 982: l_proj_end_date pa_projects_all.completion_date%TYPE;

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

Line 996: from pa_projects_all proj

992: ,type.project_type_class_code
993: ,proj.project_type -- Added for bug#5098966
994: ,trunc(proj.start_date)
995: ,trunc(proj.completion_date)
996: from pa_projects_all proj
997: ,pa_project_statuses ps
998: ,pa_project_types type
999: where proj.project_status_code = ps.project_status_code
1000: and proj.project_type = type.project_type

Line 1202: from pa_projects_all proj

1198: /* Changing the query to base tables instaed of pa_projects_v view to improve perfromance. Bug 4940945 */
1199: CURSOR c_prj IS
1200: select ps.project_system_status_code
1201: ,type.project_type_class_code
1202: from pa_projects_all proj
1203: ,pa_project_statuses ps
1204: ,pa_project_types type
1205: where proj.project_status_code = ps.project_status_code
1206: and proj.project_type=type.project_type

Line 1217: l_proj_status pa_projects_all.project_status_code%TYPE;

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