APPS.AP_PURGE_PKG dependencies on AP_PAYMENT_HISTORY

Line 1056: , ap_payment_history aph

1052: DELETE FROM ap_purge_invoice_list PL
1053: where EXISTS(
1054: select 'history not purgeable'
1055: from ap_invoice_payments aip
1056: , ap_payment_history aph
1057: where aip.invoice_id = PL.invoice_id
1058: and aip.check_id = aph.check_id
1059: -- To check for posted_flag added for bug#2274656
1060: and nvl(aph.posted_flag,'N') <> 'Y'

Line 3872: debug_info := 'ap_payment_history';

3868: -- INTO fp_chrg_allocation_rows
3869: -- FROM ap_chrg_allocations;
3870:
3871: --
3872: debug_info := 'ap_payment_history';
3873: IF g_debug_switch in ('y','Y') THEN
3874: Print('(Count_Accounting_Rows)'||debug_info);
3875: END IF;
3876:

Line 3880: FROM ap_payment_history;

3876:
3877: --
3878: SELECT count(*)
3879: INTO fp_payment_history_rows
3880: FROM ap_payment_history;
3881:
3882: --
3883: debug_info := 'ap_encumbrance_lines';
3884: IF g_debug_switch in ('y','Y') THEN

Line 4552: ap_payment_history = fp_payment_history_rows,

4548: ap_ae_lines = fp_ae_line_rows,
4549: ap_ae_headers = fp_ae_header_rows,
4550: ap_accounting_events = fp_accounting_event_rows,
4551: ap_chrg_allocations = fp_chrg_allocation_rows,
4552: ap_payment_history = fp_payment_history_rows,
4553: ap_encumbrance_lines = fp_encumbrance_line_rows,
4554: rcv_subledger_details = fp_rcv_subledger_detail_rows
4555: WHERE purge_name = fp_purge_name ;
4556:

Line 4570: , ap_payment_history aph

4566: SET PL.double_check_flag = 'N'
4567: WHERE EXISTS (
4568: SELECT 'history not purgeable'
4569: FROM ap_invoice_payments aip
4570: , ap_payment_history aph
4571: WHERE aip.invoice_id = PL.invoice_id
4572: and aip.check_id = aph.check_id
4573: and aph.last_update_date > g_activity_date);
4574:

Line 5443: l_payment_history_id ap_payment_history.payment_history_id%TYPE;

5439:
5440: l_invoice_id ap_invoices.invoice_id%TYPE;
5441: l_invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
5442: l_check_id ap_checks.check_id%TYPE;
5443: l_payment_history_id ap_payment_history.payment_history_id%TYPE;
5444: l_invoice_payment_id ap_invoice_payments.invoice_payment_id%TYPE;
5445:
5446: -- Bug 8913560 : Added the 3 variables given below
5447: l_check_rows NUMBER ;

Line 5577: debug_info := 'ap_payment_history';

5573: Print('Setup_Spoil failed!');
5574: RETURN(FALSE);
5575: end if;
5576:
5577: debug_info := 'ap_payment_history';
5578: IF g_debug_switch in ('y','Y') THEN
5579: Print('(Delete_AP_Tables)'||debug_info);
5580: END IF;
5581:

Line 5583: DELETE FROM ap_payment_history aph

5579: Print('(Delete_AP_Tables)'||debug_info);
5580: END IF;
5581:
5582:
5583: DELETE FROM ap_payment_history aph
5584: WHERE EXISTS (
5585: SELECT 'history purgeable'
5586: FROM ap_invoice_payments aip
5587: , ap_purge_invoice_list PL

Line 6039: AP_PAYMENT_HISTORY APH

6035: DELETE FROM AP_ACCOUNTING_EVENTS AAE WHERE
6036: AAE.source_id IN ( SELECT APH.CHECK_ID
6037: FROM AP_PURGE_INVOICE_LIST PIL,
6038: AP_INVOICE_PAYMENTS AIP,
6039: AP_PAYMENT_HISTORY APH
6040: WHERE PIL.DOUBLE_CHECK_FLAG = 'Y'
6041: AND APH.CHECK_ID = AIP.CHECK_ID
6042: AND AIP.INVOICE_ID = PIL.INVOICE_ID
6043: AND PIL.INVOICE_ID BETWEEN range_low

Line 6045: and AAE.SOURCE_TABLE = 'AP_PAYMENT_HISTORY' ;

6041: AND APH.CHECK_ID = AIP.CHECK_ID
6042: AND AIP.INVOICE_ID = PIL.INVOICE_ID
6043: AND PIL.INVOICE_ID BETWEEN range_low
6044: AND range_high )
6045: and AAE.SOURCE_TABLE = 'AP_PAYMENT_HISTORY' ;
6046: */--Bug 4588031
6047: /* Bug 8913560
6048: COMMIT;
6049: