DBA Data[Home] [Help]

APPS.POS_AP_INVOICES_PKG dependencies on AP_HOLDS_ALL

Line 270: from ap_holds_All aha,

266: IS
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

Line 884: from ap_holds_all

880: BEGIN
881:
882: select count(*)
883: into l_count
884: from ap_holds_all
885: where invoice_id = l_invoice_id
886: and release_lookup_code is null;
887:
888: if (l_count > 0) then