APPS.POS_AP_INVOICES_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 645: FROM ap_invoice_payments_all aip,

641: cursor payment_cursor_new is
642: SELECT ac.check_number,
643: ac.check_id,
644: ac.check_Date
645: FROM ap_invoice_payments_all aip,
646: ap_checks_all ac
647: WHERE aip.invoice_id = l_invoice_id
648: AND aip.check_id = ac.check_id;
649:

Line 709: FROM ap_invoice_payments_all aip,

705: SELECT distinct ac.check_number,
706: ac.check_id,
707: ac.check_Date
708: --, alc2.displayed_field
709: FROM ap_invoice_payments_all aip,
710: ap_checks_all ac
711: --, ap_lookup_codes alc2
712: WHERE aip.invoice_id = l_invoice_id
713: AND aip.check_id = ac.check_id;

Line 793: FROM ap_invoice_payments_all aip,

789: SELECT distinct ac.check_number,
790: ac.check_id,
791: -- ac.check_Date,
792: alc2.displayed_field
793: FROM ap_invoice_payments_all aip,
794: ap_checks_all ac,
795: ap_lookup_codes alc2
796: WHERE aip.invoice_id = l_invoice_id
797: AND aip.check_id = ac.check_id

Line 803: FROM ap_invoice_payments_all aip,

799: AND alc2.lookup_code(+) = ac.payment_method_lookup_code;
800:
801: cursor paymentdate_cursor_new is
802: SELECT distinct ac.check_Date
803: FROM ap_invoice_payments_all aip,
804: ap_checks_all ac
805: WHERE aip.invoice_id = l_invoice_id
806: AND aip.check_id = ac.check_id;
807: