APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_DET_FACTOR_TEMPL_DTL

Line 383: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL

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

Line 419: ZX_DET_FACTOR_TEMPL_DTL_S.nextval , --DET_FACTOR_TEMPL_DTL_ID

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

Line 432: (select 1 from ZX_DET_FACTOR_TEMPL_DTL DTL_TEMP2

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

Line 438: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL

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

Line 478: ZX_DET_FACTOR_TEMPL_DTL_S.nextval , --DET_FACTOR_TEMPL_DTL_ID

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

Line 497: (select 1 from ZX_DET_FACTOR_TEMPL_DTL DTL_TEMP2

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