APPS.PQH_FR_WF_NTF dependencies on PER_ALL_PEOPLE_F

Line 5: l_person_name per_all_people_f.full_name%TYPE;

1: PACKAGE BODY PQH_FR_WF_NTF as
2: /* $Header: pqfrpswf.pkb 115.6 2004/04/28 02:39:16 svorugan noship $ */
3: g_package varchar2(60) := 'PQH_FR_WF_NTF' ;
4: function get_person_name(p_person_id in varchar2) return varchar2 is
5: l_person_name per_all_people_f.full_name%TYPE;
6: cursor csr_person_name IS
7: SELECT full_name
8: FROM per_all_people_f
9: WHERE person_id = p_person_id

Line 8: FROM per_all_people_f

4: function get_person_name(p_person_id in varchar2) return varchar2 is
5: l_person_name per_all_people_f.full_name%TYPE;
6: cursor csr_person_name IS
7: SELECT full_name
8: FROM per_all_people_f
9: WHERE person_id = p_person_id
10: ORDER BY effective_start_date DESC;
11: begin
12:

Line 100: l_person_name per_all_people_f.full_name%TYPE;

96: l_itemkey number;
97: l_itemtype varchar2(60) := 'PQHGEN';
98: l_process_name varchar2(60) := 'PQHFRNTF';
99: l_message_name varchar2(100);
100: l_person_name per_all_people_f.full_name%TYPE;
101: l_url Varchar2(2000);
102: l_user_role Varchar2(200);
103: Begin
104: hr_utility.set_location(l_proc || ' Entering',10);