DBA Data[Home] [Help]

APPS.AR_UNACCOUNTED_TRX_SWEEP dependencies on XLA_AE_HEADERS

Line 478: UPDATE xla_ae_headers aeh

474:
475: END LOOP;
476:
477: forall i in l_event_ids.first..l_event_ids.last
478: UPDATE xla_ae_headers aeh
479: SET aeh.accounting_date = g_sweep_to_date,
480: aeh.period_name = g_sweep_period_name,
481: last_update_date = SYSDATE,
482: last_updated_by = FND_GLOBAL.user_id

Line 495: FROM xla_ae_headers aeh

491: last_update_date = sysdate,
492: last_updated_by = FND_GLOBAL.user_id
493: WHERE ael.ae_header_id in (
494: SELECT aeh.ae_header_id
495: FROM xla_ae_headers aeh
496: WHERE aeh.event_id = l_event_ids(i)
497: AND aeh.application_id = 200
498: AND aeh.gl_transfer_status_code <> 'Y'
499: AND aeh.accounting_entry_status_code <> 'F');