APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_JURISDICTIONS_B

Line 3132: INTO ZX_JURISDICTIONS_B

3128: )
3129: -- Bug 6393452
3130: WHEN (existing_jurisdiction_id IS NULL and CITY_ROW_NUMBER = 1 and existing_zone_geography_id IS NULL
3131: AND existing_tax_rate = 1) THEN
3132: INTO ZX_JURISDICTIONS_B
3133: (
3134: TAX_JURISDICTION_CODE,
3135: EFFECTIVE_FROM,
3136: EFFECTIVE_TO,

Line 3162: zx_jurisdictions_b_s1.nextval,

3158: tax_regime_code,
3159: tax,
3160: 'N',
3161: G_CREATED_BY_MODULE,
3162: zx_jurisdictions_b_s1.nextval,
3163: zone_geography_id,
3164: inner_city_flag,
3165: precedence_level,
3166: 'Y',

Line 3186: from ZX_JURISDICTIONS_B j

3182: nvl(v.end_date,to_date('12/31/4712','mm/dd/yyyy')) end_date,
3183: v.country_code,
3184: v.precedence_level,
3185: (select tax_jurisdiction_id
3186: from ZX_JURISDICTIONS_B j
3187: where j.tax_regime_code = v.tax_regime_code
3188: and j.tax = v.tax
3189: and j.tax_jurisdiction_code = v.geo_code) existing_jurisdiction_id,
3190: (select tax_jurisdiction_id

Line 3191: from ZX_JURISDICTIONS_B j

3187: where j.tax_regime_code = v.tax_regime_code
3188: and j.tax = v.tax
3189: and j.tax_jurisdiction_code = v.geo_code) existing_jurisdiction_id,
3190: (select tax_jurisdiction_id
3191: from ZX_JURISDICTIONS_B j
3192: where j.tax_regime_code = v.tax_regime_code
3193: and j.tax = v.tax
3194: and j.zone_geography_id = v.zone_geography_id
3195: 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 3514: FROM ZX_JURISDICTIONS_B zjb,

3510: sysdate,
3511: fnd_global.user_id,
3512: sysdate,
3513: fnd_global.conc_login_id
3514: FROM ZX_JURISDICTIONS_B zjb,
3515: ZX_TAXES_B ztb,
3516: ZX_ACCOUNTS za
3517: WHERE zjb.TAX_REGIME_CODE = p_tax_regime_code
3518: AND zjb.TAX IN ('STATE','COUNTY','CITY')

Line 3583: FROM ZX_JURISDICTIONS_B zjb,

3579: sysdate,
3580: fnd_global.conc_login_id,
3581: fl.LANGUAGE_CODE,
3582: USERENV('LANG')
3583: FROM ZX_JURISDICTIONS_B zjb,
3584: FND_LANGUAGES fl
3585: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
3586: AND zjb.TAX_REGIME_CODE = p_tax_regime_code
3587: AND zjb.TAX IN ('STATE','COUNTY','CITY')

Line 5169: ZX_JURISDICTIONS_B zjb,

5165: fnd_global.user_id,
5166: sysdate,
5167: fnd_global.conc_login_id
5168: FROM ZX_RATES_B zrb,
5169: ZX_JURISDICTIONS_B zjb,
5170: ZX_ACCOUNTS za
5171: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code
5172: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5173: AND zrb.CONTENT_OWNER_ID = -99