APPS.JA_CN_CFS_IMA_PKG dependencies on FND_FLEX_VALUES

Line 80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;

76: l_org_id ja_cn_cfs_item_mapping_lines.org_id%type;
77: l_org_name hr_all_organization_units_tl.name%type;
78: l_ac_value ja_cn_cfs_item_mapping_lines.ac_value%type;
79: l_detailed_cfs_item ja_cn_cfs_item_mapping_lines.detailed_cfs_item%type;
80: l_cash_flow_item_desc Fnd_Flex_Values_Tl.Description%type;
81: l_effective_start_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_Start_Date%type;
82: l_effective_end_date Ja_Cn_Cfs_Item_Mapping_lines.Effective_End_Date%type;
83:
84: l_varchar_test varchar2(4000);

Line 144: FROM Fnd_Flex_Values_Tl Ffvt,Ja_Cn_Cfs_Item_Mapping_Lines JCCIM

140:
141: --get cash flow item description
142: /* CURSOR c_cash_flow_item_desc is
143: SELECT Ffvt.Description DESCRIPTION
144: FROM Fnd_Flex_Values_Tl Ffvt,Ja_Cn_Cfs_Item_Mapping_Lines JCCIM
145: WHERE Ffvt.Flex_Value_Meaning=JCCIM.DETAILED_CFS_ITEM
146: AND JCCIM.MAPPING_HEADER_ID=l_Mapping_Header_Id
147: and JCCIM.DETAILED_CFS_ITEM=l_detailed_cfs_item
148: and Ffvt.LANGUAGE = USERENV('LANG');*/

Line 153: ,FND_FLEX_VALUES_TL FFVT

149:
150: CURSOR c_cash_flow_item_desc IS --Fixed bug# 7373268
151: SELECT DISTINCT FFVT.DESCRIPTION DESCRIPTION
152: FROM FND_FLEX_VALUE_SETS FFVS
153: ,FND_FLEX_VALUES_TL FFVT
154: ,FND_FLEX_VALUES FFV
155: ,Ja_Cn_Cfs_Item_Mapping_Lines JCCIML
156: ,JA_CN_CASH_VALUESETS_ALL JCCVA
157: WHERE FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID

Line 154: ,FND_FLEX_VALUES FFV

150: CURSOR c_cash_flow_item_desc IS --Fixed bug# 7373268
151: SELECT DISTINCT FFVT.DESCRIPTION DESCRIPTION
152: FROM FND_FLEX_VALUE_SETS FFVS
153: ,FND_FLEX_VALUES_TL FFVT
154: ,FND_FLEX_VALUES FFV
155: ,Ja_Cn_Cfs_Item_Mapping_Lines JCCIML
156: ,JA_CN_CASH_VALUESETS_ALL JCCVA
157: WHERE FFVS.FLEX_VALUE_SET_ID = FFV.FLEX_VALUE_SET_ID
158: AND JCCVA.CHART_OF_ACCOUNTS_ID = l_Chart_Of_Accounts_Id