38: is
39: begin
40: select wip_entity_name
41: into G_WIP_ENTITY_NAME
42: from wip_entities
43: where wip_entity_id = p_wip_entity_id;
44:
45: select full_name
46: into G_EMPLOYEE
244: begin
245:
246: select organization_id
247: into l_org_id
248: from wip_entities
249: where wip_entity_id = p_wip_entity_id
250: and rownum=1;
251:
252: get_skill_parameters(l_org_id);