APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_XFR_LEDGER_MAPPINGS

Line 651: FROM gl_xfr_ledger_mappings

647: --- Get the largest delta id fully processed so far
648: ---
649: SELECT nvl(max_delta_run_id + 1, 0)
650: INTO g_low_delta_run_id
651: FROM gl_xfr_ledger_mappings
652: WHERE ledger_mapping_id = g_lgr_mapping_id;
653:
654: print_variable('g_low_delta_run_id', g_low_delta_run_id, l_log_module);
655:

Line 1595: -- This routine does any necessary maintenance on gl_xfr_ledger_mappings

1591: --=============================================================================
1592: --
1593: -- Name: update_transfer_tables
1594: -- Description:
1595: -- This routine does any necessary maintenance on gl_xfr_ledger_mappings
1596: -- and gl_xfr_led_map_periods
1597: --
1598: -- Parameters:
1599: -- *** NONE ***

Line 1609: UPDATE gl_xfr_ledger_mappings

1605: l_log_module := C_DEFAULT_MODULE||'.update_transfer_tables';
1606: enter_routine(l_log_module);
1607:
1608: IF (g_transfer_mode = C_INCREMENTAL) THEN
1609: UPDATE gl_xfr_ledger_mappings
1610: SET max_delta_run_id = g_high_delta_run_id,
1611: last_update_date = sysdate,
1612: last_updated_by = g_user_id,
1613: last_update_login = g_login_id

Line 1624: UPDATE gl_xfr_ledger_mappings

1620: --- the new first period
1621: ---
1622: IF ( g_first_period_changed
1623: OR (g_from_eff_per_num = g_first_eff_per_num)) THEN
1624: UPDATE gl_xfr_ledger_mappings
1625: SET first_eff_per_num = g_from_eff_per_num,
1626: last_update_date = sysdate,
1627: last_updated_by = g_user_id,
1628: last_update_login = g_login_id

Line 1731: FROM gl_xfr_ledger_mappings lgr,

1727: INTO g_to_ledger_id, g_lgr_mapping_id,
1728: g_coa_mapping_name, g_coa_mapping_id,
1729: g_first_eff_per_num, g_to_coa_id,
1730: g_cal_mapping_id, g_to_ledger_name
1731: FROM gl_xfr_ledger_mappings lgr,
1732: gl_coa_mappings map,
1733: gl_xfr_ledgers tlgr
1734: WHERE lgr.from_ledger_id = g_from_ledger_id
1735: AND lgr.from_ledger_currency = g_funct_curr