APPS.AP_INVOICES_UTILITY_PKG dependencies on AP_HOLDS

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

1318: BEGIN
1319:
1320: SELECT COUNT(*)
1321: INTO holds_count
1322: FROM ap_holds
1323: WHERE release_lookup_code is null
1324: AND invoice_id = l_invoice_id;
1325:
1326: RETURN (holds_count);

Line 1603: FROM ap_holds

1599: l_amount VARCHAR2(10) := 'AMOUNT';
1600:
1601: cursor amount_hold_flag_cursor is
1602: SELECT 'Y'
1603: FROM ap_holds
1604: WHERE invoice_id = l_invoice_id
1605: AND hold_lookup_code = l_amount
1606: AND release_lookup_code IS NULL;
1607:

Line 1644: FROM ap_holds

1640: l_vendor_hold_flag VARCHAR2(1) := 'N';
1641:
1642: cursor vendor_hold_flag_cursor is
1643: SELECT 'Y'
1644: FROM ap_holds
1645: WHERE invoice_id = l_invoice_id
1646: AND hold_lookup_code = l_vendor
1647: AND release_lookup_code IS NULL;
1648:

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: