APPS.AP_PURGE_PKG dependencies on AP_PAYMENT_HISTORY

Line 900: , ap_payment_history aph

896: DELETE FROM ap_purge_invoice_list PL
897: where EXISTS(
898: select 'history not purgeable'
899: from ap_invoice_payments aip
900: , ap_payment_history aph
901: where aip.invoice_id = PL.invoice_id
902: and aip.check_id = aph.check_id
903: -- To check for posted_flag added for bug#2274656
904: and nvl(aph.posted_flag,'N') <> 'Y'

Line 3368: debug_info := 'ap_payment_history';

3364: -- INTO fp_chrg_allocation_rows
3365: -- FROM ap_chrg_allocations;
3366:
3367: --
3368: debug_info := 'ap_payment_history';
3369: IF g_debug_switch in ('y','Y') THEN
3370: Print('(Count_Accounting_Rows)'||debug_info);
3371: END IF;
3372:

Line 3376: FROM ap_payment_history;

3372:
3373: --
3374: SELECT count(*)
3375: INTO fp_payment_history_rows
3376: FROM ap_payment_history;
3377:
3378: --
3379: debug_info := 'ap_encumbrance_lines';
3380: IF g_debug_switch in ('y','Y') THEN

Line 4048: ap_payment_history = fp_payment_history_rows,

4044: ap_ae_lines = fp_ae_line_rows,
4045: ap_ae_headers = fp_ae_header_rows,
4046: ap_accounting_events = fp_accounting_event_rows,
4047: ap_chrg_allocations = fp_chrg_allocation_rows,
4048: ap_payment_history = fp_payment_history_rows,
4049: ap_encumbrance_lines = fp_encumbrance_line_rows,
4050: rcv_subledger_details = fp_rcv_subledger_detail_rows
4051: WHERE purge_name = fp_purge_name ;
4052:

Line 4066: , ap_payment_history aph

4062: SET PL.double_check_flag = 'N'
4063: WHERE EXISTS (
4064: SELECT 'history not purgeable'
4065: FROM ap_invoice_payments aip
4066: , ap_payment_history aph
4067: WHERE aip.invoice_id = PL.invoice_id
4068: and aip.check_id = aph.check_id
4069: and aph.last_update_date > g_activity_date);
4070:

Line 4947: l_payment_history_id ap_payment_history.payment_history_id%TYPE;

4943:
4944: l_invoice_id ap_invoices.invoice_id%TYPE;
4945: l_invoice_dist_id ap_invoice_distributions.invoice_distribution_id%TYPE;
4946: l_check_id ap_checks.check_id%TYPE;
4947: l_payment_history_id ap_payment_history.payment_history_id%TYPE;
4948: l_invoice_payment_id ap_invoice_payments.invoice_payment_id%TYPE;
4949:
4950: BEGIN
4951:

Line 5066: debug_info := 'ap_payment_history';

5062: Print('Setup_Spoil failed!');
5063: RETURN(FALSE);
5064: end if;
5065:
5066: debug_info := 'ap_payment_history';
5067: IF g_debug_switch in ('y','Y') THEN
5068: Print('(Delete_AP_Tables)'||debug_info);
5069: END IF;
5070:

Line 5072: DELETE FROM ap_payment_history aph

5068: Print('(Delete_AP_Tables)'||debug_info);
5069: END IF;
5070:
5071:
5072: DELETE FROM ap_payment_history aph
5073: WHERE EXISTS (
5074: SELECT 'history purgeable'
5075: FROM ap_invoice_payments aip
5076: , ap_purge_invoice_list PL

Line 5479: AP_PAYMENT_HISTORY APH

5475: DELETE FROM AP_ACCOUNTING_EVENTS AAE WHERE
5476: AAE.source_id IN ( SELECT APH.CHECK_ID
5477: FROM AP_PURGE_INVOICE_LIST PIL,
5478: AP_INVOICE_PAYMENTS AIP,
5479: AP_PAYMENT_HISTORY APH
5480: WHERE PIL.DOUBLE_CHECK_FLAG = 'Y'
5481: AND APH.CHECK_ID = AIP.CHECK_ID
5482: AND AIP.INVOICE_ID = PIL.INVOICE_ID
5483: AND PIL.INVOICE_ID BETWEEN range_low

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

5481: AND APH.CHECK_ID = AIP.CHECK_ID
5482: AND AIP.INVOICE_ID = PIL.INVOICE_ID
5483: AND PIL.INVOICE_ID BETWEEN range_low
5484: AND range_high )
5485: and AAE.SOURCE_TABLE = 'AP_PAYMENT_HISTORY' ;
5486: */--Bug 4588031
5487:
5488: COMMIT;
5489: