APPS.BEN_EXT_THREAD dependencies on BEN_EXT_FLD

Line 380: from ben_ext_fld exf,

376:
377: cursor c_ext_elmt (p_data_elmt_in_rcd_id number
378: ) is
379: select exf.short_name
380: from ben_ext_fld exf,
381: ben_Ext_data_elmt_in_rcd edr,
382: ben_ext_data_elmt ede
383: where edr.ext_data_elmt_in_rcd_id = p_data_elmt_in_rcd_id
384: and edr.ext_data_elmt_id = ede.ext_Data_elmt_id

Line 521: FROM ben_ext_data_elmt_in_rcd elrc, ben_ext_data_elmt elmt, ben_ext_fld fld

517: and rcd.rcd_type_cd in ('H','T');
518: --
519: cursor c_data_elmt_seq_num(p_ext_rcd_id number) is
520: SELECT elrc.seq_num, fld.short_name, elmt.frmt_mask_cd
521: FROM ben_ext_data_elmt_in_rcd elrc, ben_ext_data_elmt elmt, ben_ext_fld fld
522: WHERE elrc.ext_rcd_id = p_ext_rcd_id
523: and elrc.ext_data_elmt_id = elmt.ext_data_elmt_id
524: and elmt.ext_fld_id = fld.ext_fld_id
525: and ltrim(rtrim(fld.short_name)) in ('STRTDT','ENDDT');

Line 1096: ben_ext_fld efl

1092: , xel.ttl_cond_ext_data_elmt_id
1093: , efl.short_name
1094: from ben_Ext_where_clause ewc,
1095: ben_Ext_data_elmt xel,
1096: ben_ext_fld efl
1097: where ewc.ext_data_elmt_id = p_ext_data_elmt_id
1098: and xel.ext_data_elmt_id = ewc.cond_ext_data_elmt_id
1099: and xel.ext_fld_id = efl.ext_fld_id (+) ;
1100: begin

Line 1234: ben_ext_fld c

1230: b.ttl_cond_ext_data_elmt_id,
1231: c.short_name
1232: from ben_ext_data_elmt_in_rcd a,
1233: ben_ext_data_elmt b,
1234: ben_ext_fld c
1235: where a.ext_rcd_id = l_ext_rcd_id
1236: and a.ext_data_elmt_id = b.ext_data_elmt_id
1237: and b.ext_fld_id = c.ext_fld_id (+)
1238: order by a.seq_num;