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

Content

Hi Gurus-

Is there a way to default the value of the Work Type field base on the entered Project Number/ID on requisition distribution?

I tried to use SQL default type and use below SQL. However it doesn't work.

Select pwtt.name from pjf_project_all_b ppab, pjf_work_types_tl pwtt where ppab.work_type_id = pwtt.work_type_id  and ppab.project_id = :{PARAMETER.ProjectId}

Any suggestion or inputs if anyone already tried it?

Thanks in advance 

Haydee