APPS.POS_AP_INVOICES_PKG dependencies on AP_INVOICE_PAYMENTS_ALL

Line 647: FROM ap_invoice_payments_all aip,

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

Line 711: FROM ap_invoice_payments_all aip,

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

Line 796: FROM ap_invoice_payments_all aip,

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

Line 806: FROM ap_invoice_payments_all aip,

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