APPS.JTF_RS_CONC_RES_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 347: , hr_all_organization_units org

343: , asg.location_id address_id
344: , asg.assignment_id assignment_id
345: , asg.assignment_type assignment_type
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

Line 412: , hr_all_organization_units org

408: , asg.location_id address_id
409: , asg.assignment_id assignment_id
410: , asg.assignment_type assignment_type
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

Line 1519: FROM hr_all_organization_units

1515: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1516:
1517: CURSOR c_org(p_org_id IN NUMBER) IS
1518: SELECT name
1519: FROM hr_all_organization_units
1520: WHERE organization_id = p_org_id;
1521:
1522: CURSOR c_asg(p_person_id IN NUMBER) IS
1523: SELECT supervisor_id,

Line 2975: , hr_all_organization_units org

2971: , ppl.mailstop mailstop
2972: , ppl.party_id party_id
2973: FROM jtf_rs_resource_extns res
2974: , per_all_people_f ppl
2975: , hr_all_organization_units org
2976: WHERE res.resource_id = l_resource_id
2977: AND res.source_id = ppl.person_id
2978: and ppl.effective_start_date = (select max(effective_start_date)
2979: from per_all_people_f where person_id = ppl.person_id)

Line 3055: , hr_all_organization_units org

3051: , ppl.internal_location
3052: , ppl.party_id
3053: , ppl.mailstop
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