APPS.JA_CN_APAB_EXPORT_PKG dependencies on JA_CN_SUBSIDIARY_GT

Line 85: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;

81: l_context_code ja_cn_dff_assignments.context_code%TYPE;
82: l_attribute_column4balanceside ja_cn_dff_assignments.attribute_column%TYPE;
83: l_attribute_column4account_lev ja_cn_dff_assignments.attribute_column%TYPE;
84: l_account_segment ja_cn_journal_lines.account_segment%TYPE;
85: l_ja_cn_subsidiary_gbl_tmp_row ja_cn_subsidiary_gt%ROWTYPE;
86: ln_row_count NUMBER := 0;
87:
88: lv_sql_stmt VARCHAR2(30000) := '';
89: lv_sql_stmt4insert_j_line VARCHAR2(30000) := 'INSERT INTO ja_cn_account_balances_gt

Line 193: ' LEFT JOIN ja_cn_subsidiary_gt s ON ' ||

189: segment16,segment17,segment18,segment19,segment20,
190: segment21,segment22,segment23,segment24,segment25,
191: segment26,segment27,segment28,segment29,segment30) ' ||
192: prefix_a ||
193: ' LEFT JOIN ja_cn_subsidiary_gt s ON ' ||
194: prefix_a ||
195: '.account_segment =s.account_segment_value)';
196:
197: ld_start_date DATE;

Line 232: SELECT * FROM ja_cn_subsidiary_gt;

228: AND ledger_id = pn_ledger_id;
229:
230: CURSOR c_in_ja_cn_subsidiary_gbl_tmp
231: IS
232: SELECT * FROM ja_cn_subsidiary_gt;
233:
234: CURSOR c_in_closed_periods
235: IS
236: SELECT period_name

Line 397: --Clear the JA_CN_SUBSIDIARY_GT temporary table as the Accounting

393: '.variable:' ||
394: 'l_attribute_column4balanceside=' || l_attribute_column4balanceside || ',' ||
395: 'l_attribute_column4account_lev=' || l_attribute_column4account_lev);
396:
397: --Clear the JA_CN_SUBSIDIARY_GT temporary table as the Accounting
398: --Balance already inserted data
399: DELETE FROM JA_CN_SUBSIDIARY_GT;
400: COMMIT;
401:

Line 399: DELETE FROM JA_CN_SUBSIDIARY_GT;

395: 'l_attribute_column4account_lev=' || l_attribute_column4account_lev);
396:
397: --Clear the JA_CN_SUBSIDIARY_GT temporary table as the Accounting
398: --Balance already inserted data
399: DELETE FROM JA_CN_SUBSIDIARY_GT;
400: COMMIT;
401:
402: --Fetch the account subsidiary info for each account and save JA_CN_SUBSIDIARY_GT
403: OPEN c_in_ja_cn_account_balances;

Line 402: --Fetch the account subsidiary info for each account and save JA_CN_SUBSIDIARY_GT

398: --Balance already inserted data
399: DELETE FROM JA_CN_SUBSIDIARY_GT;
400: COMMIT;
401:
402: --Fetch the account subsidiary info for each account and save JA_CN_SUBSIDIARY_GT
403: OPEN c_in_ja_cn_account_balances;
404: --log
405: IF (ln_statement_level >= ln_dbg_level) THEN
406: FND_LOG.STRING(ln_statement_level,

Line 410: lv_sql_stmt := 'insert into JA_CN_SUBSIDIARY_GT

406: FND_LOG.STRING(ln_statement_level,
407: GV_MODULE_PREFIX,
408: 'Fetched account segments start below:');
409: END IF; --ln_statement_level >= ln_runtime_level
410: lv_sql_stmt := 'insert into JA_CN_SUBSIDIARY_GT
411: (
412: ACCOUNT_SEGMENT_VALUE,
413: BALANCE_SIDE,
414: account_level