DBA Data[Home] [Help]

APPS.AP_PURGE_PKG dependencies on XLA_AE_HEADERS

Line 922: xla_ae_headers xeh, --Bug 4588031

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'
925: and xte.source_id_int_1 = PL.invoice_id
926: AND pl.invoice_id=ai.invoice_id

Line 942: xla_ae_headers xeh --Bug 4588031

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
943: where xte.entity_code = 'AP_PAYMENTS'
944: and xte.source_id_int_1 = aip.check_id
945: and xte.entity_id = xe.entity_id
946: AND asp.set_of_books_id=xte.ledger_id

Line 2944: xla_ae_headers xeh,

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
2948: where xte.entity_code = 'AP_INVOICES'

Line 2965: , xla_ae_headers xeh

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
2967: WHERE xte.entity_code = 'AP_CHECKS'
2968: and xte.source_id_int_1 = apc.check_id
2969: and PL.invoice_id = aip.invoice_id