APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_TRX

Line 491: Cursor for selecting rows from jl_co_gl_trx table

487: mgc.config_id,
488: mgr.range_id;
489:
490: /*************************************************
491: Cursor for selecting rows from jl_co_gl_trx table
492: *************************************************/
493:
494: CURSOR trx_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,
495: x_range_id jl_co_gl_mg_ranges.range_id%TYPE) IS

Line 505: FROM jl_co_gl_trx t,

501: '3', SUM(NVL(t.accounted_dr, 0)) - SUM(NVL(t.accounted_cr, 0)),
502: '4', SUM(NVL(t.accounted_cr, 0)) - SUM(NVL(t.accounted_dr, 0)),
503: 0
504: ) amount
505: FROM jl_co_gl_trx t,
506: -- bug 9384107
507: gl_sets_of_books sob1
508: WHERE t.set_of_books_id = sob1.set_of_books_id
509: AND exists (SELECT /*+ NO_UNNEST */ 'X'

Line 879: Select nit_id and sum(amount) from jl_co_gl_balances and jl_co_gl_trx tables

875: get_move_rec.send_back_flag := 'N';
876: get_move_rec.origin := 'A';
877:
878: /****************************************************************************
879: Select nit_id and sum(amount) from jl_co_gl_balances and jl_co_gl_trx tables
880: ****************************************************************************/
881:
882: IF literal_rec.movement_type IN ('1', '2', '3', '4') THEN
883: