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_EXTRACT_SEED dependencies on HR_LOCATIONS

Line 406: cursor c5 is select location_code from hr_locations

402: cursor c4 is SELECT name from PER_ORGANIZATION_UNITS
403: WHERE internal_external_flag = 'INT'
404: and organization_id = p_val;
405:
406: cursor c5 is select location_code from hr_locations
407: where trunc(sysdate) <=
408: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
409: and location_id = p_val;
410:

Line 1171: cursor c5 is select location_id from hr_locations

1167: and nvl(date_to,trunc(sysdate))
1168: and internal_external_flag = 'INT'
1169: and name = p_meaning;
1170:
1171: cursor c5 is select location_id from hr_locations
1172: where trunc(sysdate) <=
1173: nvl(inactive_date,to_date('31124712','DDMMYYYY'))
1174: and location_code = p_meaning ;
1175: