APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_HOLDS_ALL

Line 526: FROM ap_holds_all

522: -- Get the number of holds for the invoice
523: --
524: SELECT count(*)
525: INTO invoice_holds
526: FROM ap_holds_all
527: WHERE invoice_id = l_invoice_id
528: AND release_lookup_code is NULL;
529:
530: ---------------------------------------------------------------------

Line 539: FROM ap_holds_all

535: --
536: --Bugfix:4539514, added line_variance to the WHERE clause
537: SELECT count(*)
538: INTO dist_var_hold
539: FROM ap_holds_all
540: WHERE invoice_id = l_invoice_id
541: AND hold_lookup_code IN (l_dist_variance, l_line_variance)
542: AND release_lookup_code is NULL;
543:

Line 3574: FROM ap_holds_all

3570: ELSE --- Standard, Credit-Memo or Prepayments
3571:
3572: SELECT count(*)
3573: INTO l_negotiate_lines_count
3574: FROM ap_holds_all
3575: WHERE invoice_id = p_invoice_id
3576: AND wf_status = 'NEGOTIATE'
3577: AND rownum =1;
3578: