[Home] [Help]
375: cursor c_ext_elmt (p_data_elmt_in_rcd_id number
376: ) is
377: select exf.short_name
378: from ben_ext_fld exf,
379: ben_Ext_data_elmt_in_rcd edr,
380: ben_ext_data_elmt ede
381: where edr.ext_data_elmt_in_rcd_id = p_data_elmt_in_rcd_id
382: and edr.ext_data_elmt_id = ede.ext_Data_elmt_id
383: and ede.ext_fld_id = exf.ext_fld_id (+)
376: ) is
377: select exf.short_name
378: from ben_ext_fld exf,
379: ben_Ext_data_elmt_in_rcd edr,
380: ben_ext_data_elmt ede
381: where edr.ext_data_elmt_in_rcd_id = p_data_elmt_in_rcd_id
382: and edr.ext_data_elmt_id = ede.ext_Data_elmt_id
383: and ede.ext_fld_id = exf.ext_fld_id (+)
384: ;
515: and rcd.rcd_type_cd in ('H','T');
516: --
517: cursor c_data_elmt_seq_num(p_ext_rcd_id number) is
518: SELECT elrc.seq_num, fld.short_name, elmt.frmt_mask_cd
519: FROM ben_ext_data_elmt_in_rcd elrc, ben_ext_data_elmt elmt, ben_ext_fld fld
520: WHERE elrc.ext_rcd_id = p_ext_rcd_id
521: and elrc.ext_data_elmt_id = elmt.ext_data_elmt_id
522: and elmt.ext_fld_id = fld.ext_fld_id
523: and ltrim(rtrim(fld.short_name)) in ('STRTDT','ENDDT');
1089: , xel.ttl_sum_ext_data_elmt_id
1090: , xel.ttl_cond_ext_data_elmt_id
1091: , efl.short_name
1092: from ben_Ext_where_clause ewc,
1093: ben_Ext_data_elmt xel,
1094: ben_ext_fld efl
1095: where ewc.ext_data_elmt_id = p_ext_data_elmt_id
1096: and xel.ext_data_elmt_id = ewc.cond_ext_data_elmt_id
1097: and xel.ext_fld_id = efl.ext_fld_id (+) ;
1226: b.ttl_cond_val,
1227: b.ttl_sum_ext_data_elmt_id,
1228: b.ttl_cond_ext_data_elmt_id,
1229: c.short_name
1230: from ben_ext_data_elmt_in_rcd a,
1231: ben_ext_data_elmt b,
1232: ben_ext_fld c
1233: where a.ext_rcd_id = l_ext_rcd_id
1234: and a.ext_data_elmt_id = b.ext_data_elmt_id
1227: b.ttl_sum_ext_data_elmt_id,
1228: b.ttl_cond_ext_data_elmt_id,
1229: c.short_name
1230: from ben_ext_data_elmt_in_rcd a,
1231: ben_ext_data_elmt b,
1232: ben_ext_fld c
1233: where a.ext_rcd_id = l_ext_rcd_id
1234: and a.ext_data_elmt_id = b.ext_data_elmt_id
1235: and b.ext_fld_id = c.ext_fld_id (+)