APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_HOLDS

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 1394: FROM ap_holds

1390: BEGIN
1391:
1392: SELECT COUNT(*)
1393: INTO holds_count
1394: FROM ap_holds
1395: WHERE release_lookup_code is null
1396: AND invoice_id = l_invoice_id;
1397:
1398: RETURN (holds_count);

Line 1675: FROM ap_holds

1671: l_amount VARCHAR2(10) := 'AMOUNT';
1672:
1673: cursor amount_hold_flag_cursor is
1674: SELECT 'Y'
1675: FROM ap_holds
1676: WHERE invoice_id = l_invoice_id
1677: AND hold_lookup_code = l_amount
1678: AND release_lookup_code IS NULL;
1679:

Line 1716: FROM ap_holds

1712: l_vendor_hold_flag VARCHAR2(1) := 'N';
1713:
1714: cursor vendor_hold_flag_cursor is
1715: SELECT 'Y'
1716: FROM ap_holds
1717: WHERE invoice_id = l_invoice_id
1718: AND hold_lookup_code = l_vendor
1719: AND release_lookup_code IS NULL;
1720:

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: