APPS.JA_CN_CFS_DATA_CLT_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 139: l_seg_type FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE;

135: l_cc_id NUMBER := P_CCID;
136: l_csi_check varchar2(2) := P_CASH_RELATED_ITEM;
137: l_tr_csi_check varchar2(150);
138:
139: l_seg_type FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE;
140: l_ffv_flex_value varchar2(150);
141: l_seg_fsav_gcc varchar2(150);
142:
143: l_account_num varchar2(150); --account number of a line's account

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

163: seg_fsav_gcc
164: FROM GL_CODE_COMBINATIONS gcc
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

Line 910: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav

906: , '') distl_cash_related_item
907: FROM FUN_TRX_LINES trl
908: ,FUN_DIST_LINES trldist
909: ,GL_CODE_COMBINATIONS codecmb
910: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
911: --,JA_CN_LEDGER_LE_BSV_GT tmpbsv
912: ,JA_CN_DFF_ASSIGNMENTS dff
913: WHERE trl.line_id=trldist.line_id
914: AND trl.trx_id=trldist.trx_id

Line 1498: FND_SEGMENT_ATTRIBUTE_VALUES FSAV

1494: 'SEGMENT25',GCC.SEGMENT25, 'SEGMENT26',GCC.SEGMENT26, 'SEGMENT27',GCC.SEGMENT27,
1495: 'SEGMENT28',GCC.SEGMENT28, 'SEGMENT29',GCC.SEGMENT29, 'SEGMENT30',GCC.SEGMENT30)
1496: INTO L_BALANCING_SEGMENT
1497: FROM GL_CODE_COMBINATIONS GCC,
1498: FND_SEGMENT_ATTRIBUTE_VALUES FSAV
1499: WHERE GCC.CODE_COMBINATION_ID = P_CC_ID
1500: AND FSAV.ATTRIBUTE_VALUE = 'Y'
1501: AND FSAV.APPLICATION_ID = 101
1502: AND FSAV.SEGMENT_ATTRIBUTE_TYPE = 'GL_BALANCING'