APPS.ZX_FC_MIGRATE_PKG dependencies on ZX_DETERMINING_FACTORS_B

Line 3203: INSERT INTO ZX_DETERMINING_FACTORS_B (

3199: );
3200:
3201: -- Insert records into Determining Factors table
3202:
3203: INSERT INTO ZX_DETERMINING_FACTORS_B (
3204: DETERMINING_FACTOR_ID,
3205: DETERMINING_FACTOR_CODE,
3206: DETERMINING_FACTOR_CLASS_CODE,
3207: VALUE_SET,

Line 3227: (SELECT Zx_Determining_Factors_B_S.nextval,

3223: LAST_UPDATED_BY,
3224: LAST_UPDATE_LOGIN,
3225: OBJECT_VERSION_NUMBER)
3226:
3227: (SELECT Zx_Determining_Factors_B_S.nextval,
3228: p_classification_type_code,
3229: 'PRODUCT_FISCAL_CLASS',
3230: NULL,
3231: NULL,

Line 3251: (SELECT null from ZX_DETERMINING_FACTORS_B

3247: FND_GLOBAL.CONC_LOGIN_ID,
3248: 1
3249: FROM dual
3250: WHERE NOT EXISTS
3251: (SELECT null from ZX_DETERMINING_FACTORS_B
3252: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3253: AND DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS')
3254: );
3255:

Line 3283: ZX_DETERMINING_FACTORS_B detFactors

3279: L.LANGUAGE_CODE,
3280: userenv('LANG')
3281:
3282: FROM FND_LANGUAGES L,
3283: ZX_DETERMINING_FACTORS_B detFactors
3284: WHERE
3285: detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
3286: and detFactors.DETERMINING_FACTOR_CLASS_CODE = 'PRODUCT_FISCAL_CLASS'
3287: --and detFactors.RECORD_TYPE_CODE = 'MIGRATED'

Line 3395: INSERT INTO ZX_DETERMINING_FACTORS_B (

3391: );
3392:
3393: -- Insert records into Determining Factors table
3394:
3395: INSERT INTO ZX_DETERMINING_FACTORS_B (
3396: DETERMINING_FACTOR_ID,
3397: DETERMINING_FACTOR_CODE,
3398: DETERMINING_FACTOR_CLASS_CODE,
3399: VALUE_SET,

Line 3419: (SELECT Zx_Determining_Factors_B_S.nextval,

3415: LAST_UPDATED_BY,
3416: LAST_UPDATE_LOGIN,
3417: OBJECT_VERSION_NUMBER)
3418:
3419: (SELECT Zx_Determining_Factors_B_S.nextval,
3420: p_classification_type_code,
3421: 'PARTY_FISCAL_CLASS',
3422: NULL,
3423: NULL,

Line 3443: (SELECT null from ZX_DETERMINING_FACTORS_B

3439: FND_GLOBAL.CONC_LOGIN_ID,
3440: 1
3441: FROM dual
3442: WHERE NOT EXISTS
3443: (SELECT null from ZX_DETERMINING_FACTORS_B
3444: WHERE DETERMINING_FACTOR_CODE = p_classification_type_code
3445: AND DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS')
3446: );
3447:

Line 3474: ZX_DETERMINING_FACTORS_B detFactors

3470: detFactors.DETERMINING_FACTOR_ID,
3471: L.LANGUAGE_CODE,
3472: userenv('LANG')
3473: FROM FND_LANGUAGES L,
3474: ZX_DETERMINING_FACTORS_B detFactors
3475: WHERE detFactors.DETERMINING_FACTOR_CODE = p_classification_type_code
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')

Line 4809: UPDATE ZX_DETERMINING_FACTORS_B SET record_type_code = 'SEEDED', created_by = 120,

4805: last_updated_by = 120, last_update_login = 0
4806: WHERE classification_type_code in ('STATISTICAL_CODE', 'FISCAL_CLASSIFICATION', 'WINE CIGARETTE') and
4807: classification_type_categ_code = 'PRODUCT_FISCAL_CLASS';
4808:
4809: UPDATE ZX_DETERMINING_FACTORS_B SET record_type_code = 'SEEDED', created_by = 120,
4810: last_updated_by = 120, last_update_login = 0
4811: WHERE determining_factor_code in ('STATISTICAL_CODE', 'FISCAL_CLASSIFICATION', 'WINE CIGARETTE') and
4812: determining_factor_class_code = 'PRODUCT_FISCAL_CLASS';
4813: