8: TYPE accsegs IS RECORD(
9: l_segment igs_fi_acct_segs_v.segment%TYPE,
10: lv_Segment_num igs_fi_acct_segs_v.segment_num%TYPE,
11: lv_segment_value igs_ps_accts.segment_value%TYPE,
12: l_value_length fnd_flex_Value_Sets.maximum_size%TYPE);
13:
14: TYPE accsegs_list IS TABLE OF accsegs;
15:
16: g_accsegs accsegs_list := accsegs_list();
720: CURSOR cur_acc_segs
721: IS
722: SELECT seg.segment,seg.segment_num,val.maximum_size maximum_size
723: FROM igs_fi_acct_segs_v seg,
724: fnd_flex_value_sets val
725: WHERE seg.flex_value_set_id = val.flex_value_set_id
726: ORDER BY segment_num;
727:
728: -- cursor for selecting system fee type attached to the fee type that is passed as input to this procedure