APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_DET_FACTOR_TEMPL_DTL

Line 385: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL

381: WHERE T.DETERMINING_FACTOR_ID = B.DETERMINING_FACTOR_ID
382: AND T.LANGUAGE = L.LANGUAGE_CODE);
383:
384: -- insert the template detail table for STCC
385: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL
386: (
387: DETERMINING_FACTOR_CLASS_CODE,
388: DETERMINING_FACTOR_CQ_CODE ,
389: DETERMINING_FACTOR_CODE ,

Line 421: ZX_DET_FACTOR_TEMPL_DTL_S.nextval , --DET_FACTOR_TEMPL_DTL_ID

417: factor.PROGRAM_ID , --PROGRAM_ID
418: NULL , --TAX_REGIME_DET_LEVEL_CODE
419: factor.TAX_PARAMETER_CODE , --TAX_PARAMETER_CODE
420: factor.PROGRAM_LOGIN_ID , --PROGRAM_LOGIN_ID
421: ZX_DET_FACTOR_TEMPL_DTL_S.nextval , --DET_FACTOR_TEMPL_DTL_ID
422: templ.DET_FACTOR_TEMPL_ID , --DET_FACTOR_TEMPL_ID
423: factor.CREATED_BY , --CREATED_BY
424: factor.LAST_UPDATED_BY , --LAST_UPDATED_BY
425: factor.LAST_UPDATE_LOGIN , --LAST_UPDATE_LOGIN

Line 434: (select 1 from ZX_DET_FACTOR_TEMPL_DTL DTL_TEMP2

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
434: (select 1 from ZX_DET_FACTOR_TEMPL_DTL DTL_TEMP2
435: where DET_FACTOR_TEMPL_ID = templ.DET_FACTOR_TEMPL_ID
436: and DETERMINING_FACTOR_CLASS_CODE = factor.DETERMINING_FACTOR_CLASS_CODE
437: and DETERMINING_FACTOR_CODE = factor.DETERMINING_FACTOR_CODE);
438:

Line 440: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL

436: and DETERMINING_FACTOR_CLASS_CODE = factor.DETERMINING_FACTOR_CLASS_CODE
437: and DETERMINING_FACTOR_CODE = factor.DETERMINING_FACTOR_CODE);
438:
439: -- insert the template detail table for LEASE_MGT_RATE_DET_TEMPL
440: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL
441: (
442: DETERMINING_FACTOR_CLASS_CODE,
443: DETERMINING_FACTOR_CQ_CODE ,
444: DETERMINING_FACTOR_CODE ,

Line 480: ZX_DET_FACTOR_TEMPL_DTL_S.nextval , --DET_FACTOR_TEMPL_DTL_ID

476: factor.PROGRAM_ID , --PROGRAM_ID
477: NULL , --TAX_REGIME_DET_LEVEL_CODE
478: factor.TAX_PARAMETER_CODE , --TAX_PARAMETER_CODE
479: factor.PROGRAM_LOGIN_ID , --PROGRAM_LOGIN_ID
480: ZX_DET_FACTOR_TEMPL_DTL_S.nextval , --DET_FACTOR_TEMPL_DTL_ID
481: templ.DET_FACTOR_TEMPL_ID , --DET_FACTOR_TEMPL_ID
482: factor.CREATED_BY , --CREATED_BY
483: factor.LAST_UPDATED_BY , --LAST_UPDATED_BY
484: factor.LAST_UPDATE_LOGIN , --LAST_UPDATE_LOGIN

Line 499: (select 1 from ZX_DET_FACTOR_TEMPL_DTL DTL_TEMP2

495: OR (factor.DETERMINING_FACTOR_CLASS_CODE ='PRODUCT_FISCAL_CLASS'
496: AND factor.DETERMINING_FACTOR_CODE = 'LEASE_MGT_PROD_FISC_CLASS')
497: )
498: AND NOT EXISTS
499: (select 1 from ZX_DET_FACTOR_TEMPL_DTL DTL_TEMP2
500: where DET_FACTOR_TEMPL_ID = templ.DET_FACTOR_TEMPL_ID
501: and DETERMINING_FACTOR_CLASS_CODE = factor.DETERMINING_FACTOR_CLASS_CODE
502: -- and DETERMINING_FACTOR_CQ_CODE = cqtemp.DETERMINING_FACTOR_CQ_CODE
503: and DETERMINING_FACTOR_CODE = factor.DETERMINING_FACTOR_CODE);