APPS.BEN_BENXLAYT_XMLP_PKG dependencies on BEN_EXT_DATA_ELMT

Line 16: FROM ben_ext_data_elmt

12: l_operator hr_lookups.meaning%type;
13: cursor get_data_element
14: (p_ext_data_elmt_id number) is
15: SELECT name
16: FROM ben_ext_data_elmt
17: WHERE ext_data_elmt_id = p_ext_data_elmt_id ;
18:
19:
20: cursor get_where_clause

Line 25: l_sum_data_elmt ben_ext_data_elmt.name%type;

21: (p_ext_data_elmt_id number) is
22: SELECT cond_ext_data_elmt_id ,oper_cd,val,and_or_cd
23: FROM ben_ext_where_clause where ext_data_elmt_id = p_ext_data_elmt_id ;
24:
25: l_sum_data_elmt ben_ext_data_elmt.name%type;
26: l_cond_data_elmt ben_ext_data_elmt.name%type;
27:
28: l_where_flag boolean :=FALSE;
29: l_where_clause varchar2(2000);

Line 26: l_cond_data_elmt ben_ext_data_elmt.name%type;

22: SELECT cond_ext_data_elmt_id ,oper_cd,val,and_or_cd
23: FROM ben_ext_where_clause where ext_data_elmt_id = p_ext_data_elmt_id ;
24:
25: l_sum_data_elmt ben_ext_data_elmt.name%type;
26: l_cond_data_elmt ben_ext_data_elmt.name%type;
27:
28: l_where_flag boolean :=FALSE;
29: l_where_clause varchar2(2000);
30: l_return varchar2(2000);