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
227: begin
228:
229: select organization_id
230: into l_org_id
231: from wip_entities
232: where wip_entity_id = p_wip_entity_id
233: and rownum=1;
234:
235: get_skill_parameters(l_org_id);