DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on HR_LOCATIONS_ALL

Line 601: from hr_locations_all loc,

597: l_opt c_opt%rowtype;
598: --
599: cursor c_state(cv_effective_date date) is -- FONM
600: select region_2
601: from hr_locations_all loc,
602: per_all_assignments_f asg
603: where loc.location_id = asg.location_id
604: and asg.person_id = p_person_id
605: and asg.primary_flag = 'Y'

Line 1766: from hr_locations_all loc,

1762: l_asg c_asg%rowtype;
1763: --
1764: cursor c_state (cv_effective_date date) is -- FONM
1765: select region_2
1766: from hr_locations_all loc,
1767: per_all_assignments_f asg
1768: where loc.location_id = asg.location_id
1769: and asg.person_id = l_epe.person_id
1770: and asg.primary_flag = 'Y'