DBA Data[Home] [Help]

APPS.MRP_FIELDRANGE_PUB dependencies on DUAL

Line 24: FROM dual

20: if arg_field_type = TYPE_NUMBER
21: then
22: SELECT 'X'
23: INTO string_buffer
24: FROM dual
25: WHERE TO_NUMBER(arg_low_field) <= TO_NUMBER(arg_high_field);
26: elsif arg_field_type = TYPE_CHAR
27: then
28: SELECT 'X'

Line 30: FROM dual

26: elsif arg_field_type = TYPE_CHAR
27: then
28: SELECT 'X'
29: INTO string_buffer
30: FROM dual
31: WHERE arg_low_field <= arg_high_field;
32: else
33: SELECT 'X'
34: INTO string_buffer

Line 35: FROM dual

31: WHERE arg_low_field <= arg_high_field;
32: else
33: SELECT 'X'
34: INTO string_buffer
35: FROM dual
36: WHERE TO_DATE(arg_low_field,'DD-MON-RR' )
37: <= TO_DATE(arg_high_field, 'DD-MON-RR');
38: end if;
39: