APPS.HXC_GET_NAME dependencies on PER_PEOPLE_X

Line 10: l_full_name per_people_x.full_name%type;

6: -- ----------------------------------------------------------------------------+
7: FUNCTION get_name
8: (p_person_id in number) Return varchar2 is
9:
10: l_full_name per_people_x.full_name%type;
11:
12: Cursor c_person is
13: Select ppx.full_name
14: from per_people_x ppx

Line 14: from per_people_x ppx

10: l_full_name per_people_x.full_name%type;
11:
12: Cursor c_person is
13: Select ppx.full_name
14: from per_people_x ppx
15: where person_id = p_person_id;
16:
17: BEGIN
18:

Line 20: from per_people_x ppx

16:
17: BEGIN
18:
19: /* Select ppx.full_name into l_full_name
20: from per_people_x ppx
21: where ppx.person_id = p_person_id;*/
22:
23: if c_person%ISOPEN then
24: close c_person;