DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_JURISDICTIONS_B

Line 1871: ZX_JURISDICTIONS_B jur

1867: ZX_REGIMES_B regime ,
1868: ZX_TAXES_B tax ,
1869: ZX_STATUS_B status ,
1870: ZX_RATES_B rate ,
1871: ZX_JURISDICTIONS_B jur
1872: WHERE line.APPLICATION_ID = p_transaction_rec.APPLICATION_ID
1873: AND line.ENTITY_CODE = p_transaction_rec.ENTITY_CODE
1874: AND line.EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
1875: AND line.TRX_ID = p_transaction_rec.TRX_ID

Line 6724: FROM zx_jurisdictions_b

6720: l_geography_id := x_geography_id;
6721: BEGIN
6722: SELECT tax_jurisdiction_id
6723: INTO p_tax_jurisdiction_id
6724: FROM zx_jurisdictions_b
6725: WHERE effective_from <= l_trx_date
6726: AND (effective_to >= l_trx_date or effective_to is null)
6727: AND tax = l_tax
6728: AND tax_regime_code = l_tax_regime_code

Line 6773: FROM zx_jurisdictions_b

6769: l_geography_id := l_zone_tbl(j).zone_id;
6770: BEGIN
6771: SELECT tax_jurisdiction_id
6772: INTO p_tax_jurisdiction_id
6773: FROM zx_jurisdictions_b
6774: WHERE effective_from <= l_trx_date
6775: AND (effective_to >= l_trx_date or effective_to is null)
6776: AND tax = l_tax
6777: AND tax_regime_code = l_tax_regime_code