APPS.XLA_MPA_ACCRUAL_RPRTG_PKG dependencies on XLA_SUBLEDGERS

Line 304: ,xla_subledgers xls

300: FROM xla_ae_headers xah
301: ,xla_gl_ledgers_v xgl
302: ,xla_event_classes_tl xec
303: ,xla_event_types_b xet
304: ,xla_subledgers xls
305: ,xla_lookups lk1
306: ,xla_lookups lk2
307: ,xla_lookups lk3
308: WHERE xgl.ledger_id = xah.ledger_id

Line 358: ,xla_subledgers xls

354: END) ACCRUAL_REVERSAL
355: FROM xla_ae_headers xah
356: ,xla_ae_lines xal
357: ,xla_gl_ledgers_v xgl
358: ,xla_subledgers xls
359: ,xla_lookups lk1
360: ,xla_lookups lk2
361: ,xla_lookups lk3
362: ,xla_lookups lk4

Line 383: ,xla_subledgers XLS

379: ,ERR.ENCODED_MSG ERROR_MSG
380: ,ERR.AE_LINE_NUM LINE_NUM
381: FROM XLA_ACCOUNTING_ERRORS ERR
382: ,XLA_AE_HEADERS XAH
383: ,xla_subledgers XLS
384: WHERE err.ae_header_id = xah.ae_header_id
385: AND err.application_id = xah.application_id
386: AND xls.application_id = xah.application_id ';
387:

Line 531: ,xla_subledgers xls ';

527: ,xla_ae_lines xal
528: ,fnd_document_sequences seq
529: ,fun_seq_versions seqv2
530: ,fun_seq_versions seqv3
531: ,xla_subledgers xls ';
532:
533: xla_mpa_accrual_rprtg_pkg.C_ACCRUAL_RVRSL_WHR_QUERY :=
534: ' WHERE xec.application_id = xet.application_id
535: AND xec.event_class_code = xet.event_class_code

Line 625: ,xla_subledgers xls

621: ,xla_ae_lines xal
622: ,fnd_document_sequences seq
623: ,fun_seq_versions seqv2
624: ,fun_seq_versions seqv3
625: ,xla_subledgers xls
626: ,xla_accounting_errors err ';
627:
628: xla_mpa_accrual_rprtg_pkg.C_ERRORS_WHR_QUERY :=
629: ' WHERE xec.application_id = xet.application_id

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: