APPS.PA_MASS_ASGMT_TRX dependencies on PA_PROJECT_SUBTEAMS

Line 17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM

13: ,p_staffing_priority_code IN pa_project_assignments.staffing_priority_code%TYPE := FND_API.G_MISS_CHAR
14: ,p_project_id IN pa_project_assignments.project_id%TYPE := FND_API.G_MISS_NUM
15: ,p_project_role_id IN pa_project_assignments.project_role_id%TYPE := FND_API.G_MISS_NUM
16: ,p_role_list_id IN pa_role_lists.role_list_id%TYPE := FND_API.G_MISS_NUM
17: ,p_project_subteam_id IN pa_project_subteams.project_subteam_id%TYPE := FND_API.G_MISS_NUM
18: ,p_description IN pa_project_assignments.description%TYPE := FND_API.G_MISS_CHAR
19: ,p_append_description_flag IN VARCHAR2 := 'N'
20: ,p_start_date IN pa_project_assignments.start_date%TYPE := FND_API.G_MISS_DATE
21: ,p_end_date IN pa_project_assignments.end_date%TYPE := FND_API.G_MISS_DATE

Line 34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR

30: ,p_calendar_id IN pa_project_assignments.calendar_id%TYPE := FND_API.G_MISS_NUM
31: ,p_resource_calendar_percent IN pa_project_assignments.resource_calendar_percent%TYPE := FND_API.G_MISS_NUM
32: ,p_project_name IN pa_projects_all.name%TYPE := FND_API.G_MISS_CHAR
33: ,p_project_number IN pa_projects_all.segment1%TYPE := FND_API.G_MISS_CHAR
34: ,p_project_subteam_name IN pa_project_subteams.name%TYPE := FND_API.G_MISS_CHAR
35: ,p_project_status_name IN pa_project_statuses.project_status_name%TYPE := FND_API.G_MISS_CHAR
36: ,p_staffing_priority_name IN pa_lookups.meaning%TYPE := FND_API.G_MISS_CHAR
37: ,p_project_role_name IN pa_project_role_types.meaning%TYPE := FND_API.G_MISS_CHAR
38: ,p_location_city IN pa_locations.city%TYPE := FND_API.G_MISS_CHAR

Line 1242: l_project_subteam_name pa_project_subteams.name%TYPE;

1238: l_calendar_id NUMBER;
1239: l_resource_calendar_percent pa_project_assignments.resource_calendar_percent%TYPE;
1240: l_project_name pa_projects_all.name%TYPE;
1241: l_project_number pa_projects_all.segment1%TYPE;
1242: l_project_subteam_name pa_project_subteams.name%TYPE;
1243: l_project_status_name pa_project_statuses.project_status_name%TYPE;
1244: l_staffing_priority_name pa_lookups.meaning%TYPE;
1245: l_project_role_name pa_project_role_types.meaning%TYPE;
1246: l_location_city pa_locations.city%TYPE;

Line 1476: FROM pa_project_subteams

1472: --get the name as we will only have the code as the field is a poplist on the page
1473: IF l_project_subteam_id <> FND_API.G_MISS_NUM and l_project_subteam_id IS NOT NULL THEN
1474: IF l_project_subteam_name = FND_API.G_MISS_CHAR OR l_project_subteam_name IS NULL THEN
1475: SELECT name INTO l_project_subteam_name
1476: FROM pa_project_subteams
1477: WHERE project_subteam_id = l_project_subteam_id;
1478: END IF;
1479: x_document := x_document||get_translated_attr_name('PROJECT_SUBTEAM_NAME')||' - '||l_project_subteam_name||'
';
1480: END IF;