DBA Data[Home] [Help]

APPS.ENGECOBO dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2052: FROM hr_all_organization_units

2048: IF (eco_rec.responsible_organization_id IS NOT NULL) THEN
2049:
2050: SELECT name
2051: INTO l_department_name
2052: FROM hr_all_organization_units
2053: WHERE organization_id = eco_rec.responsible_organization_id;
2054:
2055: ELSE
2056:

Line 4392: FROM hr_all_organization_units

4388: IF (eco_rec.responsible_organization_id IS NOT NULL)
4389: THEN
4390: SELECT name
4391: INTO l_department_name
4392: FROM hr_all_organization_units
4393: WHERE organization_id = eco_rec.responsible_organization_id;
4394: ELSE
4395: l_department_name := NULL;
4396: END IF;

Line 6213: , hr_all_organization_units org

6209: CURSOR c_local_orgs IS
6210: SELECT eclo.local_organization_id
6211: FROM eng_engineering_changes eec
6212: , eng_change_local_orgs eclo
6213: , hr_all_organization_units org
6214: , hr_organization_information hoi
6215: , mtl_parameters mp
6216: WHERE eec.change_notice = p_change_notice
6217: AND eec.organization_id = p_organization_id