APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_JURISDICTIONS_TL

Line 3862: FROM ZX_JURISDICTIONS_TL zjt

3858: WHERE zjb.TAX_REGIME_CODE = p_tax_regime_code
3859: AND zjb.TAX IN ('STATE','COUNTY','CITY')
3860: AND zjb.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
3861: AND NOT EXISTS (SELECT NULL
3862: FROM ZX_JURISDICTIONS_TL zjt
3863: WHERE zjt.TAX_JURISDICTION_ID = zjb.TAX_JURISDICTION_ID)
3864: AND ztb.TAX_REGIME_CODE = zjb.TAX_REGIME_CODE
3865: AND ztb.TAX = zjb.TAX
3866: AND ztb.CONTENT_OWNER_ID = -99 -- Added the condition for Bug#12716747 --

Line 3889: INSERT INTO ZX_JURISDICTIONS_TL

3885: FND_FILE.LOG,
3886: 'Creating TL for Tax Jurisdictions.'
3887: );
3888:
3889: INSERT INTO ZX_JURISDICTIONS_TL
3890: (
3891: TAX_JURISDICTION_ID,
3892: TAX_JURISDICTION_NAME,
3893: CREATED_BY,

Line 3947: FROM ZX_JURISDICTIONS_TL zjt

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')
3946: AND NOT EXISTS (SELECT NULL
3947: FROM ZX_JURISDICTIONS_TL zjt
3948: WHERE zjt.TAX_JURISDICTION_ID = zjb.TAX_JURISDICTION_ID
3949: AND zjt.LANGUAGE = fl.LANGUAGE_CODE);
3950:
3951: l_rows_processed := SQL%ROWCOUNT;