APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_DET_FACTOR_TEMPL_B

Line 88: INSERT INTO ZX_DET_FACTOR_TEMPL_B

84: arp_util_tax.debug('create_template(+)');
85: END IF;
86:
87: -- Determining factor template: STCC
88: INSERT INTO ZX_DET_FACTOR_TEMPL_B
89: (
90: DET_FACTOR_TEMPL_CODE ,
91: TAX_REGIME_CODE ,
92: TEMPLATE_USAGE_CODE ,

Line 115: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID

111: 'TAX_RULES' , --TEMPLATE_USAGE_CODE
112: 'MIGRATED' , --RECORD_TYPE_CODE
113: NULL , --LEDGER_ID
114: NULL , --CHART_OF_ACCOUNTS_ID
115: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID
116: fnd_global.user_id , --CREATED_BY
117: SYSDATE , --CREATION_DATE
118: fnd_global.user_id , --LAST_UPDATED_BY
119: SYSDATE , --LAST_UPDATE_DATE

Line 128: from ZX_DET_FACTOR_TEMPL_B

124: fnd_global.conc_login_id , --Program Login ID
125: 1
126: FROM DUAL
127: WHERE not exists (select 1
128: from ZX_DET_FACTOR_TEMPL_B
129: where DET_FACTOR_TEMPL_CODE = 'STCC'
130: );
131:
132: --Determining factor template: LEASE_MGT_RATE_DET_TEMPL

Line 133: INSERT INTO ZX_DET_FACTOR_TEMPL_B

129: where DET_FACTOR_TEMPL_CODE = 'STCC'
130: );
131:
132: --Determining factor template: LEASE_MGT_RATE_DET_TEMPL
133: INSERT INTO ZX_DET_FACTOR_TEMPL_B
134: (
135: DET_FACTOR_TEMPL_CODE ,
136: TAX_REGIME_CODE ,
137: TEMPLATE_USAGE_CODE ,

Line 160: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID

156: 'TAX_RULES' , --TEMPLATE_USAGE_CODE
157: 'MIGRATED' , --RECORD_TYPE_CODE
158: NULL , --LEDGER_ID
159: NULL , --CHART_OF_ACCOUNTS_ID
160: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID
161: fnd_global.user_id , --CREATED_BY
162: SYSDATE , --CREATION_DATE
163: fnd_global.user_id , --LAST_UPDATED_BY
164: SYSDATE , --LAST_UPDATE_DATE

Line 173: from ZX_DET_FACTOR_TEMPL_B

169: fnd_global.conc_login_id , --Program Login ID
170: 1
171: FROM DUAL
172: WHERE not exists (select 1
173: from ZX_DET_FACTOR_TEMPL_B
174: where DET_FACTOR_TEMPL_CODE = 'LEASE_MGT_RATE_DET_TEMPL'
175: );
176:
177: INSERT INTO ZX_DET_FACTOR_TEMPL_TL

Line 203: ZX_DET_FACTOR_TEMPL_B B

199: fnd_global.user_id ,--LAST_UPDATED_BY
200: fnd_global.conc_login_id --LAST_UPDATE_LOGIN
201: FROM
202: FND_LANGUAGES L,
203: ZX_DET_FACTOR_TEMPL_B B
204: WHERE
205: L.INSTALLED_FLAG in ('I', 'B')
206: AND B.DET_FACTOR_TEMPL_CODE IN ('STCC' , 'LEASE_MGT_RATE_DET_TEMPL')
207: AND not exists

Line 426: FROM ZX_DET_FACTOR_TEMPL_B templ,

422: factor.LAST_UPDATED_BY , --LAST_UPDATED_BY
423: factor.LAST_UPDATE_LOGIN , --LAST_UPDATE_LOGIN
424: factor.OBJECT_VERSION_NUMBER --OBJECT_VERSION_NUMBER
425:
426: FROM ZX_DET_FACTOR_TEMPL_B templ,
427: ZX_DETERMINING_FACTORS_B factor
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'

Line 485: FROM ZX_DET_FACTOR_TEMPL_B templ,

481: factor.LAST_UPDATED_BY , --LAST_UPDATED_BY
482: factor.LAST_UPDATE_LOGIN , --LAST_UPDATE_LOGIN
483: factor.OBJECT_VERSION_NUMBER --OBJECT_VERSION_NUMBER
484:
485: FROM ZX_DET_FACTOR_TEMPL_B templ,
486: ZX_DETERMINING_FACTORS_B factor
487: WHERE templ.DET_FACTOR_TEMPL_CODE = 'LEASE_MGT_RATE_DET_TEMPL'
488: AND ((factor.DETERMINING_FACTOR_CLASS_CODE ='TRX_INPUT_FACTOR'
489: AND factor.DETERMINING_FACTOR_CODE IN ('TAX_CLASSIFICATION_CODE',