APPS.ZX_TAX_CONTENT_UPLOAD dependencies on ZX_TAXES_B

Line 41: FROM ZX_TAXES_B

37: b_tax VARCHAR2,
38: b_content_owner_id NUMBER
39: ) IS
40: SELECT 'Y'
41: FROM ZX_TAXES_B
42: WHERE TAX_REGIME_CODE = b_tax_regime_code
43: AND TAX = b_tax
44: AND CONTENT_OWNER_ID = b_content_owner_id;
45:

Line 116: INSERT INTO ZX_TAXES_B_TMP

112: FND_FILE.LOG,
113: 'Creating Tax: '||l_tax||'.'
114: );
115:
116: INSERT INTO ZX_TAXES_B_TMP
117: (
118: TAX ,
119: EFFECTIVE_FROM ,
120: EFFECTIVE_TO ,

Line 320: zx_taxes_b_s.nextval , -- TAX_ID

316: 'COUNTRY' , -- PARENT_GEOGRAPHY_TYPE
317: 1 , -- PARENT_GEOGRAPHY_ID
318: 'N' , -- ALLOW_MASS_CREATE_FLAG
319: 'P' , -- APPLIED_AMT_HANDLING_FLAG
320: zx_taxes_b_s.nextval , -- TAX_ID
321: -99 , -- CONTENT_OWNER_ID
322: NULL , -- REP_TAX_AUTHORITY_ID
323: NULL , -- COLL_TAX_AUTHORITY_ID
324: NULL , -- THRSHLD_CHK_TMPLT_CODE

Line 379: FROM ZX_TAXES_B ztb,

375: fnd_global.user_id , -- LAST_UPDATED_BY
376: SYSDATE , -- LAST_UPDATE_DATE
377: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
378: ztb.tax_id
379: FROM ZX_TAXES_B ztb,
380: FND_LANGUAGES fl
381: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
382: AND ztb.TAX_REGIME_CODE = p_tax_regime_code
383: AND ztb.CONTENT_OWNER_ID = -99

Line 3856: ZX_TAXES_B ztb,

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')
3860: AND zjb.RECORD_TYPE_CODE = G_CREATED_BY_MODULE

Line 5571: FROM ZX_TAXES_B tax

5567: )
5568: SELECT tax.TAX_REGIME_CODE TAX_REGIME_CODE,
5569: tax.TAX TAX,
5570: tax.EFFECTIVE_FROM EFFECTIVE_FROM
5571: FROM ZX_TAXES_B tax
5572: WHERE tax.TAX_REGIME_CODE = p_tax_regime_code
5573: AND tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5574: AND tax.CONTENT_OWNER_ID = -99 -- Condition Added as a fix for Bug#8286647
5575: AND NOT EXISTS (SELECT 1 FROM ZX_RATES_B rate

Line 5716: UPDATE ZX_TAXES_B_TMP tax

5712:
5713: l_rows_processed := SQL%ROWCOUNT;
5714:
5715: -- make the tax live for processing if there is atleast one rate defined for the tax
5716: UPDATE ZX_TAXES_B_TMP tax
5717: SET tax.LIVE_FOR_PROCESSING_FLAG = 'Y'
5718: WHERE tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5719: AND tax.TAX_REGIME_CODE = p_tax_regime_code
5720: AND tax.CONTENT_OWNER_ID = -99 -- Condition Added as a fix for Bug#8286647