[Home] [Help]
3465: WHERE a.threshold_grp_id = c_threshold_grp_id
3466: AND a.tds_event = 'INVOICE VALIDATE'
3467: AND a.taxable_amount >= c_single_threshold_amt
3468: AND NOT EXISTS (SELECT '1'
3469: FROM jai_ap_tds_inv_cancels b
3470: WHERE a.invoice_id = b.invoice_id);
3471:
3472: CURSOR c_prepayments(c_threshold_grp_id NUMBER)
3473: IS