DBA Data[Home] [Help]

APPS.FV_TREASURY_PAYMENTS_PKG dependencies on XLA_AE_HEADERS

Line 972: (SELECT event_id FROM xla_ae_headers xh

968: AND xe.event_id = fv.event_id
969: AND xe.event_status_code = 'U'
970: )
971: AND NOT EXISTS
972: (SELECT event_id FROM xla_ae_headers xh
973: WHERE xh.application_id = 8901
974: AND xh.event_type_code = 'TREASURY_VOID'
975: AND xh.event_id = fv.event_id);
976:

Line 997: --and such events will not exist in fv_xla_ae_headers.

993:
994: --Update the processed flag to U, of the void rows which
995: --were erroneously set to P in the earlier version of the code
996: --The events of these rows will be unprocessed in xla_events
997: --and such events will not exist in fv_xla_ae_headers.
998: BEGIN
999: OPEN unprocessed_event_cur ;
1000: LOOP
1001: FETCH unprocessed_event_cur into cur_event_id;