DBA Data[Home] [Help]

APPS.POS_AP_INVOICES_PKG dependencies on AP_CHECKS_ALL

Line 646: ap_checks_all ac

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:
650: BEGIN

Line 710: ap_checks_all ac

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;
714: -- AND alc2.lookup_type = 'PAYMENT METHOD'

Line 794: ap_checks_all ac,

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
798: AND alc2.lookup_type(+) = 'PAYMENT METHOD'

Line 804: ap_checks_all ac

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:
808: