3222: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3223: AND DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS')
3224: );
3225:
3226: INSERT INTO ZX_DET_FACTORS_TL (
3227: DETERMINING_FACTOR_NAME,
3228: DETERMINING_FACTOR_DESC,
3229: CREATION_DATE,
3230: CREATED_BY,
3257: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS'
3258: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'
3259: and l.installed_flag in ('I', 'B')
3260: and NOT EXISTS -- this condition makes sure we dont duplicate data
3261: (select NULL from ZX_DET_FACTORS_TL T
3262: where T.DETERMINING_FACTOR_ID = detFactors.DETERMINING_FACTOR_ID
3263: and T.LANGUAGE = L.LANGUAGE_CODE)
3264: );
3265:
3416: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3417: AND DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS')
3418: );
3419:
3420: INSERT INTO ZX_DET_FACTORS_TL (
3421: DETERMINING_FACTOR_NAME,
3422: DETERMINING_FACTOR_DESC,
3423: CREATION_DATE,
3424: CREATED_BY,
3449: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
3450: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'
3451: and l.installed_flag in ('I', 'B')
3452: and NOT EXISTS -- this condition makes sure we dont duplicate data
3453: (select NULL from ZX_DET_FACTORS_TL T
3454: where T.DETERMINING_FACTOR_ID = detFactors.DETERMINING_FACTOR_ID
3455: and T.LANGUAGE = L.LANGUAGE_CODE)
3456: );
3457: