[Home] [Help]
275: SELECT
276: NVL(AMT_REVERSED
277: ,0)
278: FROM
279: JAI_AP_TDS_INVOICES
280: WHERE INVOICE_ID = P_INVOICE_ID;
281: V_RTN_AMOUNT NUMBER;
282: BEGIN
283: V_TDS_TAX_RATE := TAX_RATE - SURCHARGE_RATE;
321: SELECT
322: NVL(AMT_APPLIED
323: ,0)
324: FROM
325: JAI_AP_TDS_INVOICES
326: WHERE INVOICE_ID = P_INVOICE_ID;
327: V_RTN_BASE_AMOUNT NUMBER;
328: BEGIN
329: OPEN C_RTN_BASE_AMOUNT(INVOICE_ID_v);