[Home] [Help]
355: SELECT Ffvt.DESCRIPTION
356: INTO l_detailed_item_desc
357: FROM Fnd_Flex_Values_Tl Ffvt,
358: fnd_flex_values Ffv,
359: ja_cn_cash_valuesets_all Cra
360: WHERE Cra.Chart_Of_Accounts_Id = p_coa_id
361: AND Ffv.Flex_Value_Set_Id = Cra.Flex_Value_Set_Id
362: AND Ffv.Flex_Value_Id = Ffvt.Flex_Value_Id
363: AND ffvt.flex_value_meaning = p_detailed_cfs_item