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