DBA Data[Home] [Help]

APPS.BEN_EXT_FMT dependencies on BEN_EXT_DATA_ELMT_IN_RCD

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 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 (+)