DBA Data[Home] [Help]

APPS.BEN_DETERMINE_COVERAGE dependencies on HR_LOCATIONS_ALL

Line 577: from hr_locations_all loc,

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'

Line 1727: from hr_locations_all loc,

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'