DBA Data[Home] [Help]

APPS.JL_CO_FA_TA_LOAD_PKG dependencies on DUAL

Line 159: FROM DUAL;

155:
156:
157: SELECT jl_co_fa_appraisals_s.nextval
158: INTO x_appraisal_id
159: FROM DUAL;
160:
161: IF ( G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
162: fnd_file.put_line( 1, 'x_appraisal_id : '||to_char(x_appraisal_id));
163: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name, 'x_appraisal_id : '||to_char(x_appraisal_id));

Line 273: FROM DUAL

269: x_count := 0;
270:
271: SELECT 1
272: INTO x_count
273: FROM DUAL
274: WHERE EXISTS (SELECT * FROM JL_CO_FA_ASSET_APPRS
275: WHERE appraisal_id = x_appraisal_id);
276:
277: EXCEPTION