APPS.FII_SIZING_UTIL dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 184: OR (EXISTS (SELECT 'this invoice has payment schedule hold' FROM ap_payment_schedules_all aps

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))
184: OR (EXISTS (SELECT 'this invoice has payment schedule hold' FROM ap_payment_schedules_all aps
185: WHERE ai.invoice_id = aps.invoice_id
186: AND ai.org_id = aps.org_id
187: AND NVL(aps.hold_flag, 'N') = 'Y')));
188: BEGIN

Line 544: FROM ap_payment_schedules_all aps

540: p_to_date DATE,
541: p_num_rows OUT NOCOPY /* file.sql.39 change */ NUMBER) IS
542: CURSOR c_cnt_rows IS
543: SELECT count(*) cnt
544: FROM ap_payment_schedules_all aps
545: WHERE aps.last_update_date BETWEEN p_from_date and p_to_date;
546:
547: BEGIN
548: OPEN c_cnt_rows;