APPS.AP_PURGE_PKG dependencies on AP_SYSTEM_PARAMETERS

Line 8: --Introduction of AP_INVOICES_ALL,AP_SYSTEM_PARAMETERS_ALL to force an

4: --This bug mainly solves most of the performance related issues reported
5: --in SQLREP.
6: --There are two kinds of fixes.
7: --NO_UNNEST is used in the inner query to prevent FTS on large tables.
8: --Introduction of AP_INVOICES_ALL,AP_SYSTEM_PARAMETERS_ALL to force an
9: --access path.
10: -- Private Variables
11: -- Declaring the global variables
12: g_debug_switch VARCHAR2(1) := 'N';

Line 159: FROM ap_system_parameters ASP;

155: nvl(ASP.RECON_ACCOUNTING_FLAG,'N')
156: INTO p_using_accrual_basis,
157: p_using_cash_basis,
158: p_recon_acctg_flag
159: FROM ap_system_parameters ASP;
160:
161: --
162: debug_info := 'End Get_Accounting_Method';
163: IF g_debug_switch in ('y','Y') THEN

Line 1083: ap_system_parameters_all asp--bug5052748

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'
1085: and NVL(XTE.SOURCE_ID_INT_1,-99) = PL1.invoice_id --11059839
1086: AND pl1.invoice_id=ai.invoice_id
1087: AND ai.org_id=asp.org_id

Line 1103: ap_system_parameters_all asp,--bug5052478

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
1105: where xte.entity_code = 'AP_PAYMENTS'
1106: and NVL(XTE.SOURCE_ID_INT_1,-99) = aip.check_id --11059839
1107: and xte.entity_id = xe.entity_id

Line 3284: ap_system_parameters_all asp --bug5052748

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
3285: where xte.entity_code = 'AP_INVOICES'
3286: and xte.entity_id = xe.entity_id
3287: and NVL(XTE.SOURCE_ID_INT_1,-99) = PL.invoice_id /* Bug#12615876 */
3288: AND ai.invoice_id=pl.invoice_id

Line 3304: ap_system_parameters_all asp,--bug5052478

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
3306: where xte.entity_code = 'AP_PAYMENTS'
3307: and NVL(XTE.SOURCE_ID_INT_1,-99) = aip.check_id --11059839
3308: and xte.entity_id = xe.entity_id