eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_ENROLMENT_REQUIREMENTS dependencies on HR_LOCATIONS_ALL

Line 1511: FROM hr_locations_all loc, per_all_assignments_f asg

1507: --
1508: --
1509: CURSOR c_state IS
1510: SELECT loc.region_2
1511: FROM hr_locations_all loc, per_all_assignments_f asg
1512: WHERE loc.location_id = asg.location_id
1513: AND asg.person_id = p_person_id
1514: and asg.assignment_type <> 'C'
1515: AND asg.primary_flag = 'Y'

Line 2749: FROM hr_locations_all loc, per_all_assignments_f asg

2745: AND bpt.business_group_id = p_business_group_id;
2746: --
2747: CURSOR c_state IS
2748: SELECT loc.region_2
2749: FROM hr_locations_all loc, per_all_assignments_f asg
2750: WHERE loc.location_id = asg.location_id
2751: AND asg.person_id = p_person_id
2752: and asg.assignment_type <> 'C'
2753: AND asg.primary_flag = 'Y'

Line 8035: FROM hr_locations_all loc, per_all_assignments_f asg

8031:
8032: --
8033: CURSOR c_state IS
8034: SELECT loc.region_2
8035: FROM hr_locations_all loc, per_all_assignments_f asg
8036: WHERE loc.location_id = asg.location_id
8037: AND asg.person_id = p_person_id
8038: and asg.assignment_type <> 'C'
8039: AND asg.primary_flag = 'Y'