DBA Data[Home] [Help]

APPS.BENUTILS dependencies on BEN_CWB_GROUP_HRCHY

Line 6058: ben_cwb_group_hrchy bcgh

6054: Select bcpi.full_name,
6055: bcpi.brief_name,
6056: bcpi.custom_name
6057: From ben_cwb_person_info bcpi,
6058: ben_cwb_group_hrchy bcgh
6059: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
6060: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
6061: from ben_cwb_group_hrchy
6062: where emp_per_in_ler_id = p_emp_per_in_ler_id)

Line 6061: from ben_cwb_group_hrchy

6057: From ben_cwb_person_info bcpi,
6058: ben_cwb_group_hrchy bcgh
6059: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
6060: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
6061: from ben_cwb_group_hrchy
6062: where emp_per_in_ler_id = p_emp_per_in_ler_id)
6063: and bcgh.lvl_num > 0
6064: and bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id;
6065: