DBA Data[Home] [Help]

APPS.POS_AP_INVOICES_PKG dependencies on AP_HOLDS_ALL

Line 268: from ap_holds_All aha,

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

Line 878: from ap_holds_all

874: BEGIN
875:
876: select count(*)
877: into l_count
878: from ap_holds_all
879: where invoice_id = l_invoice_id
880: and release_lookup_code is null;
881:
882: if (l_count > 0) then