APPS.PA_STAFFED_ASSIGNMENT_PVT dependencies on PA_PROJECTS_ALL

Line 311: FROM pa_projects_all

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

Line 633: FROM PA_PROJECTS_ALL

629: begin
630:
631: SELECT proj_asgmt_res_format_id
632: INTO l_proj_asgmt_res_format_id
633: FROM PA_PROJECTS_ALL
634: WHERE project_id = p_assignment_rec.project_id;
635:
636: IF P_DEBUG_MODE = 'Y' THEN
637: pa_debug.write(x_module => 'pa.plsql.PA_STAFFED_ASSIGNMENT_PVT.Create_Staffed_Assignment'

Line 1566: FROM PA_PROJECTS_ALL

1562: -- because we should use the format on the planning resource
1563: -- on the team role
1564: SELECT proj_asgmt_res_format_id
1565: INTO l_proj_asgmt_res_format_id
1566: FROM PA_PROJECTS_ALL
1567: WHERE project_id = p_assignment_rec.project_id;
1568:
1569:
1570: SELECT person_id