348: p_je_source_name := NULL;
349: ELSE
350: SELECT gjst.je_source_name
351: INTO p_je_source_name
352: FROM xla_subledgers xls, gl_je_sources_tl gjst
353: WHERE xls.application_id = p_application_id
354: AND xls.je_source_name = gjst.je_source_name
355: AND gjst.language = USERENV('LANG');
356: END IF;
491: ,XLA_SUBLEDGERS XLS
492: ,FND_USER FNU
493: ,GL_PERIOD_STATUSES GPS
494: ,GL_LEDGERS GLD
495: ,GL_JE_SOURCES_TL GJT
496: ,GL_JE_CATEGORIES_TL GJCT
497: ,XLA_EVENT_CLASSES_TL XCL
498: ,XLA_EVENT_TYPES_B XET
499: ,XLA_EVENT_TYPES_TL XTT
585: ,XLA_SUBLEDGERS XLS
586: ,FND_USER FNU
587: ,GL_PERIOD_STATUSES GPS
588: ,GL_LEDGERS GLD
589: ,GL_JE_SOURCES_TL GJT
590: ,GL_JE_CATEGORIES_TL GJCT
591: ,XLA_EVENT_TYPES_B XET
592: ,XLA_EVENT_TYPES_TL XTT
593: ,XLA_EVENT_CLASSES_TL XCL