APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on GL_ACCTS_MAP_INT_GT

Line 2846: DELETE FROM gl_accts_map_int_gt; -- bug 4564062

2842:
2843: IF p_ccid_map = 'Y' THEN
2844:
2845:
2846: DELETE FROM gl_accts_map_int_gt; -- bug 4564062
2847:
2848:
2849: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2850: trace

Line 2851: (p_msg => 'Rows deleted from gl_accts_map_int_gt = ' || SQL%ROWCOUNT

2847:
2848:
2849: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2850: trace
2851: (p_msg => 'Rows deleted from gl_accts_map_int_gt = ' || SQL%ROWCOUNT
2852: ,p_level => C_LEVEL_PROCEDURE
2853: ,p_module => l_log_module);
2854: END IF;
2855:

Line 2857: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)

2853: ,p_module => l_log_module);
2854: END IF;
2855:
2856:
2857: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)
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

Line 2869: (p_msg => 'Rows (distinct ccids) inserted into gl_accts_map_int_gt ' || SQL%ROWCOUNT || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')

2865:
2866: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2867:
2868: trace
2869: (p_msg => 'Rows (distinct ccids) inserted into gl_accts_map_int_gt ' || SQL%ROWCOUNT || ' at ' || to_char(sysdate, 'DD-MON-YYYY HH:MI:SS')
2870: ,p_level => C_LEVEL_PROCEDURE
2871: ,p_module => l_log_module);
2872:
2873: END IF;

Line 2882: FROM gl_accts_map_int_gt GL_INT

2878: ,debug => g_log_enabled);
2879:
2880: UPDATE xla_ae_lines XAL
2881: SET code_combination_id = (SELECT (nvl(GL_INT.to_ccid, -1))
2882: FROM gl_accts_map_int_gt GL_INT
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