DBA Data[Home] [Help]

APPS.BEN_CWB_MTRX_UTILS dependencies on BEN_CWB_PL_DSGN

Line 185: ,ben_cwb_pl_dsgn Pl

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

Line 186: ,ben_cwb_pl_dsgn GrpPl

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)