255: --Get the Detailed cfs item description
256: BEGIN
257: SELECT Ffvt.DESCRIPTION
258: INTO l_detailed_item_desc
259: FROM Fnd_Flex_Values_Tl Ffvt,
260: fnd_flex_values Ffv,
261: ja_cn_cash_valuesets_all Cra
262: WHERE Cra.Chart_Of_Accounts_Id = p_coa_id
263: AND Ffv.Flex_Value_Set_Id = Cra.Flex_Value_Set_Id
256: BEGIN
257: SELECT Ffvt.DESCRIPTION
258: INTO l_detailed_item_desc
259: FROM Fnd_Flex_Values_Tl Ffvt,
260: fnd_flex_values Ffv,
261: ja_cn_cash_valuesets_all Cra
262: WHERE Cra.Chart_Of_Accounts_Id = p_coa_id
263: AND Ffv.Flex_Value_Set_Id = Cra.Flex_Value_Set_Id
264: AND Ffv.Flex_Value_Id = Ffvt.Flex_Value_Id