DBA Data[Home] [Help]

APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_DET_FACTORS_TL

Line 3226: INSERT INTO ZX_DET_FACTORS_TL (

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,

Line 3261: (select NULL from ZX_DET_FACTORS_TL T

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:

Line 3420: INSERT INTO ZX_DET_FACTORS_TL (

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,

Line 3453: (select NULL from ZX_DET_FACTORS_TL T

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: