APPS.AR_BPA_UTILS_PKG dependencies on ZX_RATES_VL

Line 255: zx_rates_vl v

251: FUNCTION fn_get_line_taxname( p_customer_trx_line_id IN number ) return varchar2 AS
252: cursor c_linetax is
253: SELECT v.tax_rate_name as printed_tax_name
254: from ra_customer_trx_lines ctl,
255: zx_rates_vl v
256: where
257: ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
258: and ctl.line_type = 'TAX'
259: and ctl.vat_tax_id = v.tax_rate_id(+)

Line 281: zx_rates_vl v

277: FUNCTION fn_get_line_taxcode( p_customer_trx_line_id IN number ) return varchar2 AS
278: cursor c_linetax is
279: SELECT v.tax_rate_code as tax_code
280: from ra_customer_trx_lines ctl,
281: zx_rates_vl v
282: where
283: ctl.link_to_cust_trx_line_id = p_customer_trx_line_id
284: and ctl.line_type = 'TAX'
285: and ctl.vat_tax_id = v.tax_rate_id(+)

Line 363: zx_rates_vl v

359:
360: cursor c_linetax (id number) is
361: SELECT v.tax_rate_name as printed_tax_name
362: from ra_customer_trx_lines ctl,
363: zx_rates_vl v
364: where
365: ctl.link_to_cust_trx_line_id = id
366: and ctl.line_type = 'TAX'
367: and ctl.vat_tax_id = v.tax_rate_id(+)

Line 411: zx_rates_vl v

407:
408: cursor c_linetax (id number) is
409: SELECT v.tax_rate_code as tax_code
410: from ra_customer_trx_lines ctl,
411: zx_rates_vl v
412: where
413: ctl.link_to_cust_trx_line_id = id
414: and ctl.line_type = 'TAX'
415: and ctl.vat_tax_id = v.tax_rate_id(+)

Line 618: from zx_taxes_vl t,zx_rates_vl r

614: e varchar2(240);
615:
616: cursor tax_type_c( id in number ) is
617: select t.tax_type_code,t.compounding_precedence
618: from zx_taxes_vl t,zx_rates_vl r
619: where t.tax_regime_code = r.tax_regime_code
620: and t.tax = r.tax
621: and r.tax_rate_id = id;
622:

Line 624: select tax_rate_code as tax_code, tax_rate_name as printed_tax_name from zx_rates_vl where tax_rate_id = id;

620: and t.tax = r.tax
621: and r.tax_rate_id = id;
622:
623: cursor vat_tax_c( id in number ) is
624: select tax_rate_code as tax_code, tax_rate_name as printed_tax_name from zx_rates_vl where tax_rate_id = id;
625:
626: cursor exem_c( id in number ) is
627: select
628: decode(nvl(product_id,-999),-999,'CUSTOMER','ITEM') as exemption_type,