DBA Data[Home] [Help]

APPS.JA_CN_GL_INTER_VALID_PKG dependencies on GL_JE_BATCHES

Line 682: l_je_batch_name GL_JE_BATCHES.name%TYPE;

678: l_jnl_src gl_je_sources_tl.je_source_name%TYPE;
679:
680: l_je_header_id GL_JE_HEADERS.JE_HEADER_ID%TYPE;
681: l_je_status GL_JE_HEADERS.STATUS%TYPE; -- JOURNAL status
682: l_je_batch_name GL_JE_BATCHES.name%TYPE;
683: l_je_name GL_JE_HEADERS.name%TYPE;
684: l_je_source GL_JE_HEADERS.je_source%TYPE;
685: l_je_usr_source gl_je_sources_tl.user_je_source_name%TYPE;
686: l_je_catg GL_JE_HEADERS.je_category%TYPE;

Line 755: FROM GL_JE_BATCHES jeb

751: ,jeh.description jnl_des
752: ,src_t.user_je_source_name jnl_usr_source
753: ,catg_t.user_je_category_name jnl_usr_catg
754: ,jeh.status jeh_status
755: FROM GL_JE_BATCHES jeb
756: ,GL_JE_HEADERS jeh
757: ,gl_je_sources_tl src_t
758: ,gl_je_categories_tl catg_t
759: WHERE jeh.ledger_id = l_ledger_id --using variable l_sob_id