DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_JE_BATCHES

Line 677: l_je_batch_name GL_JE_BATCHES.name%TYPE;

673: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;
674:
675: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
676: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
677: l_je_batch_name GL_JE_BATCHES.name%TYPE;
678: l_je_name GL_JE_HEADERS.name%TYPE;
679: l_je_source GL_JE_HEADERS.je_source%TYPE;
680: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
681: l_je_catg GL_JE_HEADERS.je_category%TYPE;

Line 750: FROM GL_JE_BATCHES jeb

746: ,jeh.description jnl_des
747: ,src_t.user_je_source_name jnl_usr_source
748: ,catg_t.user_je_category_name jnl_usr_catg
749: ,jeh.status jeh_status
750: FROM GL_JE_BATCHES jeb
751: ,GL_JE_HEADERS jeh
752: ,gl_je_sources_tl src_t
753: ,gl_je_categories_tl catg_t
754: WHERE jeh.ledger_id = l_ledger_id --using variable l_sob_id