How to Default a DFF Segment value based on value in another segment

Summary:

We are trying to default value of segment "Reporting Category (Attribute 6)" based on segment "Service Name (Attribute 1)" for DFF PJF_TASK_STRUCTURE_DFF using SQL defaulting method. It is not working.

Content (required):

Sample Query

Select Tag --It is the value we want to default

from FND_LOOKUP_VALUES

where Lookup_Type ='TEI_SERVICENAME_REPORTSEGMENT' -- Lookup for DFF "Service Name"

and Language ='US' and MEANING = 'Training Onsite' -- For now we are trying hardcoded value to do POC. Later we will like

-- to use :PARAMETER.Service Name

Version (include the version you are using, if applicable):

22A