21: if ( p_person_id is not null) then
22:
23: -- Perf Rep - SQL ID: 3168839
24: -- select full_name into l_person_name
25: -- from per_all_people_f
26: -- where to_char(person_id) = p_person_id;
27:
28: select full_name into l_person_name
29: from per_all_people_f
25: -- from per_all_people_f
26: -- where to_char(person_id) = p_person_id;
27:
28: select full_name into l_person_name
29: from per_all_people_f
30: where person_id = to_number(p_person_id);
31:
32: end if;
33:
229:
230: if (l_supervisor_id is not null) then
231:
232: select full_name into l_person_name
233: from per_all_people_f
234: where person_id = l_supervisor_id ;
235: end if;
236: end if;
237:
349: l_bg_id := null;
350:
351: if ( p_person_id is not null) then
352: select business_group_id into l_bg_id
353: from per_all_people_f
354: where person_id = p_person_id;
355:
356: if (l_bg_id is not null) then
357: select name into l_bg_name