181: ,max(Pl.rec_nnmntry_uom) nn_mntry
182: ,max(Pl.rec_rndg_cd) rndg_cd
183: ,max(Rates.assignment_id) assignment_id
184: from ben_cwb_person_rates Rates
185: ,ben_cwb_pl_dsgn Pl
186: ,ben_cwb_pl_dsgn GrpPl
187: ,ben_cwb_xchg Xchg
188: ,ben_cwb_group_hrchy Hrchy
189: where Hrchy.mgr_per_in_ler_id = c_mgr_pil_id
182: ,max(Pl.rec_rndg_cd) rndg_cd
183: ,max(Rates.assignment_id) assignment_id
184: from ben_cwb_person_rates Rates
185: ,ben_cwb_pl_dsgn Pl
186: ,ben_cwb_pl_dsgn GrpPl
187: ,ben_cwb_xchg Xchg
188: ,ben_cwb_group_hrchy Hrchy
189: where Hrchy.mgr_per_in_ler_id = c_mgr_pil_id
190: and ((Hrchy.lvl_num between 1 and c_lvl_num and Hrchy.mgr_per_in_ler_id <> c_acting_mgr_pil_id)