Setting Default Value to DFF using SQL is not working

Summary:

I am trying to set a default value to a DFF in Contracts Line page based on Contract Line Type but the default value is not working.

I have done the below

1) Defined Contracts and Contract Line Type = Default Line Type

2) Created a Lookup with a lookup value = Default Line Type

3) Created DFF Attribute in Contract Lines to default value based on below SQL

SELECT TAG FROM FND_LOOKUP_VALUES

WHERE LOOKUP_TYPE = 'XX_CONTRACT_LINE_REV_ACCT'

AND ENABLED_FLAG = 'Y'

AND MEANING = :{PARAMETER.LineTypeCode}

4) When I create a contract line with this value, it is not defaulting the expected value