DBA Data[Home] [Help]

APPS.BEN_EXT_WRITE dependencies on BEN_EXT_DATA_ELMT

Line 142: from ben_ext_data_elmt_in_rcd xer,

138: xer.dlmtr_val,
139: xer.hide_flag,
140: xde.just_cd ,
141: xef.short_name
142: from ben_ext_data_elmt_in_rcd xer,
143: ben_ext_data_elmt xde,
144: ben_ext_fld xef
145: where xer.ext_rcd_id = p_ext_rcd_id
146: and xer.ext_data_elmt_id = xde.ext_data_elmt_id

Line 143: ben_ext_data_elmt xde,

139: xer.hide_flag,
140: xde.just_cd ,
141: xef.short_name
142: from ben_ext_data_elmt_in_rcd xer,
143: ben_ext_data_elmt xde,
144: ben_ext_fld xef
145: where xer.ext_rcd_id = p_ext_rcd_id
146: and xer.ext_data_elmt_id = xde.ext_data_elmt_id
147: and xde.ext_fld_id = xef.ext_fld_id (+)

Line 4167: l_just_cd ben_ext_data_elmt.just_cd%type ;

4163: job_failure exception;
4164: l_dummy varchar2(1);
4165: l_request_id number;
4166: l_rcd_count number :=0;
4167: l_just_cd ben_ext_data_elmt.just_cd%type ;
4168: l_output_type varchar2(30) ;
4169: l_xdo_template_id number ;
4170: l_cm_display_flag varchar2(30) ;
4171: l_spcl_hndl_flag ben_ext_dfn.spcl_hndl_flag%type ;

Line 4172: l_delimiter ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;

4168: l_output_type varchar2(30) ;
4169: l_xdo_template_id number ;
4170: l_cm_display_flag varchar2(30) ;
4171: l_spcl_hndl_flag ben_ext_dfn.spcl_hndl_flag%type ;
4172: l_delimiter ben_ext_data_elmt_in_rcd.DLMTR_VAL%type ;
4173: --
4174: cursor c_xrs is
4175: select xrs.output_name,
4176: xrs.drctry_name,

Line 4535: from ben_ext_data_elmt xel,

4531: --
4532: cursor c_xel_name(p_ext_rcd_id number ,
4533: p_seq_num number) is
4534: select xel.name
4535: from ben_ext_data_elmt xel,
4536: ben_Ext_data_elmt_in_rcd xdr
4537: where xdr.ext_data_elmt_id = xel.ext_data_elmt_id
4538: and xdr.ext_rcd_id = p_ext_rcd_id
4539: and xdr.seq_num = p_seq_num

Line 4536: ben_Ext_data_elmt_in_rcd xdr

4532: cursor c_xel_name(p_ext_rcd_id number ,
4533: p_seq_num number) is
4534: select xel.name
4535: from ben_ext_data_elmt xel,
4536: ben_Ext_data_elmt_in_rcd xdr
4537: where xdr.ext_data_elmt_id = xel.ext_data_elmt_id
4538: and xdr.ext_rcd_id = p_ext_rcd_id
4539: and xdr.seq_num = p_seq_num
4540: ;

Line 4541: l_ext_data_elmt_name ben_ext_data_elmt.name%type ;

4537: where xdr.ext_data_elmt_id = xel.ext_data_elmt_id
4538: and xdr.ext_rcd_id = p_ext_rcd_id
4539: and xdr.seq_num = p_seq_num
4540: ;
4541: l_ext_data_elmt_name ben_ext_data_elmt.name%type ;
4542: l_prev_seq_num number ;
4543:
4544:
4545: cursor c_xdoi (c_xdo_id number) is