DBA Data[Home] [Help]

APPS.JA_CN_CFS_CLT_SLA_PKG dependencies on FND_FLEX_VALUES

Line 357: FROM Fnd_Flex_Values_Tl Ffvt,

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

Line 358: fnd_flex_values Ffv,

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