DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on FND_FLEX_VALUES

Line 158: --Cursor to get FND_FLEX_VALUES.Flex_Value and segment FND_SEGMENT_ATTRIBUTE_VALUES.APPLICATION_COLUMN_NAME of gcc

154: l_com_seg_check number; --flag of an account's company segment belongs to current LE or not
155: l_account_check number; --flag of an account in cash related table or not
156: l_line_check varchar2(1); --result of a line's validation
157:
158: --Cursor to get FND_FLEX_VALUES.Flex_Value and segment FND_SEGMENT_ATTRIBUTE_VALUES.APPLICATION_COLUMN_NAME of gcc
159: CURSOR c_ffv IS
160: SELECT FFV.Flex_Value ffv_flex_value
161: ,DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
162: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,

Line 178: ,FND_FLEX_VALUES FFV

174: ,GL_LEDGERS ledger
175: ,FND_ID_FLEX_SEGMENTS FIFS
176: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
177: ,FND_FLEX_VALUE_SETS FFVS
178: ,FND_FLEX_VALUES FFV
179: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
180: AND gcc.chart_of_accounts_id = l_coa_id --using variable P_COA_ID
181: AND ledger.chart_of_accounts_id = ledger.chart_of_accounts_id
182: AND ledger.ledger_id = l_ledger_id --using variable l_sob_id