DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_DET_FACTOR_TEMPL_DTL

Line 8871: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL

8867: and T.LANGUAGE = L.LANGUAGE_CODE);
8868:
8869:
8870:
8871: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL
8872: (
8873: DETERMINING_FACTOR_CLASS_CODE ,
8874: DETERMINING_FACTOR_CQ_CODE ,
8875: DETERMINING_FACTOR_CODE ,

Line 8899: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID

8895: DETERMINING_FACTOR_CODE ,
8896: TAX_PARAMETER_CODE ,--Bug 8745203
8897: REQUIRED_FLAG ,
8898: RECORD_TYPE_CODE ,
8899: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID
8900: DET_FACTOR_TEMPL_ID ,
8901: fnd_global.user_id ,
8902: SYSDATE ,
8903: fnd_global.user_id ,

Line 8925: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL

8921: ZX_DET_FACTOR_TEMPL_B TEMPL
8922: WHERE
8923: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8924: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8925: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL
8926: where DETERMINING_FACTOR_CLASS_CODE = 'ACCOUNTING_FLEXFIELD'
8927: and DET_FACTOR_TEMPL_ID = templ.DET_FACTOR_TEMPL_ID
8928: )
8929:

Line 8944: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL

8940: ZX_DET_FACTOR_TEMPL_B TEMPL
8941: WHERE
8942: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8943: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8944: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL
8945: where DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
8946: and DET_FACTOR_TEMPL_ID = templ.DET_FACTOR_TEMPL_ID
8947: )
8948: );