APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_ACCTS_MAP_INT_GT

Line 1365: 'INSERT INTO gl_accts_map_int_gt

1361: ---
1362: --- Insert all of the ccids to be mapped into gl_accounts_map_int_gt
1363: ---
1364: l_sqlbuf :=
1365: 'INSERT INTO gl_accts_map_int_gt
1366: (from_ccid, coa_mapping_id)
1367: SELECT DISTINCT int.code_combination_id, :coa_map
1368: FROM ' || g_interface_table_name || ' int
1369: WHERE int.request_id = :request_id

Line 1434: FROM gl_accts_map_int_gt

1430: INTO l_dummy
1431: FROM dual
1432: WHERE EXISTS
1433: (SELECT 'has errors'
1434: FROM gl_accts_map_int_gt
1435: WHERE error_code IS NOT NULL);
1436:
1437: gl_message.write_log('GLFUXFR005', 1,
1438: 'COA_MAPPING_NAME', g_coa_mapping_name);

Line 1453: --- from gl_accts_map_int_gt directly.

1449: --- Insert the mapping results into gl_ccid_mappings so we don't have
1450: --- to map again. If we are running in incremental mode, we need to
1451: --- get these from the interface table so we can get the period
1452: --- information. If we are running in batch mode, we can get them
1453: --- from gl_accts_map_int_gt directly.
1454: ---
1455: --- Note that if we are running in batch mode, we need to delete the
1456: --- old mappings as they may have changed. That would be one
1457: --- reason for them to rerun in batch mode.

Line 1467: FROM gl_accts_map_int_gt map,

1463: creation_date, created_by, last_update_date, last_updated_by,
1464: last_update_login)
1465: SELECT DISTINCT :g_lgr_mapping_id, map.from_ccid, map.to_ccid, int.reference23,
1466: sysdate, :user_id, sysdate, :user_id, :login_id
1467: FROM gl_accts_map_int_gt map,
1468: '|| g_interface_table_name || ' int
1469: WHERE int.request_id = :request_id
1470: AND int.code_combination_id = map.from_ccid
1471: AND int.status = ''MAP''

Line 1494: FROM gl_accts_map_int_gt map;

1490: creation_date, created_by, last_update_date, last_updated_by,
1491: last_update_login)
1492: SELECT g_lgr_mapping_id, from_ccid, to_ccid, g_from_period,
1493: sysdate, g_user_id, sysdate, g_user_id, g_login_id
1494: FROM gl_accts_map_int_gt map;
1495: END IF;
1496:
1497: l_row_count := SQL%ROWCOUNT;
1498:

Line 1526: FROM gl_accts_map_int_gt map,

1522: , cc.' || g_to_segs(i);
1523: END LOOP;
1524:
1525: l_sqlbuf := l_sqlbuf || '
1526: FROM gl_accts_map_int_gt map,
1527: gl_code_combinations cc
1528: WHERE map.coa_mapping_id = :coa_map_id
1529: And map.from_ccid = int.code_combination_id
1530: AND cc.code_combination_id = map.to_ccid)