APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_BALANCES_DELTA

Line 659: LOCK TABLE gl_balances_delta IN EXCLUSIVE MODE NOWAIT;

655:
656: ---
657: --- Lock the table to make sure no one is inserting into it right now
658: ---
659: LOCK TABLE gl_balances_delta IN EXCLUSIVE MODE NOWAIT;
660:
661: ---
662: --- Get the largest delta id data exists for
663: ---

Line 666: FROM GL_BALANCES_DELTA;

662: --- Get the largest delta id data exists for
663: ---
664: SELECT nvl(max(delta_run_id), 0)
665: into g_high_delta_run_id
666: FROM GL_BALANCES_DELTA;
667:
668: print_variable('g_high_delta_run_id', g_high_delta_run_id, l_log_module);
669:
670: print_logfile('Processing delta run ids from '

Line 1136: FROM gl_balances_delta bal,

1132: END IF;
1133:
1134: IF (g_transfer_mode = C_INCREMENTAL) THEN
1135: l_sqlbuf := l_sqlbuf || '
1136: FROM gl_balances_delta bal,
1137: gl_xfr_led_map_periods lmper, gl_row_multipliers mult, ';
1138:
1139: IF (g_coa_mapping_id IS NOT NULL) THEN
1140: l_sqlbuf := l_sqlbuf || '

Line 1640: gl_balances_delta_s.nextval,

1636: creation_date, created_by, last_update_date,
1637: last_updated_by, last_update_login)
1638: SELECT g_lgr_mapping_id, g_from_period,
1639: g_from_eff_per_num, 'Y',
1640: gl_balances_delta_s.nextval,
1641: sysdate, g_user_id,
1642: sysdate, g_user_id,
1643: g_login_id
1644: FROM dual

Line 1654: max_delta_run_id = gl_balances_delta_s.nextval,

1650:
1651: IF (SQL%ROWCOUNT = 0) THEN
1652: UPDATE gl_xfr_led_map_periods
1653: SET full_transfer_done_flag = 'Y',
1654: max_delta_run_id = gl_balances_delta_s.nextval,
1655: last_update_date = sysdate,
1656: last_updated_by = g_user_id,
1657: last_update_login = g_login_id
1658: WHERE ledger_mapping_id = g_lgr_mapping_id