APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_JURISDICTIONS_TL

Line 3521: FROM ZX_JURISDICTIONS_TL zjt

3517: WHERE zjb.TAX_REGIME_CODE = p_tax_regime_code
3518: AND zjb.TAX IN ('STATE','COUNTY','CITY')
3519: AND zjb.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
3520: AND NOT EXISTS (SELECT NULL
3521: FROM ZX_JURISDICTIONS_TL zjt
3522: WHERE zjt.TAX_JURISDICTION_ID = zjb.TAX_JURISDICTION_ID)
3523: AND ztb.TAX_REGIME_CODE = zjb.TAX_REGIME_CODE
3524: AND ztb.TAX = zjb.TAX
3525: AND ztb.SOURCE_TAX_FLAG = 'Y'

Line 3535: INSERT INTO ZX_JURISDICTIONS_TL

3531: AND TAX_ACCOUNT_ENTITY_CODE = 'JURISDICTION'
3532: AND LEDGER_ID = za.LEDGER_ID
3533: AND INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);
3534:
3535: INSERT INTO ZX_JURISDICTIONS_TL
3536: (
3537: TAX_JURISDICTION_ID,
3538: TAX_JURISDICTION_NAME,
3539: CREATED_BY,

Line 3589: FROM ZX_JURISDICTIONS_TL zjt

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')
3588: AND NOT EXISTS (SELECT NULL
3589: FROM ZX_JURISDICTIONS_TL zjt
3590: WHERE zjt.TAX_JURISDICTION_ID = zjb.TAX_JURISDICTION_ID
3591: AND zjt.LANGUAGE = fl.LANGUAGE_CODE);
3592:
3593: l_rows_processed := SQL%ROWCOUNT;