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_PERSON_INFO

Line 510: From ben_cwb_person_info bcpi,

506: is
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

Line 2230: from ben_cwb_person_info

2226: and rts.ws_val is not null
2227: and rts.elig_flag = 'Y';
2228: cursor c_prior_pay_proposal is
2229: select nvl(base_salary,0)
2230: from ben_cwb_person_info
2231: where group_per_in_ler_id = p_group_per_in_ler_id;
2232:
2233: begin
2234:

Line 2346: from ben_cwb_person_info

2342:
2343:
2344: cursor c_prior_pay_proposal_date is
2345: select BASE_SALARY_CHANGE_DATE
2346: from ben_cwb_person_info
2347: where group_per_in_ler_id = p_group_per_in_ler_id;
2348:
2349: begin
2350: -- *********

Line 2762: from ben_cwb_person_info info,

2758: procedure populate_ws_mgr(p_group_per_in_ler_id in number) is
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;