APPS.POS_AP_INVOICES_PKG dependencies on AP_LOOKUP_CODES

Line 269: ap_lookup_codes alc

265:
266: CURSOR hold_reason_cursor IS
267: SELECT alc.displayed_field
268: from ap_holds_All aha,
269: ap_lookup_codes alc
270: where alc.lookup_type = 'HOLD CODE'
271: and aha.hold_lookup_code = alc.lookup_code (+)
272: and aha.invoice_id = l_invoice_id
273: and aha.release_lookup_code is null

Line 711: --, ap_lookup_codes alc2

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'
715: -- AND alc2.lookup_code = ac.payment_method_lookup_code;

Line 795: ap_lookup_codes alc2

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'
799: AND alc2.lookup_code(+) = ac.payment_method_lookup_code;