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 95: From ben_cwb_person_info bcpi,

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

Line 1723: from ben_cwb_person_info

1719: and rts.ws_val is not null
1720: and rts.elig_flag = 'Y';
1721: cursor c_prior_pay_proposal is
1722: select nvl(base_salary,0)
1723: from ben_cwb_person_info
1724: where group_per_in_ler_id = p_group_per_in_ler_id;
1725:
1726: begin
1727:

Line 1839: from ben_cwb_person_info

1835:
1836:
1837: cursor c_prior_pay_proposal_date is
1838: select BASE_SALARY_CHANGE_DATE
1839: from ben_cwb_person_info
1840: where group_per_in_ler_id = p_group_per_in_ler_id;
1841:
1842: begin
1843: -- *********

Line 2255: from ben_cwb_person_info info,

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