APPS.XLA_AAD_MERGE_PVT dependencies on XLA_ACCTG_METHODS_B

Line 3532: INSERT INTO xla_acctg_methods_b

3528: p_module => l_log_module,
3529: p_level => C_LEVEL_PROCEDURE);
3530: END IF;
3531:
3532: INSERT INTO xla_acctg_methods_b
3533: (accounting_method_type_code
3534: ,accounting_method_code
3535: ,transaction_coa_id
3536: ,accounting_coa_id

Line 3554: LEFT OUTER JOIN xla_acctg_methods_b w

3550: ,sysdate
3551: ,xla_environment_pkg.g_usr_id
3552: ,xla_environment_pkg.g_login_id
3553: FROM xla_stage_acctg_methods s
3554: LEFT OUTER JOIN xla_acctg_methods_b w
3555: ON w.accounting_method_type_code = s.accounting_method_type_code
3556: AND w.accounting_method_code = s.accounting_method_code
3557: WHERE s.staging_amb_context_code = g_staging_context_code
3558: AND w.accounting_method_type_code IS NULL;

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

3557: WHERE s.staging_amb_context_code = g_staging_context_code
3558: AND w.accounting_method_type_code IS NULL;
3559:
3560: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3561: trace(p_msg => '# row inserted in xla_acctg_methods_b = '||SQL%ROWCOUNT,
3562: p_module => l_log_module,
3563: p_level => C_LEVEL_STATEMENT);
3564: END IF;
3565: