APPS.HXC_APPROVAL_HELPER dependencies on PER_ALL_PEOPLE_F

Line 24: (p_person_id in per_all_people_f.person_id%type)

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,

Line 27: cursor c_person_info(p_person_id in per_all_people_f.person_id%type) is

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

Line 30: from per_all_people_f p1

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

Line 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: