DBA Data[Home] [Help]

APPS.XLA_MPA_ACCRUAL_RPRTG_PKG dependencies on GL_JE_SOURCES_TL

Line 740: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;

736: ,p_accounting_batch_id IN NUMBER) RETURN NUMBER IS
737:
738: l_log_module VARCHAR2(240);
739: l_request_id NUMBER;
740: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;
741: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;
742: l_ledger VARCHAR2(30);
743: l_process_category_name VARCHAR2(80);
744: l_create_accounting_flag VARCHAR2(80);

Line 741: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;

737:
738: l_log_module VARCHAR2(240);
739: l_request_id NUMBER;
740: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;
741: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;
742: l_ledger VARCHAR2(30);
743: l_process_category_name VARCHAR2(80);
744: l_create_accounting_flag VARCHAR2(80);
745: l_errors_only_flag VARCHAR2(80);

Line 819: FROM xla_subledgers xls, gl_je_sources_tl gjst

815:
816: IF p_source_application_id IS NOT NULL THEN
817: SELECT gjst.user_je_source_name
818: INTO l_source_application
819: FROM xla_subledgers xls, gl_je_sources_tl gjst
820: WHERE xls.application_id = p_source_application_id
821: AND xls.je_source_name = gjst.je_source_name
822: AND gjst.language = USERENV('LANG');
823: END IF;

Line 827: FROM xla_subledgers xls, gl_je_sources_tl gjst

823: END IF;
824:
825: SELECT gjst.user_je_source_name
826: INTO l_je_source
827: FROM xla_subledgers xls, gl_je_sources_tl gjst
828: WHERE xls.application_id = p_application_id
829: AND xls.je_source_name = gjst.je_source_name
830: AND gjst.language = USERENV('LANG');
831: