APPS.AP_PURGE_PKG dependencies on AP_INVOICE_PREPAYS

Line 1027: FROM ap_invoice_prepays IP

1023: DELETE
1024: FROM ap_purge_invoice_list PL
1025: WHERE EXISTS
1026: (SELECT /*+ no_unnest */ 'related to prepayment' -- 7759218
1027: FROM ap_invoice_prepays IP
1028: WHERE PL.invoice_id = IP.invoice_id
1029: OR PL.invoice_id = IP.prepay_id);
1030:
1031: -- Bug 2153132 by ISartawi add the Delete Statement to exclude

Line 3220: FROM ap_invoice_prepays IP

3216: SET PL.double_check_flag = 'N'
3217: WHERE PL.double_check_flag = 'Y'
3218: AND EXISTS (
3219: SELECT 'recently related to prepayment'
3220: FROM ap_invoice_prepays IP
3221: WHERE PL.invoice_id = IP.invoice_id
3222: OR PL.invoice_id = IP.prepay_id);
3223:
3224: --