APPS.PQP_GB_PSI_SCH dependencies on DUAL

Line 486: FROM dual;

482: SELECT instr(p_input_value,'->'),
483: LENGTH(p_input_value)
484: INTO l_del_position,
485: l_length
486: FROM dual;
487: SELECT decode(trim(SUBSTR(p_input_value,0,l_del_position-1)),'','0',to_number(trim(SUBSTR(p_input_value,0,l_del_position-1)))),
488: decode(trim(SUBSTR(p_input_value,l_del_position +3,l_length-1)),'','0',
489: to_number(SUBSTR(p_input_value,l_del_position +3,l_length-1)))
490: INTO l_old_value,

Line 492: FROM dual;

488: decode(trim(SUBSTR(p_input_value,l_del_position +3,l_length-1)),'','0',
489: to_number(SUBSTR(p_input_value,l_del_position +3,l_length-1)))
490: INTO l_old_value,
491: l_new_value
492: FROM dual;
493: p_new_value:= to_number(l_new_value);
494: p_old_value:= to_number(l_old_value);
495: debug('after coming out from get_old_and_new_values p_new_value:'||p_new_value);
496: debug('after coming out from get_old_and_new_values p_old_value:'||p_old_value);