APPS.AR_RECEIPT_LIB_PVT dependencies on ZX_SCO_RATES

Line 641: from zx_sco_rates

637: end if;
638:
639: SELECT tax_rate_id
640: INTO l_selected_id
641: from zx_sco_rates
642: WHERE tax_rate_code = p_value
643: AND nvl(active_flag, 'Y') = 'Y' /* 4400063 */
644: AND l_date between
645: nvl(effective_from, l_date)

Line 7521: zx_sco_rates vat

7517: SELECT vat.tax_rate_id
7518: INTO p_vat_tax_id
7519: FROM ar_receivables_trx rt,
7520: ar_rec_trx_le_details details,
7521: zx_sco_rates vat
7522: WHERE rt.receivables_trx_id = p_receivables_trx_id
7523: AND rt.receivables_trx_id = details.receivables_trx_id (+)
7524: AND details.legal_entity_id (+) = l_le_id
7525: AND rt.type in ('MISCCASH', 'BANK_ERROR')

Line 7551: zx_sco_rates vat

7547: BEGIN
7548: SELECT vat.tax_rate_id
7549: INTO p_vat_tax_id
7550: FROM ar_receivables_trx rt,
7551: zx_sco_rates vat
7552: WHERE rt.receivables_trx_id = p_receivables_trx_id
7553: AND rt.type in ('MISCCASH', 'BANK_ERROR')
7554: AND nvl(rt.status, 'A') = 'A'
7555: AND vat.tax_rate_code(+) = decode(sign(p_amount),