eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_UTILS dependencies on BEN_CWB_GROUP_HRCHY

Line 96: ben_cwb_group_hrchy bcgh

92: Select bcpi.full_name,
93: bcpi.brief_name,
94: bcpi.custom_name
95: From ben_cwb_person_info bcpi,
96: ben_cwb_group_hrchy bcgh
97: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
98: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
99: from ben_cwb_group_hrchy
100: where emp_per_in_ler_id = p_emp_per_in_ler_id)

Line 99: from ben_cwb_group_hrchy

95: From ben_cwb_person_info bcpi,
96: ben_cwb_group_hrchy bcgh
97: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
98: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
99: from ben_cwb_group_hrchy
100: where emp_per_in_ler_id = p_emp_per_in_ler_id)
101: and bcgh.lvl_num > 0
102: and bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id;
103:

Line 2256: ben_cwb_group_hrchy hrchy

2252:
2253: cursor c_ws_mgr_name is
2254: select info.full_name, info.brief_name, info.custom_name
2255: from ben_cwb_person_info info,
2256: ben_cwb_group_hrchy hrchy
2257: where hrchy.emp_per_in_ler_id = p_group_per_in_ler_id
2258: and hrchy.mgr_per_in_ler_id = info.group_per_in_ler_id
2259: and hrchy.lvl_num = 1;
2260: begin