[Home] [Help]
3801: FND_FILE.LOG,
3802: 'Creating Tax Accounts for Tax Jurisdictions.'
3803: );
3804:
3805: INSERT INTO ZX_ACCOUNTS
3806: (
3807: TAX_ACCOUNT_ID,
3808: OBJECT_VERSION_NUMBER,
3809: TAX_ACCOUNT_ENTITY_CODE,
3828: LAST_UPDATE_DATE,
3829: LAST_UPDATE_LOGIN
3830: )
3831: SELECT
3832: zx_accounts_s.nextval,
3833: 1,
3834: 'JURISDICTION',
3835: zjb.TAX_JURISDICTION_ID,
3836: za.LEDGER_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
3861: AND NOT EXISTS (SELECT NULL
3867: AND ztb.SOURCE_TAX_FLAG = 'Y'
3868: AND za.TAX_ACCOUNT_ENTITY_CODE = 'TAXES'
3869: AND za.TAX_ACCOUNT_ENTITY_ID = ztb.TAX_ID
3870: AND NOT EXISTS (SELECT 1
3871: FROM ZX_ACCOUNTS
3872: WHERE TAX_ACCOUNT_ENTITY_ID = zjb.TAX_JURISDICTION_ID
3873: AND TAX_ACCOUNT_ENTITY_CODE = 'JURISDICTION'
3874: AND LEDGER_ID = za.LEDGER_ID
3875: AND INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);
5593: FND_FILE.LOG,
5594: 'Creating Tax Accounts for Tax Rates.'
5595: );
5596:
5597: INSERT INTO ZX_ACCOUNTS
5598: (
5599: TAX_ACCOUNT_ID,
5600: OBJECT_VERSION_NUMBER,
5601: TAX_ACCOUNT_ENTITY_CODE,
5620: LAST_UPDATE_DATE,
5621: LAST_UPDATE_LOGIN
5622: )
5623: SELECT
5624: zx_accounts_s.nextval,
5625: 1,
5626: 'RATES',
5627: zrb.TAX_RATE_ID,
5628: za.LEDGER_ID,
5645: sysdate,
5646: fnd_global.conc_login_id
5647: FROM ZX_RATES_B zrb,
5648: ZX_JURISDICTIONS_B zjb,
5649: ZX_ACCOUNTS za
5650: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code
5651: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5652: AND zrb.CONTENT_OWNER_ID = -99
5653: AND zrb.RECORD_TYPE_CODE = G_CREATED_BY_MODULE