147: IF p_org_structure_id IS NOT NULL THEN
148: BEGIN
149: SELECT name
150: INTO l_structure_name
151: FROM per_organization_structures
152: WHERE organization_structure_id = p_org_structure_id;
153: EXCEPTION
154: WHEN OTHERS THEN
155: NULL;
525: IF p_org_structure_id IS NOT NULL THEN
526: BEGIN
527: SELECT name
528: INTO l_structure_name
529: FROM per_organization_structures
530: WHERE organization_structure_id = p_org_structure_id;
531: EXCEPTION
532: WHEN OTHERS THEN
533: NULL;
948: IF p_org_structure_id IS NOT NULL THEN
949: BEGIN
950: SELECT name
951: INTO l_structure_name
952: FROM per_organization_structures
953: WHERE organization_structure_id = p_org_structure_id;
954: EXCEPTION
955: WHEN OTHERS THEN
956: NULL;