APPS.XLA_PERIOD_CLOSE_EXP_PKG dependencies on XLA_AE_HEADERS

Line 542: FROM XLA_AE_HEADERS aeh

538: AND ent.ledger_id = xlp.ledger_id
539: AND ent.application_id = xlp.application_id
540: AND xlp.capture_event_flag = ''Y''
541: AND NOT EXISTS (SELECT aeh.event_id
542: FROM XLA_AE_HEADERS aeh
543: WHERE aeh.application_id = xle.application_id
544: AND aeh.event_id = xle.event_id
545: )
546: AND ent.ledger_id IN ';

Line 582: ' FROM XLA_AE_HEADERS AEH

578: ,xlo5.meaning BALANCE_TYPE
579: ,xlo4.meaning PRINT_STATUS ';
580:
581: C_HEADERS_FROM_QUERY :=
582: ' FROM XLA_AE_HEADERS AEH
583: ,XLA_EVENTS XLE
584: ,XLA_TRANSACTION_ENTITIES ENT
585: ,XLA_SUBLEDGERS XLS
586: ,FND_USER FNU

Line 688: FROM xla_ae_headers aeh

684: aeh.application_id APPLICATION_ID
685: ,xcl.entity_code ENTITY_CODE
686: ,xcl.event_class_code EVENT_CLASS_CODE
687: ,gjct.reporting_view_name REPORTING_VIEW_NAME
688: FROM xla_ae_headers aeh
689: ,xla_event_types_b xcl
690: ,xla_event_class_attrs gjct
691: ,xla_transaction_entities ent
692: WHERE xcl.application_id = aeh.application_id

Line 1439: FROM xla_ae_headers aeh

1435:
1436: --IF l_unprocessed = 0 THEN
1437: SELECT count(*)
1438: INTO l_unprocessed
1439: FROM xla_ae_headers aeh
1440: ,xla_transaction_entities xte
1441: ,gl_ledger_relationships glr1
1442: ,gl_ledger_relationships glr2
1443: WHERE aeh.ledger_id = glr2.target_ledger_id

Line 1503: FROM xla_ae_headers aeh

1499:
1500: --IF l_unprocessed = 0 THEN
1501: SELECT count(*)
1502: INTO l_unprocessed
1503: FROM xla_ae_headers aeh
1504: ,xla_transaction_entities xte
1505: ,gl_ledger_relationships glr1
1506: ,gl_ledger_relationships glr2
1507: WHERE aeh.ledger_id = glr2.target_ledger_id