[Home] [Help]
APPS.JA_JAINITCP_XMLP_PKG dependencies on JAI_AP_TDS_INVOICES
Line 279: JAI_AP_TDS_INVOICES
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;
Line 325: JAI_AP_TDS_INVOICES
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);