14: x_person_name VARCHAR2(240);
15:
16: BEGIN
17:
18: -- Bug 8901874. Modified query to fetch data from table per_all_people_f.
19: SELECT full_name
20: INTO x_person_name
21: FROM PER_ALL_PEOPLE_F
22: WHERE x_person_id = person_id
17:
18: -- Bug 8901874. Modified query to fetch data from table per_all_people_f.
19: SELECT full_name
20: INTO x_person_name
21: FROM PER_ALL_PEOPLE_F
22: WHERE x_person_id = person_id
23: AND EFFECTIVE_END_DATE >= ALL(SELECT EFFECTIVE_END_DATE
24: FROM PER_ALL_PEOPLE_F
25: WHERE PERSON_ID=x_person_id);
20: INTO x_person_name
21: FROM PER_ALL_PEOPLE_F
22: WHERE x_person_id = person_id
23: AND EFFECTIVE_END_DATE >= ALL(SELECT EFFECTIVE_END_DATE
24: FROM PER_ALL_PEOPLE_F
25: WHERE PERSON_ID=x_person_id);
26:
27: return(x_person_name);
28: