APPS.XLA_MULTIPERIOD_RPRTG_PKG dependencies on XLA_AE_HEADERS

Line 106: l_accounting_batch_id XLA_AE_HEADERS.ACCOUNTING_BATCH_ID%TYPE;

102: ,p_security_char_2 IN VARCHAR2
103: ,p_security_char_3 IN VARCHAR2) IS
104:
105: l_log_module VARCHAR2(240);
106: l_accounting_batch_id XLA_AE_HEADERS.ACCOUNTING_BATCH_ID%TYPE;
107:
108: BEGIN
109:
110: IF g_log_enabled THEN

Line 191: /* Changed from = xla_ae_headers to exists in xla_ae_headers

187: ,p_end_date IN DATE
188: ,p_process_category_code IN VARCHAR2) RETURN VARCHAR2 IS
189:
190: CURSOR cur_event_class IS
191: /* Changed from = xla_ae_headers to exists in xla_ae_headers
192: performance bug#8234582*/
193: SELECT DISTINCT xcl.application_id APPLICATION_ID
194: ,xcl.entity_code ENTITY_CODE
195: ,xcl.event_class_code EVENT_CLASS_CODE

Line 462: FROM xla_ae_headers xah

458: ,DECODE(xah.balance_type_code,''B''
459: ,xah.accounting_entry_status_code) BUDGET_B
460: ,DECODE(xah.balance_type_code,''E''
461: ,xah.accounting_entry_status_code) ENCUMBRANCE_B
462: FROM xla_ae_headers xah
463: ,xla_gl_ledgers_v xgl
464: ,xla_events xae
465: ,xla_event_classes_tl xec
466: ,xla_event_types_b xet

Line 510: FROM xla_ae_headers xah

506: ,sum(decode(xah.balance_type_code,''B'',1,0))
507: BUDGET_B
508: ,sum(decode(xah.balance_type_code,''E'',1,0))
509: ENCUMBRANCE_B
510: FROM xla_ae_headers xah
511: ,xla_gl_ledgers_v xgl
512: ,xla_lookups lk1
513: ,xla_lookups lk2
514: ,xla_lookups lk3

Line 529: ,XLA_AE_HEADERS XAH

525: ' SELECT ERR.MESSAGE_NUMBER ERROR_NO
526: ,ERR.ENCODED_MSG ERROR_MSG
527: ,ERR.AE_LINE_NUM LINE_NUM
528: FROM XLA_ACCOUNTING_ERRORS ERR
529: ,XLA_AE_HEADERS XAH
530: WHERE err.ae_header_id = xah.ae_header_id
531: AND err.application_id = xah.application_id ';
532:
533: xla_multiperiod_rprtg_pkg.C_RECOGNITION_COLS_QUERY :=

Line 574: ' FROM xla_ae_headers xah

570: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
571: total_accted_credits ';
572:
573: xla_multiperiod_rprtg_pkg.C_RECOGNITION_FROM_QUERY :=
574: ' FROM xla_ae_headers xah
575: ,xla_events xae
576: ,xla_event_types_tl xet
577: ,xla_event_classes_tl xec
578: ,xla_transaction_entities ent

Line 663: ' FROM xla_ae_headers xah

659: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
660: total_accted_credits ';
661:
662: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=
663: ' FROM xla_ae_headers xah
664: ,xla_events xae
665: ,xla_event_types_tl xet
666: ,xla_event_classes_tl xec
667: ,xla_transaction_entities ent

Line 754: ' FROM xla_ae_headers xah

750: ,err.message_number error_number
751: ,err.encoded_msg error_message ';
752:
753: xla_multiperiod_rprtg_pkg.C_ERRORS_FROM_QUERY :=
754: ' FROM xla_ae_headers xah
755: ,xla_events xae
756: ,xla_event_types_tl xet
757: ,xla_event_classes_tl xec
758: ,xla_transaction_entities ent