DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_DET_FACTORS_TL

Line 3256: INSERT INTO ZX_DET_FACTORS_TL (

3252: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3253: AND DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS')
3254: );
3255:
3256: INSERT INTO ZX_DET_FACTORS_TL (
3257: DETERMINING_FACTOR_NAME,
3258: DETERMINING_FACTOR_DESC,
3259: CREATION_DATE,
3260: CREATED_BY,

Line 3290: (select NULL from ZX_DET_FACTORS_TL T

3286: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS'
3287: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'
3288: and l.installed_flag in ('I', 'B')
3289: and NOT EXISTS -- this condition makes sure we dont duplicate data
3290: (select NULL from ZX_DET_FACTORS_TL T
3291: where T.DETERMINING_FACTOR_ID = detFactors.DETERMINING_FACTOR_ID
3292: and T.LANGUAGE = L.LANGUAGE_CODE)
3293: );
3294:

Line 3448: INSERT INTO ZX_DET_FACTORS_TL (

3444: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3445: AND DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS')
3446: );
3447:
3448: INSERT INTO ZX_DET_FACTORS_TL (
3449: DETERMINING_FACTOR_NAME,
3450: DETERMINING_FACTOR_DESC,
3451: CREATION_DATE,
3452: CREATED_BY,

Line 3480: (select NULL from ZX_DET_FACTORS_TL T

3476: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
3477: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'
3478: and l.installed_flag in ('I', 'B')
3479: and NOT EXISTS -- this condition makes sure we dont duplicate data
3480: (select NULL from ZX_DET_FACTORS_TL T
3481: where T.DETERMINING_FACTOR_ID = detFactors.DETERMINING_FACTOR_ID
3482: and T.LANGUAGE = L.LANGUAGE_CODE)
3483: );
3484: