DBA Data[Home] [Help]

APPS.AP_PERIOD_CLOSE_PKG dependencies on XLA_AE_HEADERS

Line 799: ,G_SRC_TAB_XLA_AE_HEADERS

795: ,decode(xla_headers_untransfered(i).entity_code,'AP_PAYMENTS',xla_headers_untransfered(i).transaction_date,NULL)
796: ,xla_headers_untransfered(i).event_type_code
797: ,xla_headers_untransfered(i).entity_code
798: ,G_SRC_TYP_UNTRANSFERED_HEADERS
799: ,G_SRC_TAB_XLA_AE_HEADERS
800: ,(select party_id from ap_invoices_all
801: where invoice_id = xla_headers_untransfered(i).source_id_int_1
802: and 'AP_INVOICES' = xla_headers_untransfered(i).entity_code
803: union

Line 2003: UPDATE xla_ae_headers aeh

1999:
2000: END LOOP;
2001:
2002: forall i in l_event_ids.first..l_event_ids.last
2003: UPDATE xla_ae_headers aeh
2004: SET aeh.accounting_date = g_sweep_to_date,
2005: aeh.period_name = g_sweep_to_period,
2006: last_update_date = SYSDATE,
2007: last_updated_by = FND_GLOBAL.user_id

Line 2020: FROM xla_ae_headers aeh

2016: last_update_date = sysdate,
2017: last_updated_by = FND_GLOBAL.user_id
2018: WHERE ael.ae_header_id in (
2019: SELECT aeh.ae_header_id
2020: FROM xla_ae_headers aeh
2021: WHERE aeh.event_id = l_event_ids(i)
2022: AND aeh.application_id = 200
2023: AND aeh.gl_transfer_status_code <> 'Y'
2024: AND aeh.accounting_entry_status_code <> 'F');