DBA Data[Home] [Help]

APPS.ZX_MIGRATE_TAX_DEFAULT_HIER dependencies on ZX_DET_FACTOR_TEMPL_B

Line 90: INSERT INTO ZX_DET_FACTOR_TEMPL_B

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

Line 117: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID

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

Line 130: from ZX_DET_FACTOR_TEMPL_B

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

Line 135: INSERT INTO ZX_DET_FACTOR_TEMPL_B

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

Line 162: zx_det_factor_templ_b_s.nextval , --DET_FACTOR_TEMPL_ID

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

Line 175: from ZX_DET_FACTOR_TEMPL_B

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

Line 205: ZX_DET_FACTOR_TEMPL_B B

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

Line 428: FROM ZX_DET_FACTOR_TEMPL_B templ,

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

Line 487: FROM ZX_DET_FACTOR_TEMPL_B templ,

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