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

Line 233: from hr_locations_all loc,per_all_assignments_f asg

229: l_package varchar2(80) := g_package||'.compute_premium';
230: -- fonm new p_date param added
231: Cursor c_state (p_date date) is
232: select region_2
233: from hr_locations_all loc,per_all_assignments_f asg
234: where loc.location_id = asg.location_id
235: and asg.person_id = p_person_id
236: and asg.assignment_type <> 'C'
237: and asg.primary_flag = 'Y'

Line 246: from per_all_assignments_f asg,hr_locations_all loc, per_assignment_status_types ast

242: --
243: -- fonm new p_date param added
244: cursor c_asg(p_date date) is
245: select asg.assignment_id,asg.organization_id,loc.region_2
246: from per_all_assignments_f asg,hr_locations_all loc, per_assignment_status_types ast
247: where asg.person_id = p_person_id
248: and asg.assignment_type <> 'C'
249: and asg.primary_flag = 'Y'
250: and asg.location_id = loc.location_id(+)