APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_JURISDICTIONS_B

Line 3436: INTO ZX_JURISDICTIONS_B

3432: )
3433: -- Bug 6393452
3434: WHEN (existing_jurisdiction_id IS NULL and CITY_ROW_NUMBER = 1 and existing_zone_geography_id IS NULL
3435: AND existing_tax_rate = 1 AND primary_flag = 'Y') THEN
3436: INTO ZX_JURISDICTIONS_B
3437: (
3438: TAX_JURISDICTION_CODE,
3439: EFFECTIVE_FROM,
3440: EFFECTIVE_TO,

Line 3466: zx_jurisdictions_b_s1.nextval,

3462: tax_regime_code,
3463: tax,
3464: 'N',
3465: G_CREATED_BY_MODULE,
3466: zx_jurisdictions_b_s1.nextval,
3467: zone_geography_id,
3468: inner_city_flag,
3469: precedence_level,
3470: 'Y',

Line 3490: FROM zx_jurisdictions_b j

3486: nvl(v.end_date,to_date('12/31/4712','mm/dd/yyyy')) end_date,
3487: v.country_code,
3488: v.precedence_level,
3489: (SELECT tax_jurisdiction_id
3490: FROM zx_jurisdictions_b j
3491: WHERE j.tax_regime_code = v.tax_regime_code
3492: AND j.tax = v.tax
3493: AND j.tax_jurisdiction_code = v.geo_code) existing_jurisdiction_id,
3494: (SELECT tax_jurisdiction_id

Line 3495: FROM zx_jurisdictions_b j

3491: WHERE j.tax_regime_code = v.tax_regime_code
3492: AND j.tax = v.tax
3493: AND j.tax_jurisdiction_code = v.geo_code) existing_jurisdiction_id,
3494: (SELECT tax_jurisdiction_id
3495: FROM zx_jurisdictions_b j
3496: WHERE j.tax_regime_code = v.tax_regime_code
3497: AND j.tax = v.tax
3498: AND j.zone_geography_id = v.zone_geography_id
3499: AND j.effective_from = DECODE(GREATEST(v.start_date,G_RECORD_EFFECTIVE_START),v.start_date,v.start_date,G_RECORD_EFFECTIVE_START)) existing_zone_geography_id,

Line 3855: FROM ZX_JURISDICTIONS_B zjb,

3851: sysdate,
3852: fnd_global.user_id,
3853: sysdate,
3854: fnd_global.conc_login_id
3855: FROM ZX_JURISDICTIONS_B zjb,
3856: ZX_TAXES_B ztb,
3857: ZX_ACCOUNTS za
3858: WHERE zjb.TAX_REGIME_CODE = p_tax_regime_code
3859: AND zjb.TAX IN ('STATE','COUNTY','CITY')

Line 3941: FROM ZX_JURISDICTIONS_B zjb,

3937: sysdate,
3938: fnd_global.conc_login_id,
3939: fl.LANGUAGE_CODE,
3940: USERENV('LANG')
3941: FROM ZX_JURISDICTIONS_B zjb,
3942: FND_LANGUAGES fl
3943: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
3944: AND zjb.TAX_REGIME_CODE = p_tax_regime_code
3945: AND zjb.TAX IN ('STATE','COUNTY','CITY')

Line 5648: ZX_JURISDICTIONS_B zjb,

5644: fnd_global.user_id,
5645: sysdate,
5646: fnd_global.conc_login_id
5647: FROM ZX_RATES_B zrb,
5648: ZX_JURISDICTIONS_B zjb,
5649: ZX_ACCOUNTS za
5650: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code
5651: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5652: AND zrb.CONTENT_OWNER_ID = -99