APPS.HR_GENERAL_UTILITIES dependencies on PER_ALL_PEOPLE_F

Line 85: l_all_person_rec per_all_people_f%ROWTYPE;

81: IS
82: l_person_rec per_people_f%ROWTYPE;
83: l_proc VARCHAR2 (72);
84:
85: l_all_person_rec per_all_people_f%ROWTYPE;
86: --
87: CURSOR csr_people_rec (p_person_id per_people_f.person_id%TYPE)
88: IS
89: SELECT *

Line 90: FROM per_all_people_f -- Fix 2082000

86: --
87: CURSOR csr_people_rec (p_person_id per_people_f.person_id%TYPE)
88: IS
89: SELECT *
90: FROM per_all_people_f -- Fix 2082000
91: WHERE person_id = p_person_id
92: AND trunc(p_effective_date)
93: BETWEEN trunc(effective_start_date) AND trunc(effective_end_date);
94: BEGIN

Line 288: ( p_person_id IN per_all_people_f.person_id%TYPE

284: -- ----------------------------------------------------------------------------
285: -- |--< Get_Person_Details >---------------------------------------------------|
286: -- ----------------------------------------------------------------------------
287: FUNCTION Get_Person_Details
288: ( p_person_id IN per_all_people_f.person_id%TYPE
289: , p_effective_date IN DATE DEFAULT SYSDATE
290: )
291: RETURN g_person_details_rec_type
292: IS

Line 296: CURSOR csr_people_rec (p_person_id per_all_people_f.person_id%TYPE)

292: IS
293: l_person_rec g_person_details_rec_type;
294: l_proc VARCHAR2 (72);
295: --
296: CURSOR csr_people_rec (p_person_id per_all_people_f.person_id%TYPE)
297: IS
298: -- fix 2209594
299: SELECT last_name
300: ,first_name

Line 307: FROM per_all_people_f

303: ,previous_last_name
304: ,suffix
305: ,title
306: ,business_group_id
307: FROM per_all_people_f
308: WHERE person_id = p_person_id
309: AND trunc(p_effective_date)
310: BETWEEN trunc(effective_start_date) AND trunc(effective_end_date);
311: BEGIN