APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on HR_LOCATIONS_ALL

Line 225: from hr_locations_all loc,per_all_assignments_f asg

221: l_package varchar2(80) := g_package||'.compute_premium';
222: -- fonm new p_date param added
223: Cursor c_state (p_date date) is
224: select region_2
225: from hr_locations_all loc,per_all_assignments_f asg
226: where loc.location_id = asg.location_id
227: and asg.person_id = p_person_id
228: and asg.assignment_type <> 'C'
229: and asg.primary_flag = 'Y'

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

234: --
235: -- fonm new p_date param added
236: cursor c_asg(p_date date) is
237: select asg.assignment_id,asg.organization_id,loc.region_2
238: from per_all_assignments_f asg,hr_locations_all loc, per_assignment_status_types ast
239: where asg.person_id = p_person_id
240: and asg.assignment_type <> 'C'
241: and asg.primary_flag = 'Y'
242: and asg.location_id = loc.location_id(+)