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.

[Home] [Help]

APPS.JTF_RS_CONC_RES_PUB dependencies on HR_LOCATIONS

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

346: FROM per_all_people_f ppl
347: , hr_all_organization_units org
348: , per_all_assignments_f asg
349: , per_jobs job
350: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
351: , hr_locations_all loc
352: --, per_employees_current_x emp
353: , per_all_people_f emp
354: -- WHERE NOT EXISTS (select source_id

Line 351: , hr_locations_all loc

347: , hr_all_organization_units org
348: , per_all_assignments_f asg
349: , per_jobs job
350: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
351: , hr_locations_all loc
352: --, per_employees_current_x emp
353: , per_all_people_f emp
354: -- WHERE NOT EXISTS (select source_id
355: WHERE NOT EXISTS (select 1

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

411: FROM per_all_people_f ppl
412: , hr_all_organization_units org
413: , per_all_assignments_f asg
414: , per_jobs job
415: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
416: , hr_locations_all loc
417: --, per_employees_current_x emp
418: , per_all_people_f emp
419: -- WHERE NOT EXISTS (select source_id

Line 416: , hr_locations_all loc

412: , hr_all_organization_units org
413: , per_all_assignments_f asg
414: , per_jobs job
415: --, hr_locations loc (SQL rep perf bug 4956611 Nishant 28-Mar-2006)
416: , hr_locations_all loc
417: --, per_employees_current_x emp
418: , per_all_people_f emp
419: -- WHERE NOT EXISTS (select source_id
420: WHERE NOT EXISTS (select 1

Line 1548: FROM hr_locations

1544: address_line_3,
1545: town_or_city,
1546: country,
1547: postal_code
1548: FROM hr_locations
1549: WHERE location_id = p_loc_id;
1550:
1551: l_loc_rec c_loc%ROWTYPE;
1552:

Line 3058: --, hr_locations loc

3054: FROM per_all_people_f ppl
3055: , hr_all_organization_units org
3056: --, per_all_assignments_f asg
3057: --, per_jobs job
3058: --, hr_locations loc
3059: --, per_employees_current_x emp
3060: WHERE res.source_id = ppl.person_id
3061: /* AND NOT EXISTS (SELECT EMPLOYEE_ID
3062: FROM PER_EMPLOYEES_CURRENT_X