DBA Data[Home] [Help]

APPS.BEN_CWB_MTRX_UTILS dependencies on BEN_CWB_XCHG

Line 187: ,ben_cwb_xchg Xchg

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