[Home] [Help]
87: l_attribute_column4is_foreign ja_cn_dff_assignments.attribute_column%TYPE;
88: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
89: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;
90: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
91: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
92: l_account_balances_gbl_tmp_row ja_cn_account_balances_gt%ROWTYPE;
93: l_sql_stmt VARCHAR2(30000) := '';
94:
95: l_sql_stmt4insert_j_line VARCHAR2(30000) := 'INSERT INTO ja_cn_account_balances_gt
173: FROM ja_cn_ledger_le_bsv_gt
174: WHERE legal_entity_id = :5)
175: GROUP BY account_segment,@CURRENCY_CLAUSE2 period_mon,account_type,PERIOD_NAME @COLUMN_CLAUSE) ' ||
176: prefix_a ||
177: ' LEFT JOIN ja_cn_subsidiary_gt s ON ' ||
178: prefix_a ||
179: '.account_segment =s.account_segment_value left join fnd_currencies_vl ' ||
180: prefix_b || ' ON ' || prefix_a ||
181: '.currency_code=' || prefix_b ||
238: (end_date BETWEEN l_start_date AND l_end_date)))
239: AND ledger_id = p_ledger_id;--set_of_books_id = l_set_of_books_id;
240:
241: CURSOR c_in_ja_cn_subsidiary_gbl_tmp IS
242: SELECT * FROM ja_cn_subsidiary_gt;
243:
244: CURSOR c_in_account_balances_gbl_tmp IS
245: SELECT *
246: FROM ja_cn_account_balances_gt
467: l_module_name,
468: 'Fetched account segments start below:');
469:
470: END IF; --l_statement_level >= l_runtime_level
471: l_sql_stmt := 'insert into JA_CN_SUBSIDIARY_GT
472: (
473: ACCOUNT_SEGMENT_VALUE,
474: HAS_THIRD_PARTY,
475: HAS_COST_CENTER,