APPS.XLA_HIST_LEDGER_UPG_PKG dependencies on GL_ACCTS_MAP_INT_GT

Line 2677: FROM gl_accts_map_int_gt

2673:
2674: CURSOR c_invalid_ccids
2675: IS
2676: SELECT from_ccid
2677: FROM gl_accts_map_int_gt
2678: WHERE coa_mapping_id = l_mapping_relationship_id
2679: AND to_ccid IS NULL;
2680:
2681:

Line 2709: DELETE FROM gl_accts_map_int_gt; -- bug 4564062

2705: AND id_flex_code = 'GL#'
2706: AND id_flex_num = l_primary_coa; -- why is this flag for primary???
2707:
2708:
2709: DELETE FROM gl_accts_map_int_gt; -- bug 4564062
2710:
2711:
2712: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2713:

Line 2726: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)

2722: END IF;
2723:
2724:
2725:
2726: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)
2727: SELECT distinct l_mapping_relationship_id, code_combination_id
2728: FROM xla_ae_lines xal
2729: WHERE XAL.gain_or_loss_flag <> 'Y'
2730: AND EXISTS (SELECT 1

Line 2743: (p_msg => 'Rows (distinct ccids) inserted into gl_accts_map_int_gt = ' || SQL%ROWCOUNT

2739:
2740:
2741: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2742: trace
2743: (p_msg => 'Rows (distinct ccids) inserted into gl_accts_map_int_gt = ' || SQL%ROWCOUNT
2744: ,p_level => C_LEVEL_PROCEDURE
2745: ,p_module => l_log_module);
2746: END IF;
2747:

Line 2771: FROM gl_accts_map_int_gt

2767: SELECT 1
2768: INTO l_ccid_check
2769: FROM DUAL
2770: WHERE EXISTS (SELECT 1
2771: FROM gl_accts_map_int_gt
2772: WHERE coa_mapping_id = l_mapping_relationship_id
2773: AND to_ccid IS NULL);
2774:
2775: IF l_ccid_check = 1 THEN

Line 2857: FROM gl_accts_map_int_gt

2853:
2854: CURSOR c_invalid_ccids
2855: IS
2856: SELECT from_ccid
2857: FROM gl_accts_map_int_gt
2858: WHERE coa_mapping_id = l_mapping_relationship_id
2859: AND to_ccid IS NULL;
2860:
2861:

Line 2904: DELETE FROM gl_accts_map_int_gt; -- bug 4564062

2900: AND id_flex_code = 'GL#'
2901: AND id_flex_num = l_primary_coa; -- why is this flag for primary???
2902:
2903:
2904: DELETE FROM gl_accts_map_int_gt; -- bug 4564062
2905:
2906: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)
2907: SELECT distinct l_mapping_relationship_id, code_combination_id
2908: FROM xla_ae_lines

Line 2906: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)

2902:
2903:
2904: DELETE FROM gl_accts_map_int_gt; -- bug 4564062
2905:
2906: INSERT INTO gl_accts_map_int_gt(coa_mapping_id, from_ccid)
2907: SELECT distinct l_mapping_relationship_id, code_combination_id
2908: FROM xla_ae_lines
2909: WHERE request_id = l_upgrade_id;
2910:

Line 2915: (p_msg => 'Rows (distinct ccids) inserted into gl_accts_map_int_gt = ' || SQL%ROWCOUNT

2911:
2912:
2913: IF (C_LEVEL_PROCEDURE >= g_log_level) THEN
2914: trace
2915: (p_msg => 'Rows (distinct ccids) inserted into gl_accts_map_int_gt = ' || SQL%ROWCOUNT
2916: ,p_level => C_LEVEL_PROCEDURE
2917: ,p_module => l_log_module);
2918: END IF;
2919:

Line 2943: FROM gl_accts_map_int_gt gl_int

2939:
2940:
2941: UPDATE xla_ae_lines xal
2942: SET code_combination_id = (SELECT (nvl(gl_int.to_ccid, -1))
2943: FROM gl_accts_map_int_gt gl_int
2944: WHERE xal.code_combination_id = gl_int.from_ccid
2945: AND gl_int.coa_mapping_id = l_mapping_relationship_id)
2946: WHERE xal.request_id = l_upgrade_id;
2947: