528: -- Bug 4766614
529: -- Added NVL so that when tax_account_ccid is null
530: -- the API returns non_rec_account_ccid
531: FROM zx_rates_b zrb,
532: zx_accounts za
533: WHERE nvl(zrb.source_id, zrb.tax_rate_id) = p_tax_rate_id
534: AND za.internal_organization_id(+) = p_org_id
535: AND za.ledger_id(+) = p_ledger_id
536: AND za.tax_account_entity_id(+) = zrb.tax_rate_id
678: SELECT NVL(tax_account_ccid, non_rec_account_ccid)
679: -- Bug 4766614
680: -- Added NVL so that when tax_account_ccid is null
681: -- the API returns non_rec_account_ccid
682: FROM zx_accounts za, zx_rates_b rates
683: WHERE nvl(rates.source_id, rates.tax_rate_id) = p_tax_rate_id
684: AND za.tax_account_entity_id(+) = rates.tax_rate_id
685: AND za.tax_account_entity_code(+) = 'RATES'
686: AND za.ledger_id(+) = p_ledger_id