DBA Data[Home] [Help]

APPS.ZX_TRD_SERVICES_PUB_PKG dependencies on ZX_JURISDICTIONS_B

Line 1837: ZX_JURISDICTIONS_B jur

1833: ZX_REGIMES_B regime ,
1834: ZX_TAXES_B tax ,
1835: ZX_STATUS_B status ,
1836: ZX_RATES_B rate ,
1837: ZX_JURISDICTIONS_B jur
1838: WHERE line.APPLICATION_ID = p_transaction_rec.APPLICATION_ID
1839: AND line.ENTITY_CODE = p_transaction_rec.ENTITY_CODE
1840: AND line.EVENT_CLASS_CODE = p_transaction_rec.EVENT_CLASS_CODE
1841: AND line.TRX_ID = p_transaction_rec.TRX_ID

Line 6321: FROM zx_jurisdictions_b

6317: l_geography_id := l_zone_tbl(j).zone_id;
6318: BEGIN
6319: SELECT tax_jurisdiction_id
6320: INTO p_tax_jurisdiction_id
6321: FROM zx_jurisdictions_b
6322: WHERE effective_from <= l_trx_date
6323: AND (effective_to >= l_trx_date or effective_to is null)
6324: AND tax = l_tax
6325: AND tax_regime_code = l_tax_regime_code

Line 6342: FROM zx_jurisdictions_b

6338: l_geography_id := x_geography_id;
6339: BEGIN
6340: SELECT tax_jurisdiction_id
6341: INTO p_tax_jurisdiction_id
6342: FROM zx_jurisdictions_b
6343: WHERE effective_from <= l_trx_date
6344: AND (effective_to >= l_trx_date or effective_to is null)
6345: AND tax = l_tax
6346: AND tax_regime_code = l_tax_regime_code