DBA Data[Home] [Help]

APPS.BEN_DETERMINE_ACTUAL_PREMIUM dependencies on PER_ASSIGNMENT_STATUS_TYPES

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