APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_CHECKS

Line 469: FROM ap_invoice_payments p, ap_checks c

465: AND p2.payment_num = p1.payment_num
466: AND p2.amount = ( -1 * p1.amount));
467: CURSOR unposted_w_voids IS
468: SELECT 'Has unposted payment that is linked to a voided check'
469: FROM ap_invoice_payments p, ap_checks c
470: WHERE p.invoice_id = X_Invoice_Id
471: AND nvl(p.cash_posted_flag,'N') <> 'Y'
472: AND p.check_id = c.check_id
473: AND c.void_date IS NOT NULL;

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

505: end if;
506: debug_info := 'Close cursor posted_no_voids';
507: CLOSE posted_no_voids;
508:
509: debug_info := 'Select from ap_invoice_payments and ap_checks';
510:
511: OPEN unposted_w_voids;
512: debug_info := 'Fetch cursor unposted_w_voids';
513: FETCH unposted_w_voids INTO dummy;