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 1538: FROM hr_locations_all loc, per_all_assignments_f asg

1534: --
1535: --
1536: CURSOR c_state IS
1537: SELECT loc.region_2
1538: FROM hr_locations_all loc, per_all_assignments_f asg
1539: WHERE loc.location_id = asg.location_id
1540: AND asg.person_id = p_person_id
1541: and asg.assignment_type <> 'C'
1542: AND asg.primary_flag = 'Y'

Line 2780: FROM hr_locations_all loc, per_all_assignments_f asg

2776: AND bpt.business_group_id = p_business_group_id;
2777: --
2778: CURSOR c_state IS
2779: SELECT loc.region_2
2780: FROM hr_locations_all loc, per_all_assignments_f asg
2781: WHERE loc.location_id = asg.location_id
2782: AND asg.person_id = p_person_id
2783: and asg.assignment_type <> 'C'
2784: AND asg.primary_flag = 'Y'

Line 8172: FROM hr_locations_all loc, per_all_assignments_f asg

8168:
8169: --
8170: CURSOR c_state IS
8171: SELECT loc.region_2
8172: FROM hr_locations_all loc, per_all_assignments_f asg
8173: WHERE loc.location_id = asg.location_id
8174: AND asg.person_id = p_person_id
8175: and asg.assignment_type <> 'C'
8176: AND asg.primary_flag = 'Y'