APPS.POS_AP_INVOICES_PKG dependencies on AP_LOOKUP_CODES

Line 271: ap_lookup_codes alc

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

Line 713: --, ap_lookup_codes alc2

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;
716: -- AND alc2.lookup_type = 'PAYMENT METHOD'
717: -- AND alc2.lookup_code = ac.payment_method_lookup_code;

Line 798: ap_lookup_codes alc2

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
801: AND alc2.lookup_type(+) = 'PAYMENT METHOD'
802: AND alc2.lookup_code(+) = ac.payment_method_lookup_code;