Default project type value from Cost Collection descriptive flexfield using the value of Project ID

Summary:

I create a new segment under Project Cost Collection DFF (Context: POR Requisition) in order to default the project type by using the following query:

select tl.project_type name from pjf_projects_all_b pb,PJF_PROJECT_TYPES_TL tl
where 1=1
and pb.project_type_id = tl.project_type_id
and tl.language = 'I'
AND PB.PROJECT_ID = :{PARAMETER.ProjectId}

It doesn't work fine. Any suggestion?

The value set XXSOG_TIPO_PROGETTO is defined in this way

(select substr (tl.project_type,150) project_type from pjf_projects_all_b pb,PJF_PROJECT_TYPES_TL tl where pb.project_type_id = tl.project_type_id and tl.language = 'I' )