3493:
3494: SELECT pa.segment1,
3495: hou.name
3496: INTO l_emp_pr_data
3497: FROM PA_PROJECTS_ALL pa,
3498: HR_ORGANIZATION_UNITS hou
3499: WHERE pa.project_id = p_projectId
3500: AND hou.organization_id = pa.carrying_out_organization_id;
3501:
5797: BEGIN
5798:
5799: SELECT name
5800: INTO l_project_name
5801: FROM pa_projects_all
5802: WHERE project_id = p_project_id;
5803:
5804: RETURN(l_project_name);
5805: