APPS.BEN_EXT_FMT dependencies on BEN_EXT_DATA_ELMT_DECD

Line 206: l_dcd_val ben_ext_data_elmt_decd.dcd_val%type ;

202: p_short_name varchar2 default null
203: ) Return Varchar2 Is
204: --
205: l_proc varchar2(72) := g_package||'apply_decode';
206: l_dcd_val ben_ext_data_elmt_decd.dcd_val%type ;
207: l_err_message varchar2(2000) ;
208:
209: --
210: cursor c1 is

Line 212: from ben_ext_data_elmt_decd

208:
209: --
210: cursor c1 is
211: select dcd_val
212: from ben_ext_data_elmt_decd
213: where
214: ext_data_elmt_id = p_ext_data_elmt_id
215: and val = nvl(p_value, ' ');
216: --