DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2033: FROM hr_all_organization_units

2029: IF (eco_rec.responsible_organization_id IS NOT NULL) THEN
2030:
2031: SELECT name
2032: INTO l_department_name
2033: FROM hr_all_organization_units
2034: WHERE organization_id = eco_rec.responsible_organization_id;
2035:
2036: ELSE
2037:

Line 4267: FROM hr_all_organization_units

4263: IF (eco_rec.responsible_organization_id IS NOT NULL)
4264: THEN
4265: SELECT name
4266: INTO l_department_name
4267: FROM hr_all_organization_units
4268: WHERE organization_id = eco_rec.responsible_organization_id;
4269: ELSE
4270: l_department_name := NULL;
4271: END IF;

Line 5740: , hr_all_organization_units org

5736: CURSOR c_local_orgs IS
5737: SELECT eclo.local_organization_id
5738: FROM eng_engineering_changes eec
5739: , eng_change_local_orgs eclo
5740: , hr_all_organization_units org
5741: , hr_organization_information hoi
5742: , mtl_parameters mp
5743: WHERE eec.change_notice = p_change_notice
5744: AND eec.organization_id = p_organization_id