APPS.PA_TEAM_TEMPLATES_PVT dependencies on PA_PROJECT_ASSIGNMENTS

Line 365: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;

361: ,x_return_status OUT NOCOPY VARCHAR2 --File.Sql.39 bug 4440895
362: )
363: IS
364:
365: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
366: l_assignment_number pa_project_assignments.assignment_number%TYPE;
367: l_assignment_row_id ROWID;
368: l_resource_id pa_resources.resource_id%TYPE;
369: l_return_status VARCHAR2(1);

Line 366: l_assignment_number pa_project_assignments.assignment_number%TYPE;

362: )
363: IS
364:
365: l_new_assignment_id pa_project_assignments.assignment_id%TYPE;
366: l_assignment_number pa_project_assignments.assignment_number%TYPE;
367: l_assignment_row_id ROWID;
368: l_resource_id pa_resources.resource_id%TYPE;
369: l_return_status VARCHAR2(1);
370: l_error_message_code fnd_new_messages.message_name%TYPE;

Line 433: FROM pa_project_assignments

429: ,attribute12
430: ,attribute13
431: ,attribute14
432: ,attribute15
433: FROM pa_project_assignments
434: WHERE assignment_template_id = p_team_template_id
435: AND template_flag = 'Y';
436:
437: CURSOR get_team_template_subteams(p_team_template_id NUMBER) IS

Line 936: FROM pa_project_assignments

932: l_check_team_template_in_use VARCHAR2(1);
933:
934: CURSOR check_team_template_in_use IS
935: SELECT 'X'
936: FROM pa_project_assignments
937: WHERE assignment_template_id = p_team_template_id
938: AND template_flag <> 'Y';
939:
940: CURSOR get_template_req_details IS

Line 944: FROM pa_project_assignments

940: CURSOR get_template_req_details IS
941: SELECT assignment_id,
942: record_version_number,
943: assignment_type
944: FROM pa_project_assignments
945: WHERE assignment_template_id = p_team_template_id
946: AND template_flag = 'Y';
947:
948: BEGIN