APPS.PO_MULTI_MOD_VALIDATIONS dependencies on AP_PAYMENT_SCHEDULES_ALL

Line 3978: FROM ap_payment_schedules_all

3974: d_position := 10;
3975: BEGIN
3976: SELECT 'N'
3977: INTO l_unpaid_invoices_exists
3978: FROM ap_payment_schedules_all
3979: WHERE invoice_id = p_invoice_id
3980: AND amount_remaining = 0
3981: AND payment_status_flag = 'Y';
3982: EXCEPTION

Line 4347: ,ap_payment_schedules_all apps

4343: BEGIN
4344: SELECT ap.invoice_id,ap.invoice_num, ap.invoice_date
4345: BULK COLLECT INTO x_invoice_id_tbl, x_invoice_num_tbl, x_invoice_date_tbl
4346: FROM ap_invoices_all ap
4347: ,ap_payment_schedules_all apps
4348: WHERE ap.invoice_id = apps.invoice_id
4349: AND NVL(ap.invoice_amount,0) <> NVL(ap.amount_paid,0)
4350: AND NVL(apps.amount_remaining,0) <> 0
4351: AND apps.payment_status_flag <> 'Y'