APPS.FII_SIZING_UTIL dependencies on AP_HOLDS_ALL

Line 179: AND ((EXISTS (SELECT 'this invoice is on hold' FROM ap_holds_all ah

175: FROM ap_invoices_all ai
176: WHERE ai.last_update_date between p_from_date and p_to_date
177: AND ai.invoice_type_lookup_code <> 'EXPENSE REPORT'
178: AND ai.cancelled_date IS NULL
179: AND ((EXISTS (SELECT 'this invoice is on hold' FROM ap_holds_all ah
180: WHERE ai.invoice_id = ah.invoice_id
181: AND ai.org_id = ah.org_id
182: AND ah.hold_lookup_code IS NOT NULL
183: AND ah.release_lookup_code IS NULL))

Line 588: FROM ap_holds_all ah

584: p_to_date DATE,
585: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
586: CURSOR c_cnt_rows IS
587: SELECT count(*)
588: FROM ap_holds_all ah
589: WHERE ah.last_update_date BETWEEN p_from_date and p_to_date;
590:
591: BEGIN
592: OPEN c_cnt_rows;