DBA Data[Home] [Help]

APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on FND_FLEX_VALUES

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

145: l_com_seg_check number; --flag of an account's company segment belongs to current LE or not
146: l_account_check number; --flag of an account in cash related table or not
147: l_line_check varchar2(1); --result of a line's validation
148:
149: --Cursor to get FND_FLEX_VALUES.Flex_Value and segment FND_SEGMENT_ATTRIBUTE_VALUES.APPLICATION_COLUMN_NAME of gcc
150: CURSOR c_ffv IS
151: SELECT FFV.Flex_Value ffv_flex_value
152: ,DECODE(FSAV.APPLICATION_COLUMN_NAME, --segment FSAV.APPLICATION_COLUMN_NAME of gcc
153: 'SEGMENT1',GCC.SEGMENT1, 'SEGMENT2',GCC.SEGMENT2, 'SEGMENT3',GCC.SEGMENT3,

Line 169: ,FND_FLEX_VALUES FFV

165: ,GL_LEDGERS ledger
166: ,FND_ID_FLEX_SEGMENTS FIFS
167: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
168: ,FND_FLEX_VALUE_SETS FFVS
169: ,FND_FLEX_VALUES FFV
170: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
171: AND gcc.chart_of_accounts_id = l_coa_id --using variable P_COA_ID
172: AND ledger.chart_of_accounts_id = ledger.chart_of_accounts_id
173: AND ledger.ledger_id = l_ledger_id --using variable l_sob_id