APPS.BEN_EXT_FMT dependencies on DUAL

Line 5745: into l_fmt_num from dual;

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

Line 5754: into l_fmt_num from dual;

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