APPS.PER_PEOPLE_V15_PKG dependencies on PER_ALL_PEOPLE_F

Line 83: from per_all_people_f

79: -- are needed when calling the derive person names function
80: --
81: cursor csr_get_person_details is
82: select *
83: from per_all_people_f
84: where rowid = X_rowid;
85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;

Line 87: l_full_name per_all_people_f.full_name%type;

83: from per_all_people_f
84: where rowid = X_rowid;
85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);

Line 88: l_order_name per_all_people_f.order_name%type;

84: where rowid = X_rowid;
85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);
92: --

Line 89: l_global_name per_all_people_f.global_name%type;

85: --
86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);
92: --
93: BEGIN

Line 90: l_local_name per_all_people_f.local_name%type;

86: l_person_rec csr_get_person_details%rowtype;
87: l_full_name per_all_people_f.full_name%type;
88: l_order_name per_all_people_f.order_name%type;
89: l_global_name per_all_people_f.global_name%type;
90: l_local_name per_all_people_f.local_name%type;
91: l_dup_name varchar(10);
92: --
93: BEGIN
94: l_dup_name := 'N';