APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_CHECKS

Line 477: FROM ap_invoice_payments p, ap_checks c

473: AND p2.payment_num = p1.payment_num
474: AND p2.amount = ( -1 * p1.amount));
475: CURSOR unposted_w_voids IS
476: SELECT 'Has unposted payment that is linked to a voided check'
477: FROM ap_invoice_payments p, ap_checks c
478: WHERE p.invoice_id = X_Invoice_Id
479: AND nvl(p.cash_posted_flag,'N') <> 'Y'
480: AND p.check_id = c.check_id
481: AND c.void_date IS NOT NULL;

Line 517: debug_info := 'Select from ap_invoice_payments and ap_checks';

513: end if;
514: debug_info := 'Close cursor posted_no_voids';
515: CLOSE posted_no_voids;
516:
517: debug_info := 'Select from ap_invoice_payments and ap_checks';
518:
519: OPEN unposted_w_voids;
520: debug_info := 'Fetch cursor unposted_w_voids';
521: FETCH unposted_w_voids INTO dummy;