20:
21: End formAdHocRoleName;
22:
23: Function getPersonInfo
24: (p_person_id in per_all_people_f.person_id%type)
25: Return user_info is
26:
27: cursor c_person_info(p_person_id in per_all_people_f.person_id%type) is
28: select p1.last_name,
23: Function getPersonInfo
24: (p_person_id in per_all_people_f.person_id%type)
25: Return user_info is
26:
27: cursor c_person_info(p_person_id in per_all_people_f.person_id%type) is
28: select p1.last_name,
29: p1.full_name
30: from per_all_people_f p1
31: where p1.person_id = p_person_id
26:
27: cursor c_person_info(p_person_id in per_all_people_f.person_id%type) is
28: select p1.last_name,
29: p1.full_name
30: from per_all_people_f p1
31: where p1.person_id = p_person_id
32: and p1.effective_end_date =
33: (select max(p2.effective_end_date)
34: from per_all_people_f p2
30: from per_all_people_f p1
31: where p1.person_id = p_person_id
32: and p1.effective_end_date =
33: (select max(p2.effective_end_date)
34: from per_all_people_f p2
35: where p2.person_id = p1.person_id);
36:
37: l_user_info user_info;
38: