573: l_opt c_opt%rowtype;
574: --
575: cursor c_state(cv_effective_date date) is -- FONM
576: select region_2
577: from hr_locations_all loc,
578: per_all_assignments_f asg
579: where loc.location_id = asg.location_id
580: and asg.person_id = p_person_id
581: and asg.primary_flag = 'Y'
1723: l_asg c_asg%rowtype;
1724: --
1725: cursor c_state (cv_effective_date date) is -- FONM
1726: select region_2
1727: from hr_locations_all loc,
1728: per_all_assignments_f asg
1729: where loc.location_id = asg.location_id
1730: and asg.person_id = l_epe.person_id
1731: and asg.primary_flag = 'Y'