DBA Data[Home] [Help]

APPS.ARP_PROCESS_ADJUSTMENT dependencies on ZX_ACCOUNTS

Line 4001: --Bug 10136019. Added condition for zx_accounts.internal_organization_id.

3997: x_effective_date => l_effective_date);
3998:
3999: BEGIN
4000:
4001: --Bug 10136019. Added condition for zx_accounts.internal_organization_id.
4002: SELECT zxr.percentage_rate
4003: INTO l_tax_rate
4004: FROM zx_sco_rates zxr,
4005: zx_accounts zxa

Line 4005: zx_accounts zxa

4001: --Bug 10136019. Added condition for zx_accounts.internal_organization_id.
4002: SELECT zxr.percentage_rate
4003: INTO l_tax_rate
4004: FROM zx_sco_rates zxr,
4005: zx_accounts zxa
4006: WHERE zxa.tax_account_entity_code = 'RATES'
4007: AND zxa.tax_account_entity_id = zxr.tax_rate_id
4008: AND NVL(zxr.tax_class, 'OUTPUT') = 'OUTPUT'
4009: AND zxr.tax_jurisdiction_code is NULL