DBA Data[Home] [Help]

APPS.BEN_CWB_MTRX_UTILS dependencies on BEN_CWB_GROUP_HRCHY

Line 188: ,ben_cwb_group_hrchy Hrchy

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)
191: or (Hrchy.lvl_num = 1 and Hrchy.mgr_per_in_ler_id = c_acting_mgr_pil_id))
192: and Rates.group_per_in_ler_id = Hrchy.emp_per_in_ler_id