[Home] [Help]
203: p_short_name varchar2 default null
204: ) Return Varchar2 Is
205: --
206: l_proc varchar2(72) := g_package||'apply_decode';
207: l_dcd_val ben_ext_data_elmt_decd.dcd_val%type ;
208: l_err_message varchar2(2000) ;
209:
210: --
211: cursor c1 is
209:
210: --
211: cursor c1 is
212: select dcd_val
213: from ben_ext_data_elmt_decd
214: where
215: ext_data_elmt_id = p_ext_data_elmt_id
216: and val = nvl(p_value, ' ');
217: --
3943: , efl.short_name
3944: , substr(efl.short_name,1,2) two_char_substr
3945: , substr(efl.short_name,1,1) one_char_substr
3946: from ben_Ext_where_clause ewc,
3947: ben_Ext_data_elmt xel,
3948: ben_ext_fld efl
3949: where ewc.ext_data_elmt_id = p_ext_data_elmt_id
3950: and xel.ext_data_elmt_id = ewc.cond_ext_data_elmt_id
3951: and xel.ext_fld_id = efl.ext_fld_id (+) ;
3950: and xel.ext_data_elmt_id = ewc.cond_ext_data_elmt_id
3951: and xel.ext_fld_id = efl.ext_fld_id (+) ;
3952:
3953:
3954: l_seq_num ben_ext_data_elmt_in_rcd.seq_num%Type ;
3955:
3956: cursor c_seq (p_ext_rcd_id in number ,
3957: p_ext_data_elmt_id in number) is
3958: select a.seq_num
3955:
3956: cursor c_seq (p_ext_rcd_id in number ,
3957: p_ext_data_elmt_id in number) is
3958: select a.seq_num
3959: from ben_ext_data_elmt_in_rcd a
3960: where a.ext_rcd_id = p_ext_rcd_id
3961: and a.ext_data_elmt_id = p_ext_data_elmt_id ;
3962:
3963: begin
4142: , ttl_fnctn_cd
4143: , defined_balance_id
4144: from
4145: ben_ext_fld c,
4146: ben_ext_data_elmt b,
4147: ben_ext_data_elmt_in_rcd a
4148: where
4149: a.ext_data_elmt_id = b.ext_data_elmt_id
4150: and a.ext_rcd_id = l_ext_rcd_id
4143: , defined_balance_id
4144: from
4145: ben_ext_fld c,
4146: ben_ext_data_elmt b,
4147: ben_ext_data_elmt_in_rcd a
4148: where
4149: a.ext_data_elmt_id = b.ext_data_elmt_id
4150: and a.ext_rcd_id = l_ext_rcd_id
4151: and b.ext_fld_id = c.ext_fld_id (+)