DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEF dependencies on ZX_DET_FACTOR_TEMPL_DTL

Line 8849: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL

8845: and T.LANGUAGE = L.LANGUAGE_CODE);
8846:
8847:
8848:
8849: INSERT INTO ZX_DET_FACTOR_TEMPL_DTL
8850: (
8851: DETERMINING_FACTOR_CLASS_CODE ,
8852: DETERMINING_FACTOR_CQ_CODE ,
8853: DETERMINING_FACTOR_CODE ,

Line 8875: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID

8871: DETERMINING_FACTOR_CQ_CODE ,
8872: DETERMINING_FACTOR_CODE ,
8873: REQUIRED_FLAG ,
8874: RECORD_TYPE_CODE ,
8875: zx_det_factor_templ_dtl_s.nextval ,--DET_FACTOR_TEMPL_DTL_ID
8876: DET_FACTOR_TEMPL_ID ,
8877: fnd_global.user_id ,
8878: SYSDATE ,
8879: fnd_global.user_id ,

Line 8900: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL

8896: ZX_DET_FACTOR_TEMPL_B TEMPL
8897: WHERE
8898: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8899: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8900: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL
8901: where DETERMINING_FACTOR_CLASS_CODE = 'ACCOUNTING_FLEXFIELD'
8902: and DET_FACTOR_TEMPL_ID = templ.DET_FACTOR_TEMPL_ID
8903: )
8904:

Line 8919: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL

8915: ZX_DET_FACTOR_TEMPL_B TEMPL
8916: WHERE
8917: TEMPL.DET_FACTOR_TEMPL_CODE = 'EX Acct String Range-Party FC'
8918: AND TEMPL.RECORD_TYPE_CODE = 'MIGRATED'
8919: AND not exists (select 1 from ZX_DET_FACTOR_TEMPL_DTL
8920: where DETERMINING_FACTOR_CLASS_CODE = 'PARTY_FISCAL_CLASS'
8921: and DET_FACTOR_TEMPL_ID = templ.DET_FACTOR_TEMPL_ID
8922: )
8923: );