DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on PER_ASSIGNMENT_STATUS_TYPES

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(+)