APPS.JTF_RS_CONC_RES_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 405: , hr_all_organization_units org

401: , asg.location_id address_id
402: , asg.assignment_id assignment_id
403: , asg.assignment_type assignment_type
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

Line 470: , hr_all_organization_units org

466: , asg.location_id address_id
467: , asg.assignment_id assignment_id
468: , asg.assignment_type assignment_type
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

Line 1587: FROM hr_all_organization_units

1583: l_assignment_type per_all_assignments_f.assignment_type%TYPE;
1584:
1585: CURSOR c_org(p_org_id IN NUMBER) IS
1586: SELECT name
1587: FROM hr_all_organization_units
1588: WHERE organization_id = p_org_id;
1589:
1590: CURSOR c_asg(p_person_id IN NUMBER) IS
1591: SELECT supervisor_id,

Line 3426: , hr_all_organization_units org

3422: , ppl.mailstop mailstop
3423: , ppl.party_id party_id
3424: FROM jtf_rs_resource_extns res
3425: , per_all_people_f ppl
3426: , hr_all_organization_units org
3427: WHERE res.resource_id = l_resource_id
3428: AND res.source_id = ppl.person_id
3429: and ppl.effective_start_date = (select max(effective_start_date)
3430: from per_all_people_f where person_id = ppl.person_id)

Line 3506: , hr_all_organization_units org

3502: , ppl.internal_location
3503: , ppl.party_id
3504: , ppl.mailstop
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