APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 148: l_seg_type FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE;

144: l_cc_id NUMBER := P_CCID;
145: l_csi_check varchar2(2) := P_CASH_RELATED_ITEM;
146: l_tr_csi_check varchar2(150);
147:
148: l_seg_type FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE;
149: l_ffv_flex_value varchar2(150);
150: l_seg_fsav_gcc varchar2(150);
151:
152: l_account_num varchar2(150); --account number of a line's account

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 176: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV

172: seg_fsav_gcc
173: FROM GL_CODE_COMBINATIONS gcc
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

Line 930: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav

926: , '') distl_cash_related_item
927: FROM FUN_TRX_LINES trl
928: ,FUN_DIST_LINES trldist
929: ,GL_CODE_COMBINATIONS codecmb
930: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
931: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
932: ,JA_CN_DFF_ASSIGNMENTS dff
933: ,xle_entity_profiles xep -- Added for fixing bug# 8744259 by Chaoqun on 30-Jul-2009
934: WHERE trl.line_id=trldist.line_id

Line 1549: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

1545: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
1546: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
1547: INTO L_BALANCING_SEGMENT
1548: FROM GL_CODE_COMBINATIONS GCC,
1549: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1550: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
1551: AND FSAV.ATTRIBUTE_VALUE = 'Y'
1552: AND FSAV.APPLICATION_ID = 101
1553: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'