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 511: ben_cwb_group_hrchy bcgh

507: Select bcpi.full_name,
508: bcpi.brief_name,
509: bcpi.custom_name
510: From ben_cwb_person_info bcpi,
511: ben_cwb_group_hrchy bcgh
512: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
513: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
514: from ben_cwb_group_hrchy
515: where emp_per_in_ler_id = p_emp_per_in_ler_id)

Line 514: from ben_cwb_group_hrchy

510: From ben_cwb_person_info bcpi,
511: ben_cwb_group_hrchy bcgh
512: where bcgh.emp_per_in_ler_id = p_emp_per_in_ler_id
513: and bcgh.lvl_num = (select max(lvl_num) - p_level + 1
514: from ben_cwb_group_hrchy
515: where emp_per_in_ler_id = p_emp_per_in_ler_id)
516: and bcgh.lvl_num > 0
517: and bcgh.mgr_per_in_ler_id = bcpi.group_per_in_ler_id;
518:

Line 2763: ben_cwb_group_hrchy hrchy

2759:
2760: cursor c_ws_mgr_name is
2761: select info.full_name, info.brief_name, info.custom_name
2762: from ben_cwb_person_info info,
2763: ben_cwb_group_hrchy hrchy
2764: where hrchy.emp_per_in_ler_id = p_group_per_in_ler_id
2765: and hrchy.mgr_per_in_ler_id = info.group_per_in_ler_id
2766: and hrchy.lvl_num = 1;
2767: begin