APPS.BEN_EXT_FMT dependencies on BEN_EXT_DATA_ELMT

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: --

Line 3941: ben_Ext_data_elmt xel,

3937: , efl.short_name
3938: , substr(efl.short_name,1,2) two_char_substr
3939: , substr(efl.short_name,1,1) one_char_substr
3940: from ben_Ext_where_clause ewc,
3941: ben_Ext_data_elmt xel,
3942: ben_ext_fld efl
3943: where ewc.ext_data_elmt_id = p_ext_data_elmt_id
3944: and xel.ext_data_elmt_id = ewc.cond_ext_data_elmt_id
3945: and xel.ext_fld_id = efl.ext_fld_id (+) ;

Line 3948: l_seq_num ben_ext_data_elmt_in_rcd.seq_num%Type ;

3944: and xel.ext_data_elmt_id = ewc.cond_ext_data_elmt_id
3945: and xel.ext_fld_id = efl.ext_fld_id (+) ;
3946:
3947:
3948: l_seq_num ben_ext_data_elmt_in_rcd.seq_num%Type ;
3949:
3950: cursor c_seq (p_ext_rcd_id in number ,
3951: p_ext_data_elmt_id in number) is
3952: select a.seq_num

Line 3953: from ben_ext_data_elmt_in_rcd a

3949:
3950: cursor c_seq (p_ext_rcd_id in number ,
3951: p_ext_data_elmt_id in number) is
3952: select a.seq_num
3953: from ben_ext_data_elmt_in_rcd a
3954: where a.ext_rcd_id = p_ext_rcd_id
3955: and a.ext_data_elmt_id = p_ext_data_elmt_id ;
3956:
3957: begin

Line 4140: ben_ext_data_elmt b,

4136: , ttl_fnctn_cd
4137: , defined_balance_id
4138: from
4139: ben_ext_fld c,
4140: ben_ext_data_elmt b,
4141: ben_ext_data_elmt_in_rcd a
4142: where
4143: a.ext_data_elmt_id = b.ext_data_elmt_id
4144: and a.ext_rcd_id = l_ext_rcd_id

Line 4141: ben_ext_data_elmt_in_rcd a

4137: , defined_balance_id
4138: from
4139: ben_ext_fld c,
4140: ben_ext_data_elmt b,
4141: ben_ext_data_elmt_in_rcd a
4142: where
4143: a.ext_data_elmt_id = b.ext_data_elmt_id
4144: and a.ext_rcd_id = l_ext_rcd_id
4145: and b.ext_fld_id = c.ext_fld_id (+)