APPS.JA_CN_UDRV_EXPORT dependencies on DUAL

Line 296: FROM dual;

292: IF length(lv_sub_segment_code) = 8
293: THEN
294: SELECT substr(lv_sub_segment_code,8,1)
295: INTO ln_record_number
296: FROM dual;
297: ELSE
298: IF length(lv_sub_segment_code) = 9
299: THEN
300: SELECT substr(lv_sub_segment_code,8,2)

Line 302: FROM dual;

298: IF length(lv_sub_segment_code) = 9
299: THEN
300: SELECT substr(lv_sub_segment_code,8,2)
301: INTO ln_record_number
302: FROM dual;
303: END IF;
304: END IF;
305:
306: IF lv_source_code = 'COA'