DBA Data[Home] [Help]

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on HR_LOCATIONS_ALL

Line 435: from hr_locations_all loc,per_all_assignments_f asg

431: --
432: -- FONM
433: Cursor c_state(cv_effective_date date) is
434: select loc.region_2
435: from hr_locations_all loc,per_all_assignments_f asg
436: where loc.location_id = asg.location_id
437: and asg.person_id = p_person_id
438: and asg.assignment_type <> 'C'
439: and asg.primary_flag = 'Y'