APPS.AP_PURGE_PKG dependencies on AP_INVOICE_PREPAYS

Line 871: FROM ap_invoice_prepays IP

867: DELETE
868: FROM ap_purge_invoice_list PL
869: WHERE EXISTS
870: (SELECT 'related to prepayment'
871: FROM ap_invoice_prepays IP
872: WHERE PL.invoice_id = IP.invoice_id
873: OR PL.invoice_id = IP.prepay_id);
874:
875: -- Bug 2153132 by ISartawi add the Delete Statement to exclude

Line 2883: FROM ap_invoice_prepays IP

2879: SET PL.double_check_flag = 'N'
2880: WHERE PL.double_check_flag = 'Y'
2881: AND EXISTS (
2882: SELECT 'recently related to prepayment'
2883: FROM ap_invoice_prepays IP
2884: WHERE PL.invoice_id = IP.invoice_id
2885: OR PL.invoice_id = IP.prepay_id);
2886:
2887: --