353: --Get the Detailed cfs item description
354: BEGIN
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
354: BEGIN
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