APPS.AP_PURGE_PKG dependencies on XLA_EVENTS

Line 1080: xla_events xe, --Bug 4588031

1076: Select /*+ ORDERED PARALLEL(pl1) FULL(pl1) */
1077: pl1.rowid -- 7759218
1078: from ap_purge_invoice_list pl1,
1079: ap_invoices_all ai,
1080: xla_events xe, --Bug 4588031
1081: xla_transaction_entities xte, --Bug 4588031
1082: xla_ae_headers xeh, --Bug 4588031
1083: ap_system_parameters_all asp--bug5052748
1084: where xte.entity_code = 'AP_INVOICES'

Line 1100: xla_events xe, --Bug 4588031

1096: UNION
1097: Select /*+ ORDERED PARALLEL(pl1) FULL(pl1) */
1098: pl1.rowid -- 7759218
1099: from ap_purge_invoice_list pl1,
1100: xla_events xe, --Bug 4588031
1101: xla_transaction_entities xte, --Bug 4588031
1102: ap_invoice_payments aip,
1103: ap_system_parameters_all asp,--bug5052478
1104: xla_ae_headers xeh --Bug 4588031

Line 3280: FROM xla_events xe,

3276: UPDATE ap_purge_invoice_list PL
3277: SET PL.double_check_flag = 'N'
3278: WHERE EXISTS (
3279: SELECT 'invoice accounting not purgeable'
3280: FROM xla_events xe,
3281: xla_ae_headers xeh,
3282: xla_transaction_entities xte,
3283: ap_invoices_all ai,
3284: ap_system_parameters_all asp --bug5052748

Line 3301: from xla_events xe, --Bug 4588031

3297: OR EXISTS (
3298: /* Changed the subquery - bug 12955426. Now the delete stmt (in Do_independent_inv_checks())
3299: and update stmt (in Retest_Invoice_Independents()) has same queries. */
3300: Select 'payment accounting not purgeable' -- 7759218
3301: from xla_events xe, --Bug 4588031
3302: xla_transaction_entities xte, --Bug 4588031
3303: ap_invoice_payments aip,
3304: ap_system_parameters_all asp,--bug5052478
3305: xla_ae_headers xeh --Bug 4588031

Line 3321: FROM xla_events xe

3317: OR ( xeh.last_update_date > g_activity_date)));
3318: /*Commented the subquery - bug 12955426 */
3319: /*
3320: SELECT 'payment accounting not purgeable'
3321: FROM xla_events xe
3322: , ap_invoice_payments aip
3323: , ap_checks apc
3324: , xla_ae_headers xeh
3325: , xla_transaction_entities xte