APPS.PA_OPEN_ASSIGNMENT_PVT dependencies on PA_PROJECTS_ALL

Line 94: FROM pa_projects_all

90:
91: CURSOR get_project_info IS
92: SELECT calendar_id, competence_match_wt, availability_match_wt, job_level_match_wt, search_min_availability, search_org_hier_id, search_starting_org_id, search_country_code, min_cand_score_reqd_for_nom, adv_action_set_id, start_adv_action_set_flag,
93: enable_automated_search -- Added for bug 4306049
94: FROM pa_projects_all
95: WHERE project_id = l_assignment_rec.project_id;
96:
97: -- Bottom Up Flow
98: CURSOR get_bu_resource_assignments IS

Line 468: FROM PA_PROJECTS_ALL

464: p_assignment_rec.resource_list_member_id IS NULL) AND
465: p_assignment_rec.project_id <> FND_API.G_MISS_NUM THEN
466: SELECT proj_req_res_format_id
467: INTO l_proj_req_res_format_id
468: FROM PA_PROJECTS_ALL
469: WHERE project_id = p_assignment_rec.project_id;
470:
471: l_fcst_job_id_tmp := l_assignment_rec.fcst_job_id;
472: IF l_fcst_job_id_tmp = FND_API.G_MISS_NUM THEN

Line 578: FROM pa_projects_all

574: --Bug 1795160: no need to get location from project, location not required
575: /*
576: SELECT location_id
577: INTO l_assignment_rec.location_id
578: FROM pa_projects_all
579: WHERE project_id = l_assignment_rec.project_id;
580: */
581: --Log Message
582: IF (P_DEBUG_MODE = 'Y') THEN