[Home] [Help]
3460:
3461: -- Copy accounts from taxes
3462: -- Do this only for newly created jurisdicition
3463: -- Use TL table and regime/tax/record type combination to find new ones
3464: INSERT INTO ZX_ACCOUNTS
3465: (
3466: TAX_ACCOUNT_ID,
3467: OBJECT_VERSION_NUMBER,
3468: TAX_ACCOUNT_ENTITY_CODE,
3487: LAST_UPDATE_DATE,
3488: LAST_UPDATE_LOGIN
3489: )
3490: SELECT
3491: zx_accounts_s.nextval,
3492: 1,
3493: 'JURISDICTION',
3494: zjb.TAX_JURISDICTION_ID,
3495: za.LEDGER_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
3520: AND NOT EXISTS (SELECT NULL
3525: AND ztb.SOURCE_TAX_FLAG = 'Y'
3526: AND za.TAX_ACCOUNT_ENTITY_CODE = 'TAXES'
3527: AND za.TAX_ACCOUNT_ENTITY_ID = ztb.TAX_ID
3528: AND NOT EXISTS (SELECT 1
3529: FROM ZX_ACCOUNTS
3530: WHERE TAX_ACCOUNT_ENTITY_ID = zjb.TAX_JURISDICTION_ID
3531: AND TAX_ACCOUNT_ENTITY_CODE = 'JURISDICTION'
3532: AND LEDGER_ID = za.LEDGER_ID
3533: AND INTERNAL_ORGANIZATION_ID = za.INTERNAL_ORGANIZATION_ID);
5114:
5115: -- Copy accounts from jurisdiction
5116: -- Do this only for newly created rates
5117: -- Use TL table and regime/tax/record type combination to find new ones
5118: INSERT INTO ZX_ACCOUNTS
5119: (
5120: TAX_ACCOUNT_ID,
5121: OBJECT_VERSION_NUMBER,
5122: TAX_ACCOUNT_ENTITY_CODE,
5141: LAST_UPDATE_DATE,
5142: LAST_UPDATE_LOGIN
5143: )
5144: SELECT
5145: zx_accounts_s.nextval,
5146: 1,
5147: 'RATES',
5148: zrb.TAX_RATE_ID,
5149: za.LEDGER_ID,
5166: sysdate,
5167: fnd_global.conc_login_id
5168: FROM ZX_RATES_B zrb,
5169: ZX_JURISDICTIONS_B zjb,
5170: ZX_ACCOUNTS za
5171: WHERE zrb.TAX_REGIME_CODE = p_tax_regime_code
5172: AND zrb.TAX IN ('STATE','COUNTY','CITY')
5173: AND zrb.CONTENT_OWNER_ID = -99
5174: AND zrb.RECORD_TYPE_CODE = G_CREATED_BY_MODULE