DBA Data[Home] [Help]

APPS.BEN_CWB_BDGT_CHNG_POP dependencies on BEN_CWB_GROUP_HRCHY

Line 34: From ben_cwb_group_hrchy Hrchy,

30: Select max(Hrchy.emp_per_in_ler_id) GrpLerId,
31: max(Grp.group_pl_id) GrpPlId,
32: max(Grp.group_oipl_id) GrpOiplId,
33: max(Grp.object_version_number) Ovn
34: From ben_cwb_group_hrchy Hrchy,
35: ben_cwb_person_groups Grp,
36: ben_cwb_summary Summ
37: Where Hrchy.mgr_per_in_ler_id = c_group_per_in_ler_id
38: and Hrchy.lvl_num > 0