DBA Data[Home] [Help]

APPS.BENUTILS dependencies on BEN_CWB_GROUP_HRCHY

Line 5933: ben_cwb_group_hrchy bcgh

5929: Select bcpi.full_name,
5930: bcpi.brief_name,
5931: bcpi.custom_name
5932: From ben_cwb_person_info bcpi,
5933: ben_cwb_group_hrchy bcgh
5934: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
5935: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
5936: from ben_cwb_group_hrchy
5937: where emp_per_in_ler_id = p_emp_per_in_ler_id)

Line 5936: from ben_cwb_group_hrchy

5932: From ben_cwb_person_info bcpi,
5933: ben_cwb_group_hrchy bcgh
5934: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
5935: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
5936: from ben_cwb_group_hrchy
5937: where emp_per_in_ler_id = p_emp_per_in_ler_id)
5938: and bcgh.lvl_num > 0
5939: and bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id;
5940: