APPS.AHL_APPR_SPACE_UNAVL_PVT dependencies on BOM_DEPARTMENTS

Line 106: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP

102: END IF;
103:
104: SELECT department_id
105: INTO x_department_id
106: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP
107: WHERE HAOU.organization_id = BMDP.organization_id
108: AND BMDP.organization_id = p_organization_id
109: AND BMDP.description = p_dept_description;
110: END IF;

Line 114: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP

110: END IF;
111: ELSE
112: SELECT department_id
113: INTO x_department_id
114: FROM HR_ALL_ORGANIZATION_UNITS HAOU, BOM_DEPARTMENTS BMDP
115: WHERE HAOU.organization_id = BMDP.organization_id
116: AND BMDP.organization_id = (SELECT organization_id
117: FROM HR_ALL_ORGANIZATION_UNITS
118: WHERE NAME = p_org_name)