APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_PROJECTS_ALL

Line 310: FROM pa_projects_all

306: --bug 1795160: no need to get location from project, location not required.
307: /*
308: SELECT location_id
309: INTO l_assignment_rec.location_id
310: FROM pa_projects_all
311: WHERE project_id = l_assignment_rec.project_id;
312: */
313: --Log Message
314: IF P_DEBUG_MODE = 'Y' THEN /* Added Debug Profile Option Check for bug#2674619 */

Line 602: FROM PA_PROJECTS_ALL

598: begin
599:
600: SELECT proj_asgmt_res_format_id
601: INTO l_proj_asgmt_res_format_id
602: FROM PA_PROJECTS_ALL
603: WHERE project_id = p_assignment_rec.project_id;
604:
605: IF P_DEBUG_MODE = 'Y' THEN
606: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

Line 1535: FROM PA_PROJECTS_ALL

1531: -- because we should use the format on the planning resource
1532: -- on the team role
1533: SELECT proj_asgmt_res_format_id
1534: INTO l_proj_asgmt_res_format_id
1535: FROM PA_PROJECTS_ALL
1536: WHERE project_id = p_assignment_rec.project_id;
1537:
1538:
1539: SELECT person_id