APPS.JL_CO_GL_MG_MEDIA_PKG dependencies on JL_CO_GL_TRX

Line 437: Cursor for selecting rows from jl_co_gl_trx table

433: mgc.config_id,
434: mgr.range_id;
435:
436: /*************************************************
437: Cursor for selecting rows from jl_co_gl_trx table
438: *************************************************/
439:
440: CURSOR trx_cur (x_movement_type jl_co_gl_mg_configs.movement_type%TYPE,
441: x_range_id jl_co_gl_mg_ranges.range_id%TYPE) IS

Line 451: FROM jl_co_gl_trx t,

447: '3', SUM(NVL(t.accounted_dr, 0)) - SUM(NVL(t.accounted_cr, 0)),
448: '4', SUM(NVL(t.accounted_cr, 0)) - SUM(NVL(t.accounted_dr, 0)),
449: 0
450: ) amount
451: FROM jl_co_gl_trx t,
452: jl_co_gl_nits nit,
453: gl_sets_of_books sob1
454: WHERE t.set_of_books_id = sob1.set_of_books_id
455: AND nit.nit_id = t.nit_id

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

818: get_move_rec.send_back_flag := 'N';
819: get_move_rec.origin := 'A';
820:
821: /****************************************************************************
822: Select nit_id and sum(amount) from jl_co_gl_balances and jl_co_gl_trx tables
823: ****************************************************************************/
824:
825: IF literal_rec.movement_type IN ('1', '2', '3', '4') THEN
826: