APPS.JA_CN_GL_INTER_VALID_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 130: l_seg_type FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE;

126: l_line_num VARCHAR2(20) := P_LINE_NUM;
127: l_cc_id NUMBER := P_CCID;
128: l_csi_check varchar2(2) := P_CASH_RELATED_ITEM;
129:
130: l_seg_type FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE;
131: l_ffv_flex_value varchar2(150);
132: l_seg_fsav_gcc varchar2(150);
133:
134: l_account_num varchar2(150); --account number of a line's account

Line 159: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV

155: seg_fsav_gcc
156: FROM GL_CODE_COMBINATIONS gcc
157: ,GL_LEDGERS ledger
158: ,FND_ID_FLEX_SEGMENTS FIFS
159: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
160: ,FND_FLEX_VALUE_SETS FFVS
161: ,FND_FLEX_VALUES FFV
162: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
163: AND ledger.chart_of_accounts_id = gcc.chart_of_accounts_id

Line 458: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV'

454: ||' BULK COLLECT INTO :1'
455: ||' FROM GL_CODE_COMBINATIONS gcc'
456: ||' ,GL_SETS_OF_BOOKS sob'
457: ||' ,FND_ID_FLEX_SEGMENTS FIFS'
458: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV'
459: ||' ,FND_FLEX_VALUE_SETS FFVS'
460: ||' ,FND_FLEX_VALUES FFV'
461: ||' ,FND_FLEX_VALUES_TL FFVT'
462: ||' WHERE gcc.code_combination_id = :2' --using variable l_cc_id

Line 492: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV

488: BULK COLLECT INTO l_all_acc_seg
489: FROM GL_CODE_COMBINATIONS gcc
490: ,GL_LEDGERS ledger
491: ,FND_ID_FLEX_SEGMENTS FIFS
492: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
493: ,FND_FLEX_VALUE_SETS FFVS
494: ,FND_FLEX_VALUES FFV
495: ,FND_FLEX_VALUES_TL FFVT
496: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id

Line 786: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav

782: ) cash_related_item
783: FROM GL_JE_LINES jel
784: ,ja_cn_dff_assignments dffa
785: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
786: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
787: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
788: -- to locate cash flow item in dff_assignment
789: AND dffa.Application_Id = 101
790: AND dffa.chart_of_accounts_id = l_coa_id --using variable l_coa_id

Line 1487: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav

1483: , '') trxh_cash_related_item
1484: FROM FUN_TRX_LINES trl
1485: ,FUN_DIST_LINES trldist
1486: ,GL_CODE_COMBINATIONS codecmb
1487: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1488: ,JA_CN_DFF_ASSIGNMENTS dff
1489: WHERE trl.line_id=trldist.line_id
1490: AND trl.trx_id=trldist.trx_id
1491: AND trldist.ccid=codecmb.code_combination_id