APPS.AP_PURGE_PKG dependencies on AP_PAYMENT_SCHEDULES

Line 814: INDEX(i AP_INVOICES_U1) INDEX(ps AP_PAYMENT_SCHEDULES_U1) */

810: DELETE /*+ PARALLEL(pl) ROWID(pl) */
811: FROM ap_purge_invoice_list pl
812: WHERE pl.rowid IN
813: (SELECT /*+ ORDERED PARALLEL(pl1) FULL(pl1) USE_NL(i,ps)
814: INDEX(i AP_INVOICES_U1) INDEX(ps AP_PAYMENT_SCHEDULES_U1) */
815: pl1.rowid
816: FROM ap_purge_invoice_list pl1,
817: ap_invoices i,
818: ap_payment_schedules ps

Line 818: ap_payment_schedules ps

814: INDEX(i AP_INVOICES_U1) INDEX(ps AP_PAYMENT_SCHEDULES_U1) */
815: pl1.rowid
816: FROM ap_purge_invoice_list pl1,
817: ap_invoices i,
818: ap_payment_schedules ps
819: WHERE i.invoice_id = pl1.invoice_id
820: AND ps.invoice_id = i.invoice_id
821: AND ((ps.payment_status_flag <> 'Y' AND i.cancelled_date IS NULL)
822: OR ps.last_update_date > g_activity_date));

Line 3118: FROM ap_payment_schedules PS,

3114: SET PL.double_check_flag = 'N'
3115: WHERE PL.double_check_flag = 'Y'
3116: AND EXISTS (
3117: SELECT /*+NO_UNNEST*/ 'payment schedule no longer purgeable'
3118: FROM ap_payment_schedules PS,
3119: ap_invoices I
3120: WHERE PS.invoice_id = PL.invoice_id
3121: AND PS.invoice_id = I.invoice_id
3122: AND ((PS.payment_status_flag <> 'Y'

Line 5611: debug_info := 'ap_payment_schedules';

5607: PL.rowid BETWEEN p_start_rowid AND p_end_rowid);
5608:
5609: l_invoice_payment_rows := SQL%ROWCOUNT ; -- Bug 8913560
5610:
5611: debug_info := 'ap_payment_schedules';
5612: IF g_debug_switch in ('y','Y') THEN
5613: Print('(Delete_AP_Tables)'||debug_info);
5614: END IF;
5615:

Line 5619: DELETE FROM ap_payment_schedules

5615:
5616:
5617: -- delete_payment_schedules
5618:
5619: DELETE FROM ap_payment_schedules
5620: WHERE invoice_id IN (
5621: SELECT PL.invoice_id
5622: FROM ap_purge_invoice_list PL
5623: WHERE PL.double_check_flag = 'Y'