DBA Data[Home] [Help]

APPS.BEN_DETERMINE_VARIABLE_RATES dependencies on HR_LOCATIONS_ALL

Line 401: from hr_locations_all loc,per_all_assignments_f asg

397: --
398: -- FONM
399: Cursor c_state(cv_effective_date date) is
400: select loc.region_2
401: from hr_locations_all loc,per_all_assignments_f asg
402: where loc.location_id = asg.location_id
403: and asg.person_id = p_person_id
404: and asg.assignment_type <> 'C'
405: and asg.primary_flag = 'Y'