DBA Data[Home] [Help]

APPS.ZX_GL_TAX_OPTIONS_PKG dependencies on ZX_ACCOUNTS

Line 532: zx_accounts za

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 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

Line 681: FROM zx_accounts za, zx_rates_b rates

677: SELECT NVL(tax_account_ccid, non_rec_account_ccid)
678: -- Bug 4766614
679: -- Added NVL so that when tax_account_ccid is null
680: -- the API returns non_rec_account_ccid
681: FROM zx_accounts za, zx_rates_b rates
682: WHERE rates.tax_rate_id = p_tax_rate_id
683: AND za.tax_account_entity_id(+) = rates.tax_rate_id
684: AND za.tax_account_entity_code(+) = 'RATES'
685: AND za.ledger_id(+) = p_ledger_id