We have a dff on assignment and we want it to default it to yes or no checking the bargaining unit
Summary:
Hi Team,
We have a dff on assignment and we want it to default it to yes or no checking the bargaining unit (a seeded field),
if we have bargaining unit as 01 - Salaried then dff value should be yes other wise no
We have chosen initial default
default type - sql
derviation value - BARGAINING_UNIT_CODE
default value-
SELECT CASE
WHEN FLV.MEANING = '01 - SALARIED' THEN 'Yes'
ELSE 'No'
END
FROM FND_LOOKUP_VALUES FLV,
PER_ASSIGNMENT_SECURED_LIST_V PAAF
WHERE FLV.LOOKUP_TYPE = 'BARGAINING_UNIT_CODE'
AND FLV.LOOKUP_CODE(+) = PAAF.BARGAINING_UNIT_CODE
Tagged:
0