APPS.BEN_EXT_FMT dependencies on DUAL

Line 5739: into l_fmt_num from dual;

5735: -- Positive value changes only for { format mask
5736: if substr(p_format_mask,length(p_format_mask),1) = '{' then
5737: select decode(substr(l_str_value,length(l_str_value),1),
5738: '1','A','2','B','3','C','4','D','5','E','6','F','7','G','8','H','9','I','0','{')
5739: into l_fmt_num from dual;
5740: else
5741: l_fmt_num := substr(l_str_value,-1) ;
5742: End if ;
5743: else

Line 5748: into l_fmt_num from dual;

5744: -- change the number as positive
5745: l_str_value := to_char(abs(p_value),l_format);
5746: select decode(substr(l_str_value,length(l_str_value),1),
5747: '1','J','2','K','3','L','4','M','5','N','6','O','7','P','8','Q','9','R','0','}')
5748: into l_fmt_num from dual;
5749: end if;
5750:
5751: hr_utility.set_location('non Formated value :'||l_str_value , 10);
5752: hr_utility.set_location('non Formated value :'|| (length(l_str_value)-1) , 10);