APPS.XLA_MPA_ACCRUAL_RPRTG_PKG dependencies on XLA_SUBLEDGERS

Line 327: ,xla_subledgers xls

323: FROM xla_ae_headers xah
324: ,xla_gl_ledgers_v xgl
325: ,xla_event_classes_tl xec
326: ,xla_event_types_b xet
327: ,xla_subledgers xls
328: ,xla_lookups lk1
329: ,xla_lookups lk2
330: ,xla_lookups lk3
331: WHERE xgl.ledger_id = xah.ledger_id

Line 381: ,xla_subledgers xls

377: END) ACCRUAL_REVERSAL
378: FROM xla_ae_headers xah
379: ,xla_ae_lines xal
380: ,xla_gl_ledgers_v xgl
381: ,xla_subledgers xls
382: ,xla_lookups lk1
383: ,xla_lookups lk2
384: ,xla_lookups lk3
385: ,xla_lookups lk4

Line 406: ,xla_subledgers XLS

402: ,ERR.ENCODED_MSG ERROR_MSG
403: ,ERR.AE_LINE_NUM LINE_NUM
404: FROM XLA_ACCOUNTING_ERRORS ERR
405: ,XLA_AE_HEADERS XAH
406: ,xla_subledgers XLS
407: WHERE err.ae_header_id = xah.ae_header_id
408: AND err.application_id = xah.application_id
409: AND xls.application_id = xah.application_id ';
410:

Line 554: ,xla_subledgers xls ';

550: ,xla_ae_lines xal
551: ,fnd_document_sequences seq
552: ,fun_seq_versions seqv2
553: ,fun_seq_versions seqv3
554: ,xla_subledgers xls ';
555:
556: xla_mpa_accrual_rprtg_pkg.C_ACCRUAL_RVRSL_WHR_QUERY :=
557: ' WHERE xec.application_id = xet.application_id
558: AND xec.event_class_code = xet.event_class_code

Line 648: ,xla_subledgers xls

644: ,xla_ae_lines xal
645: ,fnd_document_sequences seq
646: ,fun_seq_versions seqv2
647: ,fun_seq_versions seqv3
648: ,xla_subledgers xls
649: ,xla_accounting_errors err ';
650:
651: xla_mpa_accrual_rprtg_pkg.C_ERRORS_WHR_QUERY :=
652: ' WHERE xec.application_id = xet.application_id

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: