DBA Data[Home] [Help]

APPS.IBY_AMOUNT_IN_WORDS dependencies on FND_FLEX_VALUES_TL

Line 2033: V_Description FND_FLEX_VALUES_TL.DESCRIPTION%type;

2029: P_Vset_Name IN VARCHAR2,
2030: P_Vset_Value IN VARCHAR2)
2031: RETURN VARCHAR2
2032: IS
2033: V_Description FND_FLEX_VALUES_TL.DESCRIPTION%type;
2034: BEGIN
2035: SELECT t.DESCRIPTION
2036: INTO V_Description
2037: FROM FND_FLEX_VALUES v,

Line 2039: FND_FLEX_VALUES_TL t

2035: SELECT t.DESCRIPTION
2036: INTO V_Description
2037: FROM FND_FLEX_VALUES v,
2038: FND_FLEX_VALUE_SETS s,
2039: FND_FLEX_VALUES_TL t
2040: WHERE v.FLEX_VALUE_SET_ID = s.FLEX_VALUE_SET_ID
2041: AND t.FLEX_VALUE_ID = v.FLEX_VALUE_ID
2042: AND v.FLEX_VALUE = P_Vset_Value
2043: AND s.FLEX_VALUE_SET_NAME = P_Vset_Name