APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_DETERMINING_FACTORS_B

Line 219: INSERT INTO ZX_DETERMINING_FACTORS_B

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

Line 268: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,

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

Line 275: FROM ZX_DETERMINING_FACTORS_B

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

Line 281: INSERT INTO ZX_DETERMINING_FACTORS_B

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

Line 330: ZX_DETERMINING_FACTORS_B_S.nextval DETERMINING_FACTOR_ID ,

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

Line 337: FROM ZX_DETERMINING_FACTORS_B

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

Line 371: ZX_DETERMINING_FACTORS_B B

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

Line 429: ZX_DETERMINING_FACTORS_B factor

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

Line 488: ZX_DETERMINING_FACTORS_B factor

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