APPS.JG_ZZ_SUMMARY_AR_PKG dependencies on ZX_RATES_B

Line 30: FROM zx_rates_b ZRB

26: END IF;
27:
28: SELECT NVL(ZRB.percentage_rate,ZRB.quantity_rate)
29: INTO l_taxrate
30: FROM zx_rates_b ZRB
31: WHERE ZRB.tax_rate_id = P_TAX_RATE_ID
32: /* UT TEST. these effectivity dates checking is not required for Reporting
33: AND p_a_date >= NVL(ZRB.effective_from, TO_DATE('01-01-1895', 'DD-MM-YYYY'))
34: AND p_a_date <= NVL(ZRB.effective_to, TO_DATE('31-12-2195', 'DD-MM-YYYY')) */

Line 197: FROM zx_rates_b ZRB

193: END IF;
194:
195: SELECT NVL(ZRB.percentage_rate,ZRB.quantity_rate)
196: INTO l_taxrate
197: FROM zx_rates_b ZRB
198: WHERE ZRB.tax_rate_id = P_TAX_RATE_ID
199: AND p_a_date >= NVL(ZRB.effective_from, TO_DATE('01-01-1895', 'DD-MM-YYYY'))
200: AND p_a_date <= NVL(ZRB.effective_to, TO_DATE('31-12-2195', 'DD-MM-YYYY'));
201:

Line 804: zx_rates_b at

800: -1 * round(ac.amount * (1 - 1/(1 + at.PERCENTAGE_RATE/100.0)),2) REV_TAX,
801: aa.cash_receipt_id CASH_RECEIPT_ID
802: FROM ar_cash_receipts_all ac,
803: ar_receivable_applications_all aa,
804: zx_rates_b at
805: WHERE aa.cash_receipt_id = ac.cash_receipt_id
806: AND ac.org_id = aa.org_id
807: AND at.tax_rate_id = ac.vat_tax_id
808: AND ( ( P_REPORTING_LEVEL = 'LE' AND ac.legal_entity_id = P_LEGAL_ENTITY_ID)

Line 860: zx_rates_b at,

856: SUBSTR(csu.location,1,20) LOCATION,
857: at.tax_rate_id TAX_RATE_ID
858: -- ac.RECEIPT_NUMBER
859: FROM ar_receivable_applications_all aa,
860: zx_rates_b at,
861: ar_cash_receipts_all ac,
862: ra_customer_trx tr,
863: hz_cust_accounts rc,
864: hz_parties hzp,

Line 885: FROM zx_rates_b

881:
882: CURSOR get_tax_rate_code(p_tax_rate_id IN NUMBER)
883: IS
884: SELECT tax_rate_code
885: FROM zx_rates_b
886: WHERE tax_rate_id = p_tax_rate_id;
887:
888: --JGZZARVR - ECE Receivables VAT Register Report
889: