APPS.PA_PROJECT_SUBTEAM_UTILS dependencies on PA_PROJECT_SUBTEAMS

Line 30: FROM pa_project_subteams

26: IF (x_subteam_id IS NOT NULL) then
27: If (x_subteam_id >0 AND p_check_id_flag = 'Y') THEN
28: SELECT project_subteam_id
29: INTO x_subteam_id
30: FROM pa_project_subteams
31: WHERE project_subteam_id = x_subteam_id
32: AND object_type = decode(p_object_type, FND_API.G_MISS_CHAR, object_type, null, object_type, p_object_type) -- 5130421
33: AND object_id = decode(p_object_id, FND_API.G_MISS_NUM, object_id, null, object_id, p_object_id) -- 5130421
34: ;

Line 45: FROM pa_project_subteams

41: else
42: --Find the Id for the name
43: SELECT project_subteam_id
44: INTO x_subteam_id
45: FROM pa_project_subteams
46: WHERE name = p_subteam_name
47: AND object_type = p_object_type
48: AND object_id = p_object_id;
49: end if;

Line 55: FROM pa_project_subteams

51: ELSE
52: if (p_subteam_name is not null) then
53: SELECT project_subteam_id
54: INTO x_subteam_id
55: FROM pa_project_subteams
56: WHERE name = p_subteam_name
57: AND object_type = p_object_type
58: AND object_id = p_object_id;
59: else