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_EXT_THREAD dependencies on HR_LOCATIONS_ALL

Line 4605: ' (select 1 from hr_locations_all loc where loc.location_id = ben_asg.location_id ' ||

4601: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||
4602: ' and group_val_01 is not null and group_val_01 = pay.payroll_name )) ' ;
4603: elsif l_pdl_val1 = 'PDLLOC' then
4604: l_dynamic_sql := l_dynamic_sql ||
4605: ' (select 1 from hr_locations_all loc where loc.location_id = ben_asg.location_id ' ||
4606: ' and to_date(''' || to_char(p_effective_date,'DD-MM-RRRR') ||
4607: ''',''DD-MM-RRRR'') between loc.effective_start_date and loc.effective_end_date ' ||
4608: ' and exists ( select group_val_01 from ben_ext_rslt_dtl erd where ' ||
4609: ' erd.ext_rslt_id = ' || p_ext_rslt_id ||

Line 4910: from hr_locations_all loc

4906:
4907:
4908: cursor c_loc(p_bg_id number ) is
4909: select loc.location_id
4910: from hr_locations_all loc
4911: where loc.business_group_id = p_bg_id
4912: or loc.business_group_id is null -- for global location
4913: ;
4914: