APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_HOLDS_ALL

Line 634: FROM ap_holds_all

630: -- Get the number of holds for the invoice
631: --
632: SELECT count(*)
633: INTO invoice_holds
634: FROM ap_holds_all
635: WHERE invoice_id = l_invoice_id
636: AND release_lookup_code is NULL;
637:
638: ---------------------------------------------------------------------

Line 647: FROM ap_holds_all

643: --
644: --Bugfix:4539514, added line_variance to the WHERE clause
645: SELECT count(*)
646: INTO dist_var_hold
647: FROM ap_holds_all
648: WHERE invoice_id = l_invoice_id
649: AND hold_lookup_code IN (l_dist_variance, l_line_variance)
650: AND release_lookup_code is NULL;
651:

Line 3652: FROM ap_holds_all

3648: ELSE --- Standard, Credit-Memo or Prepayments
3649:
3650: SELECT count(*)
3651: INTO l_negotiate_lines_count
3652: FROM ap_holds_all
3653: WHERE invoice_id = p_invoice_id
3654: AND wf_status = 'NEGOTIATE'
3655: AND rownum =1;
3656: