APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on XLA_HISTORIC_MAPPING_GT

Line 2093: FROM xla_historic_mapping_gt;

2089:
2090:
2091: SELECT COUNT(*)
2092: INTO l_gt_count
2093: FROM xla_historic_mapping_gt;
2094:
2095: IF l_gt_count <> 0 THEN
2096:
2097: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2297: INSERT INTO xla_historic_mapping_gt(primary_header_id, new_header_id)

2293: IF (l_rows_processed <> 0) THEN --insert into GT/XDL/XAL only when headers are inserted.
2294:
2295:
2296:
2297: INSERT INTO xla_historic_mapping_gt(primary_header_id, new_header_id)
2298: SELECT /*+ rowid(xah) leading(xah) index(xahnew xla_ae_headers_n2)*/
2299: XAH.ae_header_id, XAHNEW.ae_header_id
2300: FROM xla_ae_headers XAH,
2301: xla_historic_control XHC,

Line 2338: (p_msg => 'Rows inserted into xla_historic_mapping_gt: ' || l_mapping_rows || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')

2334:
2335: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2336:
2337: trace
2338: (p_msg => 'Rows inserted into xla_historic_mapping_gt: ' || l_mapping_rows || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2339: ,p_level => C_LEVEL_PROCEDURE
2340: ,p_module => l_log_module);
2341:
2342: END IF;

Line 2362: -- rowid condition not needed below since only x-y rowid XAH headers stored in xla_historic_mapping_gt

2358: END IF;
2359:
2360:
2361:
2362: -- rowid condition not needed below since only x-y rowid XAH headers stored in xla_historic_mapping_gt
2363:
2364: INSERT INTO XLA_DISTRIBUTION_LINKS
2365: (
2366: APPLICATION_ID

Line 2573: xla_historic_mapping_gt XMAP,

2569: , XDL.ALLOC_TO_DIST_ID_CHAR_4
2570: , XDL.ALLOC_TO_DIST_ID_CHAR_5
2571: , GAIN_OR_LOSS_REF
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

Line 2811: xla_historic_mapping_gt XMAP,

2807: , XAL.SOURCE_TABLE
2808: , XAL.SOURCE_ID
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

Line 2862: FROM xla_historic_mapping_gt XMAP

2858: SELECT distinct p_mapping_rel_id, code_combination_id
2859: FROM xla_ae_lines XAL
2860: WHERE application_id = p_application_id
2861: AND EXISTS (SELECT 1
2862: FROM xla_historic_mapping_gt XMAP
2863: WHERE XMAP.new_header_id = XAL.ae_header_id); -- sec/alc header id
2864:
2865:
2866: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2887: FROM xla_historic_mapping_gt XMAP

2883: WHERE XAL.code_combination_id = GL_INT.from_ccid
2884: AND GL_INT.coa_mapping_id = p_mapping_rel_id)
2885: WHERE application_id = p_application_id
2886: AND EXISTS (SELECT 1
2887: FROM xla_historic_mapping_gt XMAP
2888: WHERE XMAP.new_header_id = XAL.ae_header_id); -- sec/alc header id
2889:
2890: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2891:

Line 2918: FROM xla_historic_mapping_gt XMAP

2914: , XAH.upg_batch_id = NULL
2915: WHERE XAH.application_id = p_application_id
2916: AND XAH.ledger_id = p_sec_alc_ledger_id
2917: AND EXISTS (SELECT 1
2918: FROM xla_historic_mapping_gt XMAP
2919: WHERE XMAP.new_header_id = XAH.ae_header_id); -- sec/alc header id
2920:
2921:
2922: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN

Line 2939: FROM xla_historic_mapping_gt GT

2935: WHERE XAH.application_id = p_application_id
2936: AND XAH.ledger_id = p_sec_alc_ledger_id
2937: AND XAH.upg_batch_id IS NOT NULL
2938: AND EXISTS (SELECT 1
2939: FROM xla_historic_mapping_gt GT
2940: WHERE GT.new_header_id = XAH.ae_header_id);
2941:
2942: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2943: trace