APPS.AHL_UTIL_UC_PKG dependencies on HR_ALL_ORGANIZATION_UNITS

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

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

Line 122: FROM hr_all_organization_units

118:
119: -- Get Organization name.
120: CURSOR get_org_name_csr (p_organization_id IN NUMBER) IS
121: SELECT name
122: FROM hr_all_organization_units
123: WHERE organization_id = p_organization_id;
124:
125: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;
126: l_location VARCHAR2(2000);

Line 127: l_organization_name hr_all_organization_units.name%TYPE;

123: WHERE organization_id = p_organization_id;
124:
125: l_concatenated_segments mtl_item_locations_kfv.concatenated_segments%TYPE;
126: l_location VARCHAR2(2000);
127: l_organization_name hr_all_organization_units.name%TYPE;
128:
129:
130: BEGIN
131: -- Check location type code.