eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_EXT_ADV_CONDITIONS dependencies on BEN_EXT_DATA_ELMT

Line 166: ben_ext_data_elmt_in_rcd xer,

162: xel.ext_fld_id,
163: fld.frmt_mask_typ_cd,
164: xer.ext_rcd_id
165: from ben_ext_where_clause xwc,
166: ben_ext_data_elmt_in_rcd xer,
167: ben_ext_rcd xrc,
168: ben_ext_data_elmt xel,
169: ben_ext_fld fld
170: where xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id

Line 168: ben_ext_data_elmt xel,

164: xer.ext_rcd_id
165: from ben_ext_where_clause xwc,
166: ben_ext_data_elmt_in_rcd xer,
167: ben_ext_rcd xrc,
168: ben_ext_data_elmt xel,
169: ben_ext_fld fld
170: where xwc.ext_rcd_in_file_id = p_ext_rcd_in_file_id
171: and xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
172: and xer.ext_rcd_id = xrc.ext_rcd_id

Line 182: from ben_ext_data_elmt_in_rcd xer,

178:
179: cursor c_cond_xwc(p_ext_data_elmt_id number,
180: p_Ext_rcd_id number) is
181: select xer.seq_num
182: from ben_ext_data_elmt_in_rcd xer,
183: ben_ext_data_elmt xel,
184: ben_ext_fld fld
185: where xer.ext_rcd_id = p_Ext_rcd_id
186: and xel.ext_data_elmt_id = xer.ext_data_elmt_id

Line 183: ben_ext_data_elmt xel,

179: cursor c_cond_xwc(p_ext_data_elmt_id number,
180: p_Ext_rcd_id number) is
181: select xer.seq_num
182: from ben_ext_data_elmt_in_rcd xer,
183: ben_ext_data_elmt xel,
184: ben_ext_fld fld
185: where xer.ext_rcd_id = p_Ext_rcd_id
186: and xel.ext_data_elmt_id = xer.ext_data_elmt_id
187: and xel.ext_data_elmt_id = p_ext_data_elmt_id

Line 492: from ben_ext_data_elmt_in_rcd xer,

488: select xer.seq_num,
489: xer.sprs_cd,
490: xer.ext_data_elmt_in_rcd_id,
491: xdm.name
492: from ben_ext_data_elmt_in_rcd xer,
493: ben_ext_data_elmt xdm
494: where ext_rcd_id = p_ext_rcd_id
495: and xer.sprs_cd is not null
496: and xer.ext_data_elmt_id = xdm.ext_data_elmt_id ;

Line 493: ben_ext_data_elmt xdm

489: xer.sprs_cd,
490: xer.ext_data_elmt_in_rcd_id,
491: xdm.name
492: from ben_ext_data_elmt_in_rcd xer,
493: ben_ext_data_elmt xdm
494: where ext_rcd_id = p_ext_rcd_id
495: and xer.sprs_cd is not null
496: and xer.ext_data_elmt_id = xdm.ext_data_elmt_id ;
497: --

Line 511: ben_ext_data_elmt_in_rcd xer,

507: xel.data_elmt_rl,
508: xer.ext_rcd_id ,
509: fld.frmt_mask_typ_cd
510: from ben_ext_where_clause xwc,
511: ben_ext_data_elmt_in_rcd xer,
512: ben_ext_data_elmt xel,
513: ben_ext_fld fld
514: where xwc.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
515: and xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id

Line 512: ben_ext_data_elmt xel,

508: xer.ext_rcd_id ,
509: fld.frmt_mask_typ_cd
510: from ben_ext_where_clause xwc,
511: ben_ext_data_elmt_in_rcd xer,
512: ben_ext_data_elmt xel,
513: ben_ext_fld fld
514: where xwc.ext_data_elmt_in_rcd_id = p_ext_data_elmt_in_rcd_id
515: and xwc.cond_ext_data_elmt_in_rcd_id = xer.ext_data_elmt_in_rcd_id
516: and xel.ext_data_elmt_id = xer.ext_data_elmt_id

Line 523: from ben_ext_data_elmt_in_rcd xer,

519: --
520: cursor c_cond_xwc(p_ext_data_elmt_id number,
521: p_Ext_rcd_id number) is
522: select xer.seq_num
523: from ben_ext_data_elmt_in_rcd xer,
524: ben_ext_data_elmt xel,
525: ben_ext_fld fld
526: where xer.ext_rcd_id = p_Ext_rcd_id
527: and xel.ext_data_elmt_id = xer.ext_data_elmt_id

Line 524: ben_ext_data_elmt xel,

520: cursor c_cond_xwc(p_ext_data_elmt_id number,
521: p_Ext_rcd_id number) is
522: select xer.seq_num
523: from ben_ext_data_elmt_in_rcd xer,
524: ben_ext_data_elmt xel,
525: ben_ext_fld fld
526: where xer.ext_rcd_id = p_Ext_rcd_id
527: and xel.ext_data_elmt_id = xer.ext_data_elmt_id
528: and xel.ext_data_elmt_id = p_ext_data_elmt_id