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_COBRA_REQUIREMENTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 491: from hr_locations_all loc,per_all_assignments_f asg

487: l_regn_id number;
488: --
489: cursor c_state is
490: select loc.region_2,asg.assignment_id,asg.organization_id
491: from hr_locations_all loc,per_all_assignments_f asg
492: where loc.location_id(+) = asg.location_id
493: and asg.person_id = p_person_id
494: and asg.assignment_type <> 'C'
495: and asg.primary_flag = 'Y'

Line 1024: from hr_locations_all loc,per_all_assignments_f asg

1020: l_jurisdiction_code varchar2(30);
1021: --
1022: cursor c_state is
1023: select loc.region_2,asg.assignment_id,asg.organization_id
1024: from hr_locations_all loc,per_all_assignments_f asg
1025: where loc.location_id(+) = asg.location_id
1026: and asg.assignment_type <> 'C'
1027: and asg.person_id = p_person_id
1028: and asg.primary_flag = 'Y'