DBA Data[Home] [Help]

APPS.XLA_MPA_ACCRUAL_RPRTG_PKG dependencies on GL_JE_SOURCES_TL

Line 709: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;

705: ,p_accounting_batch_id IN NUMBER) RETURN NUMBER IS
706:
707: l_log_module VARCHAR2(240);
708: l_request_id NUMBER;
709: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;
710: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;
711: l_ledger VARCHAR2(30);
712: l_process_category_name VARCHAR2(80);
713: l_create_accounting_flag VARCHAR2(80);

Line 710: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;

706:
707: l_log_module VARCHAR2(240);
708: l_request_id NUMBER;
709: l_source_application gl_je_sources_tl.user_je_source_name%TYPE;
710: l_je_source gl_je_sources_tl.user_je_source_name%TYPE;
711: l_ledger VARCHAR2(30);
712: l_process_category_name VARCHAR2(80);
713: l_create_accounting_flag VARCHAR2(80);
714: l_errors_only_flag VARCHAR2(80);

Line 786: FROM xla_subledgers xls, gl_je_sources_tl gjst

782:
783: IF p_source_application_id IS NOT NULL THEN
784: SELECT gjst.user_je_source_name
785: INTO l_source_application
786: FROM xla_subledgers xls, gl_je_sources_tl gjst
787: WHERE xls.application_id = p_source_application_id
788: AND xls.je_source_name = gjst.je_source_name
789: AND gjst.language = USERENV('LANG');
790: END IF;

Line 794: FROM xla_subledgers xls, gl_je_sources_tl gjst

790: END IF;
791:
792: SELECT gjst.user_je_source_name
793: INTO l_je_source
794: FROM xla_subledgers xls, gl_je_sources_tl gjst
795: WHERE xls.application_id = p_application_id
796: AND xls.je_source_name = gjst.je_source_name
797: AND gjst.language = USERENV('LANG');
798: