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.JTF_RS_CONC_RES_PUB dependencies on HR_LOCATIONS

Line 408: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)

404: FROM per_all_people_f ppl
405: , hr_all_organization_units org
406: , per_all_assignments_f asg
407: , per_jobs job
408: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
409: , hr_locations_all loc
410: --, per_employees_current_x emp
411: , per_all_people_f emp
412: -- WHERE NOT EXISTS (select source_id

Line 409: , hr_locations_all loc

405: , hr_all_organization_units org
406: , per_all_assignments_f asg
407: , per_jobs job
408: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
409: , hr_locations_all loc
410: --, per_employees_current_x emp
411: , per_all_people_f emp
412: -- WHERE NOT EXISTS (select source_id
413: WHERE NOT EXISTS (select 1

Line 473: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)

469: FROM per_all_people_f ppl
470: , hr_all_organization_units org
471: , per_all_assignments_f asg
472: , per_jobs job
473: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
474: , hr_locations_all loc
475: --, per_employees_current_x emp
476: , per_all_people_f emp
477: -- WHERE NOT EXISTS (select source_id

Line 474: , hr_locations_all loc

470: , hr_all_organization_units org
471: , per_all_assignments_f asg
472: , per_jobs job
473: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
474: , hr_locations_all loc
475: --, per_employees_current_x emp
476: , per_all_people_f emp
477: -- WHERE NOT EXISTS (select source_id
478: WHERE NOT EXISTS (select 1

Line 1616: FROM hr_locations

1612: address_line_3,
1613: town_or_city,
1614: country,
1615: postal_code
1616: FROM hr_locations
1617: WHERE location_id = p_loc_id;
1618:
1619: l_loc_rec c_loc%ROWTYPE;
1620:

Line 3509: --, hr_locations loc

3505: FROM per_all_people_f ppl
3506: , hr_all_organization_units org
3507: --, per_all_assignments_f asg
3508: --, per_jobs job
3509: --, hr_locations loc
3510: --, per_employees_current_x emp
3511: WHERE res.source_id = ppl.person_id
3512: /* AND NOT EXISTS (SELECT EMPLOYEE_ID
3513: FROM PER_EMPLOYEES_CURRENT_X