DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on PER_ALL_ASSIGNMENTS_F

Line 642: from per_all_assignments_f asg,hr_locations_all loc

638: l_ecf c_ecf_pl%rowtype;
639: --
640: cursor c_asg is
641: select asg.assignment_id,asg.organization_id,loc.region_2
642: from per_all_assignments_f asg,hr_locations_all loc
643: where asg.person_id = p_person_id
644: and asg.assignment_type <> 'C'
645: and asg.primary_flag = 'Y'
646: and asg.location_id = loc.location_id(+)