APPS.XLA_AAD_MERGE_PVT dependencies on XLA_ACCTG_METHOD_RULES

Line 3605: UPDATE xla_acctg_method_rules xamr

3601: p_module => l_log_module,
3602: p_level => C_LEVEL_STATEMENT);
3603: END IF;
3604:
3605: UPDATE xla_acctg_method_rules xamr
3606: SET amb_context_code = g_amb_context_code
3607: WHERE amb_context_code = g_staging_context_code
3608: AND NOT EXISTS (SELECT 1
3609: FROM xla_acctg_method_rules xamr2

Line 3609: FROM xla_acctg_method_rules xamr2

3605: UPDATE xla_acctg_method_rules xamr
3606: SET amb_context_code = g_amb_context_code
3607: WHERE amb_context_code = g_staging_context_code
3608: AND NOT EXISTS (SELECT 1
3609: FROM xla_acctg_method_rules xamr2
3610: WHERE xamr2.amb_context_code = g_amb_context_code
3611: AND xamr2.accounting_method_type_code = xamr.accounting_method_type_code
3612: AND xamr2.accounting_method_code = xamr.accounting_method_code
3613: AND xamr2.application_id = g_application_id);

Line 3660: FROM xla_acctg_method_rules

3656: FROM (SELECT distinct product_rule_type_code
3657: , product_rule_code
3658: , accounting_method_type_code
3659: , accounting_method_code
3660: FROM xla_acctg_method_rules
3661: WHERE amb_context_code = g_staging_context_code);
3662:
3663: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3664: trace(p_msg => '# row inserted in xla_acctg_method_rules = '||SQL%ROWCOUNT,

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

3660: FROM xla_acctg_method_rules
3661: WHERE amb_context_code = g_staging_context_code);
3662:
3663: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
3664: trace(p_msg => '# row inserted in xla_acctg_method_rules = '||SQL%ROWCOUNT,
3665: p_module => l_log_module,
3666: p_level => C_LEVEL_STATEMENT);
3667: END IF;
3668: