APPS.AR_RECEIPT_LIB_PVT dependencies on ZX_SCO_RATES

Line 638: from zx_sco_rates

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

Line 7225: zx_sco_rates vat

7221: SELECT vat.tax_rate_id
7222: INTO p_vat_tax_id
7223: FROM ar_receivables_trx rt,
7224: ar_rec_trx_le_details details,
7225: zx_sco_rates vat
7226: WHERE rt.receivables_trx_id = p_receivables_trx_id
7227: AND rt.receivables_trx_id = details.receivables_trx_id (+)
7228: AND details.legal_entity_id (+) = l_le_id
7229: AND rt.type in ('MISCCASH', 'BANK_ERROR')

Line 7254: zx_sco_rates vat

7250: BEGIN
7251: SELECT vat.tax_rate_id
7252: INTO p_vat_tax_id
7253: FROM ar_receivables_trx rt,
7254: zx_sco_rates vat
7255: WHERE rt.receivables_trx_id = p_receivables_trx_id
7256: AND rt.type in ('MISCCASH', 'BANK_ERROR')
7257: AND nvl(rt.status, 'A') = 'A'
7258: AND vat.tax_rate_code(+) = decode(sign(p_amount),