APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on XLA_RC_UPGRADE_RATES

Line 1340: FROM xla_rc_upgrade_rates

1336: SELECT 1
1337: INTO g_rate_exists
1338: FROM DUAL
1339: WHERE EXISTS (SELECT 1
1340: FROM xla_rc_upgrade_rates
1341: WHERE relationship_id = g_relationship_id
1342: AND upgrade_run_id = g_upgrade_id);
1343:
1344:

Line 1459: INSERT INTO xla_rc_upgrade_rates

1455: ,p_module => l_log_module);
1456: END IF;
1457: END IF;
1458:
1459: INSERT INTO xla_rc_upgrade_rates
1460: (relationship_id
1461: ,upgrade_run_id
1462: ,from_currency
1463: ,to_currency

Line 1564: INSERT INTO xla_rc_upgrade_rates

1560:
1561: END IF;
1562:
1563:
1564: INSERT INTO xla_rc_upgrade_rates
1565: (relationship_id
1566: ,upgrade_run_id
1567: ,from_currency
1568: ,to_currency

Line 1603: FROM xla_rc_upgrade_rates

1599: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
1600:
1601: SELECT count(*)
1602: INTO g_currency_count
1603: FROM xla_rc_upgrade_rates
1604: WHERE relationship_id = g_relationship_id
1605: AND upgrade_run_id = g_upgrade_id;
1606:
1607: trace

Line 1608: (p_msg => 'Rows inserted into xla_rc_upgrade_rates after calling GL API = ' || g_currency_count

1604: WHERE relationship_id = g_relationship_id
1605: AND upgrade_run_id = g_upgrade_id;
1606:
1607: trace
1608: (p_msg => 'Rows inserted into xla_rc_upgrade_rates after calling GL API = ' || g_currency_count
1609: ,p_level => C_LEVEL_PROCEDURE
1610: ,p_module => l_log_module);
1611: END IF;
1612:

Line 2576: xla_rc_upgrade_rates XRUR

2572: FROM xla_historic_control XHC,
2573: xla_historic_mapping_gt XMAP,
2574: xla_ae_lines XAL,
2575: xla_distribution_links XDL,
2576: xla_rc_upgrade_rates XRUR
2577: WHERE XHC.primary_ledger = p_primary_ledger_id -- worker input
2578: AND XHC.secondary_alc_ledger = p_sec_alc_ledger_id -- worker input
2579: AND XHC.upgrade_id = p_ugprade_id -- worker input
2580: AND XHC.application_id = p_application_id -- worker input

Line 2813: xla_rc_upgrade_rates XRUR

2809: , XAL.ACCOUNT_OVERLAY_SOURCE_ID
2810: FROM xla_historic_control XHC,
2811: xla_historic_mapping_gt XMAP,
2812: xla_ae_lines XAL,
2813: xla_rc_upgrade_rates XRUR
2814: WHERE XHC.primary_ledger = p_primary_ledger_id -- worker input
2815: AND XHC.secondary_alc_ledger = p_sec_alc_ledger_id -- worker input
2816: AND XHC.upgrade_id = p_ugprade_id -- worker input
2817: AND XHC.application_id = p_application_id -- worker input