APPS.XLA_AAD_OVERWRITE_PVT dependencies on XLA_ACCTG_METHODS_B

Line 1770: INSERT INTO xla_acctg_methods_b

1766: p_module => l_log_module,
1767: p_level => C_LEVEL_PROCEDURE);
1768: END IF;
1769:
1770: INSERT INTO xla_acctg_methods_b
1771: (accounting_method_type_code
1772: ,accounting_method_code
1773: ,transaction_coa_id
1774: ,accounting_coa_id

Line 1793: LEFT OUTER JOIN xla_acctg_methods_b w

1789: ,sysdate
1790: ,xla_environment_pkg.g_usr_id
1791: ,xla_environment_pkg.g_login_id
1792: FROM xla_stage_acctg_methods s
1793: LEFT OUTER JOIN xla_acctg_methods_b w
1794: ON w.accounting_method_type_code = s.accounting_method_type_code
1795: AND w.accounting_method_code = s.accounting_method_code
1796: WHERE s.staging_amb_context_code = g_staging_context_code
1797: AND w.accounting_method_type_code IS NULL;

Line 1800: trace(p_msg => '# row inserted in xla_acctg_methods_b = '||SQL%ROWCOUNT,

1796: WHERE s.staging_amb_context_code = g_staging_context_code
1797: AND w.accounting_method_type_code IS NULL;
1798:
1799: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1800: trace(p_msg => '# row inserted in xla_acctg_methods_b = '||SQL%ROWCOUNT,
1801: p_module => l_log_module,
1802: p_level => C_LEVEL_STATEMENT);
1803: END IF;
1804: