APPS.JA_JAINITCP_XMLP_PKG dependencies on JAI_AP_TDS_F16_DTLS_ALL

Line 47: JAI_AP_TDS_F16_DTLS_ALL FRMD,

43: MIN(API2.INVOICE_DATE)
44: INTO P_FROM_DATE_T
45: FROM
46: JAI_AP_TDS_F16_HDRS_ALL AFRM,
47: JAI_AP_TDS_F16_DTLS_ALL FRMD,
48: HR_ORGANIZATION_UNITS HOU,
49: HR_LOCATIONS LOC,
50: JAI_CMN_INVENTORY_ORGS JHOU,
51: AP_INVOICES_ALL API1,

Line 270: JAI_AP_TDS_F16_DTLS_ALL JA

266: WHERE exists (
267: SELECT
268: 1
269: FROM
270: JAI_AP_TDS_F16_DTLS_ALL JA
271: WHERE JA.INVOICE_ID = APD2.INVOICE_ID ) );
272: V_PREPAYMENT_AMOUNT NUMBER;
273: V_TDS_TAX_RATE NUMBER;
274: CURSOR C_RTN_AMOUNT(P_INVOICE_ID IN NUMBER) IS

Line 316: JAI_AP_TDS_F16_DTLS_ALL JA

312: WHERE exists (
313: SELECT
314: 1
315: FROM
316: JAI_AP_TDS_F16_DTLS_ALL JA
317: WHERE JA.INVOICE_ID = APD2.INVOICE_ID ) );
318: V_PREPAYMENT_AMOUNT NUMBER;
319: V_INV_AMOUNT NUMBER;
320: CURSOR C_RTN_BASE_AMOUNT(P_INVOICE_ID IN NUMBER) IS