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 367: FROM ZX_TAXES_B ztb,

363: fnd_global.user_id , -- LAST_UPDATED_BY
364: SYSDATE , -- LAST_UPDATE_DATE
365: fnd_global.conc_login_id , -- LAST_UPDATE_LOGIN
366: ztb.tax_id
367: FROM ZX_TAXES_B ztb,
368: FND_LANGUAGES fl
369: WHERE fl.INSTALLED_FLAG IN ('I', 'B')
370: AND ztb.TAX_REGIME_CODE = p_tax_regime_code
371: AND ztb.CONTENT_OWNER_ID = -99

Line 3515: ZX_TAXES_B ztb,

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

Line 5105: FROM ZX_TAXES_B tax

5101: )
5102: SELECT tax.TAX_REGIME_CODE TAX_REGIME_CODE,
5103: tax.TAX TAX,
5104: tax.EFFECTIVE_FROM EFFECTIVE_FROM
5105: FROM ZX_TAXES_B tax
5106: WHERE tax.TAX_REGIME_CODE = p_tax_regime_code
5107: AND tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5108: AND NOT EXISTS (SELECT 1 FROM ZX_RATES_B rate
5109: WHERE rate.TAX_RATE_CODE = tax.TAX

Line 5219: UPDATE ZX_TAXES_B_TMP tax

5215:
5216: l_rows_processed := SQL%ROWCOUNT;
5217:
5218: -- make the tax live for processing if there is atleast one rate defined for the tax
5219: UPDATE ZX_TAXES_B_TMP tax
5220: SET tax.LIVE_FOR_PROCESSING_FLAG = 'Y'
5221: WHERE tax.RECORD_TYPE_CODE = G_CREATED_BY_MODULE
5222: AND tax.TAX_REGIME_CODE = p_tax_regime_code
5223: AND EXISTS (SELECT 1