DBA Data[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);