APPS.AHL_UTIL_UC_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

Line 118: FROM csi_lookups f, hr_all_organization_units hou, wip_entities wip_ent

114:
115: -- if location is WIP.
116: CURSOR wip_entity_csr(p_wip_job_id IN NUMBER) IS
117: SELECT f.meaning || ';' || hou.name
118: FROM csi_lookups f, hr_all_organization_units hou, wip_entities wip_ent
119: WHERE wip_ent.organization_id = hou.organization_id
120: AND wip_ent.wip_entity_id = p_wip_job_id
121: AND f.lookup_code = 'WIP'
122: AND f.lookup_type = 'CSI_INST_LOCATION_SOURCE_CODE';

Line 127: FROM hr_all_organization_units

123:
124: -- Get Organization name.
125: CURSOR get_org_name_csr (p_organization_id IN NUMBER) IS
126: SELECT name
127: FROM hr_all_organization_units
128: WHERE organization_id = p_organization_id;
129:
130: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;
131: l_location VARCHAR2(2000);

Line 132: l_organization_name hr_all_organization_units.name%TYPE;

128: WHERE organization_id = p_organization_id;
129:
130: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;
131: l_location VARCHAR2(2000);
132: l_organization_name hr_all_organization_units.name%TYPE;
133:
134:
135: BEGIN
136: -- Check location type code.