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 HR_LOCATIONS_ALL

Line 509: from hr_locations_all loc,per_all_assignments_f asg

505: l_regn_id number;
506: --
507: cursor c_state is
508: select loc.region_2,asg.assignment_id,asg.organization_id
509: from hr_locations_all loc,per_all_assignments_f asg
510: where loc.location_id(+) = asg.location_id
511: and asg.person_id = p_person_id
512: and asg.assignment_type <> 'C'
513: and asg.primary_flag = 'Y'

Line 1042: from hr_locations_all loc,per_all_assignments_f asg

1038: l_jurisdiction_code varchar2(30);
1039: --
1040: cursor c_state is
1041: select loc.region_2,asg.assignment_id,asg.organization_id
1042: from hr_locations_all loc,per_all_assignments_f asg
1043: where loc.location_id(+) = asg.location_id
1044: and asg.assignment_type <> 'C'
1045: and asg.person_id = p_person_id
1046: and asg.primary_flag = 'Y'