[Home] [Help]
128: l_line_num VARCHAR2(20) := P_LINE_NUM;
129: l_cc_id NUMBER := P_CCID;
130: l_csi_check varchar2(2) := P_CASH_RELATED_ITEM;
131:
132: l_seg_type FND_SEGMENT_ATTRIBUTE_VALUES.SEGMENT_ATTRIBUTE_TYPE%TYPE;
133: l_ffv_flex_value varchar2(150);
134: l_seg_fsav_gcc varchar2(150);
135:
136: l_account_num varchar2(150); --account number of a line's account
157: seg_fsav_gcc
158: FROM GL_CODE_COMBINATIONS gcc
159: ,GL_LEDGERS ledger
160: ,FND_ID_FLEX_SEGMENTS FIFS
161: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
162: ,FND_FLEX_VALUE_SETS FFVS
163: ,FND_FLEX_VALUES FFV
164: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
165: AND ledger.chart_of_accounts_id = gcc.chart_of_accounts_id
458: ||' BULK COLLECT INTO :1'
459: ||' FROM GL_CODE_COMBINATIONS gcc'
460: ||' ,GL_SETS_OF_BOOKS sob'
461: ||' ,FND_ID_FLEX_SEGMENTS FIFS'
462: ||' ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV'
463: ||' ,FND_FLEX_VALUE_SETS FFVS'
464: ||' ,FND_FLEX_VALUES FFV'
465: ||' ,FND_FLEX_VALUES_TL FFVT'
466: ||' WHERE gcc.code_combination_id = :2' --using variable l_cc_id
492: BULK COLLECT INTO l_all_acc_seg
493: FROM GL_CODE_COMBINATIONS gcc
494: ,GL_LEDGERS ledger
495: ,FND_ID_FLEX_SEGMENTS FIFS
496: ,FND_SEGMENT_ATTRIBUTE_VALUES FSAV
497: ,FND_FLEX_VALUE_SETS FFVS
498: ,FND_FLEX_VALUES FFV
499: ,FND_FLEX_VALUES_TL FFVT
500: WHERE gcc.code_combination_id = l_cc_id --using variable l_cc_id
789: ) cash_related_item
790: FROM GL_JE_LINES jel
791: ,ja_cn_dff_assignments dffa
792: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
793: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
794: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
795: -- to locate cash flow item in dff_assignment
796: AND dffa.Application_Id = 101
797: AND dffa.chart_of_accounts_id = l_coa_id --using variable l_coa_id
828: ,jel.code_combination_id account_ccid
829: ,jel.global_attribute6 cash_related_item
830: FROM GL_JE_LINES jel
831: ,GL_CODE_COMBINATIONS codecmb --Added for CNAO Enhancement
832: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
833: WHERE jel.je_header_id = l_je_header_id --using variable l_je_header_id
834: AND codecmb.code_combination_id = jel.code_combination_id
835: AND fsav.application_id = 101
836: AND fsav.id_flex_num = l_coa_id
1520: , '') trxh_cash_related_item
1521: FROM FUN_TRX_LINES trl
1522: ,FUN_DIST_LINES trldist
1523: ,GL_CODE_COMBINATIONS codecmb
1524: ,FND_SEGMENT_ATTRIBUTE_VALUES fsav
1525: ,JA_CN_DFF_ASSIGNMENTS dff
1526: WHERE trl.line_id=trldist.line_id
1527: AND trl.trx_id=trldist.trx_id
1528: AND trldist.ccid=codecmb.code_combination_id