eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_INVOICE_DISTRIBUTIONS_PKG dependencies on AP_INVOICE_PAYMENTS

Line 466: FROM ap_invoice_payments p1

462: debug_info VARCHAR2(100);
463: l_cash_basis VARCHAR2(1);
464: CURSOR posted_no_voids IS
465: SELECT 'Has posted payment with no corresponding void'
466: FROM ap_invoice_payments p1
467: WHERE p1.invoice_id = X_Invoice_Id
468: AND nvl(p1.cash_posted_flag, 'N') = 'Y'
469: AND NOT EXISTS (SELECT 'This is the void partner'
470: FROM ap_invoice_payments p2

Line 470: FROM ap_invoice_payments p2

466: FROM ap_invoice_payments p1
467: WHERE p1.invoice_id = X_Invoice_Id
468: AND nvl(p1.cash_posted_flag, 'N') = 'Y'
469: AND NOT EXISTS (SELECT 'This is the void partner'
470: FROM ap_invoice_payments p2
471: WHERE p2.invoice_id = p1.invoice_id
472: AND p2.check_id = p1.check_id
473: AND p2.payment_num = p1.payment_num
474: AND p2.amount = ( -1 * p1.amount));

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 504: debug_info := 'Select from ap_invoice_payments';

500: if (l_cash_basis <>'Y') then
501: return(FALSE);
502: end if;
503:
504: debug_info := 'Select from ap_invoice_payments';
505:
506: OPEN posted_no_voids;
507: debug_info := 'Fetch cursor posted_no_voids';
508: FETCH posted_no_voids INTO dummy;

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;

Line 5575: FROM ap_invoice_payments_all aip,

5571: FROM ap_invoice_distributions_all aid
5572: WHERE aid.invoice_id = l_invoice_line_rec.invoice_id
5573: AND aid.accounting_event_id = xe.event_id)
5574: AND NOT EXISTS (SELECT 'No payment rows exist for this event'
5575: FROM ap_invoice_payments_all aip,
5576: ap_payment_history_all aph
5577: WHERE aip.invoice_id = l_invoice_line_rec.invoice_id
5578: AND aip.check_id = aph.check_id
5579: AND aph.accounting_event_id = xe.event_id)