APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_AE_HEADERS

Line 549: FROM XLA_AE_HEADERS aeh

545: AND ent.ledger_id = xlp.ledger_id
546: AND ent.application_id = xlp.application_id
547: AND xlp.capture_event_flag = ''Y''
548: AND NOT EXISTS (SELECT aeh.event_id
549: FROM XLA_AE_HEADERS aeh
550: WHERE aeh.application_id = xle.application_id
551: AND aeh.event_id = xle.event_id
552: )
553: AND ent.ledger_id IN ';

Line 589: ' FROM XLA_AE_HEADERS AEH

585: ,xlo5.meaning BALANCE_TYPE
586: ,xlo4.meaning PRINT_STATUS ';
587:
588: C_HEADERS_FROM_QUERY :=
589: ' FROM XLA_AE_HEADERS AEH
590: ,XLA_EVENTS XLE
591: ,XLA_TRANSACTION_ENTITIES ENT
592: ,XLA_SUBLEDGERS XLS
593: ,FND_USER FNU

Line 695: FROM xla_ae_headers aeh

691: aeh.application_id APPLICATION_ID
692: ,xcl.entity_code ENTITY_CODE
693: ,xcl.event_class_code EVENT_CLASS_CODE
694: ,gjct.reporting_view_name REPORTING_VIEW_NAME
695: FROM xla_ae_headers aeh
696: ,xla_event_types_b xcl
697: ,xla_event_class_attrs gjct
698: ,xla_transaction_entities ent
699: WHERE xcl.application_id = aeh.application_id

Line 1490: FROM xla_ae_headers aeh

1486:
1487: --IF l_unprocessed = 0 THEN
1488: SELECT count(*)
1489: INTO l_unprocessed
1490: FROM xla_ae_headers aeh
1491: ,xla_transaction_entities xte
1492: ,gl_ledger_relationships glr1
1493: ,gl_ledger_relationships glr2
1494: WHERE aeh.ledger_id = glr2.target_ledger_id

Line 1554: FROM xla_ae_headers aeh

1550:
1551: --IF l_unprocessed = 0 THEN
1552: SELECT count(*)
1553: INTO l_unprocessed
1554: FROM xla_ae_headers aeh
1555: ,xla_transaction_entities xte
1556: ,gl_ledger_relationships glr1
1557: ,gl_ledger_relationships glr2
1558: WHERE aeh.ledger_id = glr2.target_ledger_id