APPS.BEN_EXT_THREAD dependencies on BEN_EXT_DATA_ELMT_IN_RCD

Line 381: ben_Ext_data_elmt_in_rcd edr,

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
385: and ede.ext_fld_id = exf.ext_fld_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 1232: from ben_ext_data_elmt_in_rcd a,

1228: b.ttl_cond_val,
1229: b.ttl_sum_ext_data_elmt_id,
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