APPS.XLA_MULTIPERIOD_RPRTG_PKG dependencies on XLA_AE_HEADERS

Line 91: l_accounting_batch_id XLA_AE_HEADERS.ACCOUNTING_BATCH_ID%TYPE;

87: ,p_security_char_2 IN VARCHAR2
88: ,p_security_char_3 IN VARCHAR2) IS
89:
90: l_log_module VARCHAR2(240);
91: l_accounting_batch_id XLA_AE_HEADERS.ACCOUNTING_BATCH_ID%TYPE;
92:
93: BEGIN
94:
95: IF g_log_enabled THEN

Line 180: FROM xla_ae_headers aeh

176: SELECT DISTINCT aeh.application_id APPLICATION_ID
177: ,xcl.entity_code ENTITY_CODE
178: ,xcl.event_class_code EVENT_CLASS_CODE
179: ,xatr.reporting_view_name REPORTING_VIEW_NAME
180: FROM xla_ae_headers aeh
181: ,xla_event_types_b xcl
182: ,xla_event_class_attrs xatr
183: WHERE xcl.application_id = aeh.application_id
184: AND xcl.event_type_code = aeh.event_type_code

Line 407: FROM xla_ae_headers xah

403: ,DECODE(xah.balance_type_code,''B''
404: ,xah.accounting_entry_status_code) BUDGET_B
405: ,DECODE(xah.balance_type_code,''E''
406: ,xah.accounting_entry_status_code) ENCUMBRANCE_B
407: FROM xla_ae_headers xah
408: ,xla_gl_ledgers_v xgl
409: ,xla_events xae
410: ,xla_event_classes_tl xec
411: ,xla_event_types_b xet

Line 455: FROM xla_ae_headers xah

451: ,sum(decode(xah.balance_type_code,''B'',1,0))
452: BUDGET_B
453: ,sum(decode(xah.balance_type_code,''E'',1,0))
454: ENCUMBRANCE_B
455: FROM xla_ae_headers xah
456: ,xla_gl_ledgers_v xgl
457: ,xla_lookups lk1
458: ,xla_lookups lk2
459: ,xla_lookups lk3

Line 474: ,XLA_AE_HEADERS XAH

470: ' SELECT ERR.MESSAGE_NUMBER ERROR_NO
471: ,ERR.ENCODED_MSG ERROR_MSG
472: ,ERR.AE_LINE_NUM LINE_NUM
473: FROM XLA_ACCOUNTING_ERRORS ERR
474: ,XLA_AE_HEADERS XAH
475: WHERE err.ae_header_id = xah.ae_header_id
476: AND err.application_id = xah.application_id ';
477:
478: xla_multiperiod_rprtg_pkg.C_RECOGNITION_COLS_QUERY :=

Line 519: ' FROM xla_ae_headers xah

515: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
516: total_accted_credits ';
517:
518: xla_multiperiod_rprtg_pkg.C_RECOGNITION_FROM_QUERY :=
519: ' FROM xla_ae_headers xah
520: ,xla_events xae
521: ,xla_event_types_tl xet
522: ,xla_event_classes_tl xec
523: ,xla_transaction_entities ent

Line 608: ' FROM xla_ae_headers xah

604: ,sum(xal.accounted_cr) over (partition by xal.ae_header_id)
605: total_accted_credits ';
606:
607: xla_multiperiod_rprtg_pkg.C_ACCRUAL_RVRSL_FROM_QUERY :=
608: ' FROM xla_ae_headers xah
609: ,xla_events xae
610: ,xla_event_types_tl xet
611: ,xla_event_classes_tl xec
612: ,xla_transaction_entities ent

Line 699: ' FROM xla_ae_headers xah

695: ,err.message_number error_number
696: ,err.encoded_msg error_message ';
697:
698: xla_multiperiod_rprtg_pkg.C_ERRORS_FROM_QUERY :=
699: ' FROM xla_ae_headers xah
700: ,xla_events xae
701: ,xla_event_types_tl xet
702: ,xla_event_classes_tl xec
703: ,xla_transaction_entities ent