42: l_not_hash_found boolean;
43: --
44: cursor c_los_look is
45: select los.los_fctr_id, los.business_group_id
46: from ben_los_fctr los
47: where exists
48: (select null
49: from ben_los_fctr los
50: where
45: select los.los_fctr_id, los.business_group_id
46: from ben_los_fctr los
47: where exists
48: (select null
49: from ben_los_fctr los
50: where
51: los.los_fctr_id = los.los_fctr_id)
52: order by los.los_fctr_id;
53: --
56: los.mx_los_num,
57: los.mn_los_num,
58: los.no_mn_los_num_apls_flag,
59: los.no_mx_los_num_apls_flag
60: from ben_los_fctr los
61: order by los.los_fctr_id
62: , los.los_fctr_id;
63: --
64: begin