DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on XLA_EVENTS

Line 920: from xla_events xe, --Bug 4588031

916: -- Fix for bug 2963666 Added condition to check description is not MRC upgrade
917: DELETE FROM ap_purge_invoice_list PL
918: WHERE EXISTS (
919: Select 'invoice accounting not purgeable'
920: from xla_events xe, --Bug 4588031
921: xla_transaction_entities xte, --Bug 4588031
922: xla_ae_headers xeh, --Bug 4588031
923: ap_invoices_all ai,ap_system_parameters_all asp--bug5052748
924: where xte.entity_code = 'AP_INVOICES'

Line 938: from xla_events xe, --Bug 4588031

934: and (xeh.gl_transfer_status_code = 'N'
935: OR ( xeh.last_update_date > g_activity_date )))
936: OR EXISTS (
937: Select 'payment accounting not purgeable'
938: from xla_events xe, --Bug 4588031
939: xla_transaction_entities xte, --Bug 4588031
940: ap_invoice_payments aip,
941: ap_system_parameters_all asp,--bug5052478
942: xla_ae_headers xeh --Bug 4588031

Line 2943: FROM xla_events xe,

2939: UPDATE ap_purge_invoice_list PL
2940: SET PL.double_check_flag = 'N'
2941: WHERE EXISTS (
2942: SELECT 'invoice accounting not purgeable'
2943: FROM xla_events xe,
2944: xla_ae_headers xeh,
2945: xla_transaction_entities xte,
2946: ap_invoices_all ai,
2947: ap_system_parameters_all asp --bug5052748

Line 2962: FROM xla_events xe

2958: and (xeh.gl_transfer_status_code = 'N'
2959: OR ( xeh.last_update_date > g_activity_date)))
2960: OR EXISTS (
2961: SELECT 'payment accounting not purgeable'
2962: FROM xla_events xe
2963: , ap_invoice_payments aip
2964: , ap_checks apc
2965: , xla_ae_headers xeh
2966: , xla_transaction_entities xte