[Home] [Help]
232: FII_UTIL.put_line('Calling procedure: GET_ACCT_CLASSES');
233: FII_UTIL.put_line('');
234: end if;
235:
236: insert into FII_FA_ACCT_CLASS_CODE_GT
237: (accounting_class_code, ledger_id)
238: SELECT XACA.accounting_class_code,
239: fset.ledger_id
240: FROM xla_post_acct_progs_b XPAP,
277: from xla_assignment_defns_b XAD2
278: where xad2.ledger_id = fset.ledger_id);
279:
280: if g_debug_flag = 'Y' then
281: FII_UTIL.put_line('Updated ' || SQL%ROWCOUNT || ' rows into FII_FA_ACCT_CLASS_CODE_GT');
282: FII_UTIL.stop_timer;
283: FII_UTIL.print_timer('Duration');
284: end if;
285:
1393: nid.event_id,
1394: nid.ae_header_id
1395: from fii_fa_new_exp_hdr_ids nid,
1396: xla_ae_lines lines,
1397: fii_fa_acct_class_code_gt acls,
1398: fii_gl_ccid_dimensions ccid,
1399: gl_ledgers_public_v sob,
1400: gl_import_references gir,
1401: xla_distribution_links links,
1523: nid.event_id,
1524: nid.ae_header_id
1525: from fii_fa_new_exp_hdr_ids nid,
1526: xla_ae_lines lines,
1527: fii_fa_acct_class_code_gt acls,
1528: fii_gl_ccid_dimensions ccid,
1529: gl_ledgers_public_v sob,
1530: gl_import_references gir,
1531: xla_distribution_links links,
1726: headers.event_id,
1727: headers.ae_header_id
1728: from fii_fa_new_exp_hdr_ids nid,
1729: gl_import_references gir,
1730: fii_fa_acct_class_code_gt acls,
1731: xla_ae_lines lines,
1732: xla_ae_headers headers,
1733: fii_gl_ccid_dimensions ccid,
1734: gl_ledgers_public_v sob,
1889: headers.event_id,
1890: headers.ae_header_id
1891: from fii_fa_new_exp_hdr_ids nid,
1892: gl_import_references gir,
1893: fii_fa_acct_class_code_gt acls,
1894: xla_ae_lines lines,
1895: xla_ae_headers headers,
1896: fii_gl_ccid_dimensions ccid,
1897: gl_ledgers_public_v sob,