DBA Data[Home] [Help]

APPS.BEN_DETERMINE_CHC_CTFN dependencies on HR_LOCATIONS_ALL

Line 644: from per_all_assignments_f asg,hr_locations_all loc

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