APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_DETERMINING_FACTORS_B

Line 217: INSERT INTO ZX_DETERMINING_FACTORS_B

213: -- Determining factor code of input factor tax_classification_code is part of
214: -- seed data
215:
216: -- Create determining factor code for input factor PRODUCT_FISCAL_CLASS
217: INSERT INTO ZX_DETERMINING_FACTORS_B
218: (
219: DETERMINING_FACTOR_CODE ,
220: DETERMINING_FACTOR_CLASS_CODE,
221: VALUE_SET ,

Line 266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,

262: fnd_global.conc_request_id , --Request Id
263: fnd_global.prog_appl_id , --Program Application ID
264: fnd_global.conc_program_id , --Program Id
265: fnd_global.conc_login_id , --Program Login ID
266: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
267: fnd_global.user_id , --CREATED_BY
268: fnd_global.user_id , --LAST_UPDATED_BY
269: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
270: 1 OBJECT_VERSION_NUMBER

Line 273: FROM ZX_DETERMINING_FACTORS_B

269: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
270: 1 OBJECT_VERSION_NUMBER
271: FROM DUAL
272: WHERE NOT EXISTS (SELECT 1
273: FROM ZX_DETERMINING_FACTORS_B
274: WHERE DETERMINING_FACTOR_CLASS_CODE ='PRODUCT_FISCAL_CLASS'
275: AND DETERMINING_FACTOR_CODE = 'LEASE_MGT_PROD_FISC_CLASS');
276:
277:

Line 279: INSERT INTO ZX_DETERMINING_FACTORS_B

275: AND DETERMINING_FACTOR_CODE = 'LEASE_MGT_PROD_FISC_CLASS');
276:
277:
278: -- Create determining factor code for PARTY_FISCAL_CLASS
279: INSERT INTO ZX_DETERMINING_FACTORS_B
280: (
281: DETERMINING_FACTOR_CODE ,
282: DETERMINING_FACTOR_CLASS_CODE,
283: VALUE_SET ,

Line 328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,

324: fnd_global.conc_request_id , --Request Id
325: fnd_global.prog_appl_id , --Program Application ID
326: fnd_global.conc_program_id , --Program Id
327: fnd_global.conc_login_id , --Program Login ID
328: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,
329: fnd_global.user_id , --CREATED_BY
330: fnd_global.user_id , --LAST_UPDATED_BY
331: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
332: 1 OBJECT_VERSION_NUMBER

Line 335: FROM ZX_DETERMINING_FACTORS_B

331: fnd_global.conc_login_id , --LAST_UPDATE_LOGIN
332: 1 OBJECT_VERSION_NUMBER
333: FROM DUAL
334: WHERE NOT EXISTS (SELECT 1
335: FROM ZX_DETERMINING_FACTORS_B
336: WHERE DETERMINING_FACTOR_CLASS_CODE ='PARTY_FISCAL_CLASS'
337: AND DETERMINING_FACTOR_CODE = 'LEASE_MGT_PTY_FISC_CLASS');
338:
339: -- Determining factor code of input factor USER_DEFINED_FISC_CLASS is part of seed

Line 369: ZX_DETERMINING_FACTORS_B B

365: fnd_global.user_id ,--LAST_UPDATED_BY
366: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
367: FROM
368: FND_LANGUAGES L,
369: ZX_DETERMINING_FACTORS_B B
370: WHERE
371: L.INSTALLED_FLAG in ('I', 'B')
372: AND ((B.DETERMINING_FACTOR_CLASS_CODE ='PARTY_FISCAL_CLASS'
373: AND B.DETERMINING_FACTOR_CODE = 'LEASE_MGT_PTY_FISC_CLASS')

Line 427: ZX_DETERMINING_FACTORS_B factor

423: factor.LAST_UPDATE_LOGIN , --LAST_UPDATE_LOGIN
424: factor.OBJECT_VERSION_NUMBER --OBJECT_VERSION_NUMBER
425:
426: FROM ZX_DET_FACTOR_TEMPL_B templ,
427: ZX_DETERMINING_FACTORS_B factor
428: WHERE templ.DET_FACTOR_TEMPL_CODE = 'STCC'
429: AND factor.DETERMINING_FACTOR_CLASS_CODE ='TRX_INPUT_FACTOR'
430: AND factor.DETERMINING_FACTOR_CODE = 'TAX_CLASSIFICATION_CODE'
431: AND NOT EXISTS

Line 486: ZX_DETERMINING_FACTORS_B factor

482: factor.LAST_UPDATE_LOGIN , --LAST_UPDATE_LOGIN
483: factor.OBJECT_VERSION_NUMBER --OBJECT_VERSION_NUMBER
484:
485: FROM ZX_DET_FACTOR_TEMPL_B templ,
486: ZX_DETERMINING_FACTORS_B factor
487: WHERE templ.DET_FACTOR_TEMPL_CODE = 'LEASE_MGT_RATE_DET_TEMPL'
488: AND ((factor.DETERMINING_FACTOR_CLASS_CODE ='TRX_INPUT_FACTOR'
489: AND factor.DETERMINING_FACTOR_CODE IN ('TAX_CLASSIFICATION_CODE',
490: 'USER_DEFINED_FISC_CLASS'))