DBA Data[Home] [Help]

APPS.JL_JLCOPWHR_XMLP_PKG dependencies on AP_TAX_CODES

Line 55: AP_TAX_CODES ATC,

51: ROUND(SUM((AID.AMOUNT * ATC2.TAX_RATE) / 100)
52: ,P_MIN_PRECISION) VAT_AMOUNT
53: INTO V_VAT_AMOUNT
54: FROM
55: AP_TAX_CODES ATC,
56: JL_ZZ_AP_SUP_AWT_CD JZSAC,
57: JL_ZZ_AP_INV_DIS_WH JZIDW,
58: AP_TAX_CODES ATC2,
59: AP_INVOICES AI,

Line 58: AP_TAX_CODES ATC2,

54: FROM
55: AP_TAX_CODES ATC,
56: JL_ZZ_AP_SUP_AWT_CD JZSAC,
57: JL_ZZ_AP_INV_DIS_WH JZIDW,
58: AP_TAX_CODES ATC2,
59: AP_INVOICES AI,
60: AP_INVOICE_DISTRIBUTIONS AID
61: WHERE AID.ACCOUNTING_DATE BETWEEN P_ACCOUNTING_DATE_FROM
62: AND P_ACCOUNTING_DATE_TO