APPS.PA_PROJECT_SET_UTILS dependencies on PA_PROJECT_SETS_VL

Line 400: FROM pa_project_sets_vl

396: l_enable_log varchar2(1) := NVL(FND_PROFILE.value('PA_DEBUG_MODE'), 'N');
397:
398: CURSOR p_ids IS
399: SELECT project_set_id
400: FROM pa_project_sets_vl
401: WHERE upper(name) = upper(p_project_set_name);
402: BEGIN
403:
404: if (p_project_set_id = FND_API.G_MISS_NUM) OR (p_project_set_id is NULL) then

Line 408: FROM pa_project_sets_vl

404: if (p_project_set_id = FND_API.G_MISS_NUM) OR (p_project_set_id is NULL) then
405: if (p_project_set_name is not NULL) then
406: SELECT project_set_id
407: INTO x_project_set_id
408: FROM pa_project_sets_vl
409: WHERE upper(name) = upper(p_project_set_name);
410: else
411: x_project_set_id := NULL;
412: end if;

Line 418: FROM pa_project_sets_vl

414: else
415: IF p_check_id_flag = 'Y' THEN
416: SELECT project_set_id
417: INTO x_project_set_id
418: FROM pa_project_sets_vl
419: WHERE project_set_id = p_project_set_id;
420:
421: ELSIF (p_check_id_flag='N') THEN
422: x_project_set_id := p_project_set_id;