APPS.HR_GENERAL_UTILITIES dependencies on PER_PEOPLE_F

Line 13: l_val_person_id per_people_f.person_id%TYPE;

9: l_ret boolean := FND_INSTALLATION.GET_APP_INFO ('PER', l_status,
10: l_industry, l_per_owner);
11: g_fatal_error EXCEPTION;
12: PRAGMA EXCEPTION_INIT(g_fatal_error, -20001);
13: l_val_person_id per_people_f.person_id%TYPE;
14: g_replace_string VARCHAR2 (2) := '!#';
15: g_space varchar2(1) := ' ';
16: g_src_attribute VARCHAR2 (200) := ' SRC="'
17: || g_replace_string || '"';

Line 77: ( p_person_id IN per_people_f.person_id%TYPE

73: -- ----------------------------------------------------------------------------
74: -- |--< Get_Person_Record >---------------------------------------------------|
75: -- ----------------------------------------------------------------------------
76: FUNCTION Get_Person_Record
77: ( p_person_id IN per_people_f.person_id%TYPE
78: , p_effective_date IN DATE DEFAULT SYSDATE
79: )
80: RETURN per_people_f%ROWTYPE
81: IS

Line 80: RETURN per_people_f%ROWTYPE

76: FUNCTION Get_Person_Record
77: ( p_person_id IN per_people_f.person_id%TYPE
78: , p_effective_date IN DATE DEFAULT SYSDATE
79: )
80: RETURN per_people_f%ROWTYPE
81: IS
82: l_person_rec per_people_f%ROWTYPE;
83: l_proc VARCHAR2 (72);
84:

Line 82: l_person_rec per_people_f%ROWTYPE;

78: , p_effective_date IN DATE DEFAULT SYSDATE
79: )
80: RETURN per_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: --

Line 87: CURSOR csr_people_rec (p_person_id per_people_f.person_id%TYPE)

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 *
90: FROM per_all_people_f -- Fix 2082000
91: WHERE person_id = p_person_id

Line 346: RETURN per_people_f.business_group_id%TYPE

342: -- ----------------------------------------------------------------------------
343: -- |--< Get_Business_Group >--------------------------------------------------|
344: -- ----------------------------------------------------------------------------
345: FUNCTION Get_Business_Group
346: RETURN per_people_f.business_group_id%TYPE
347: IS
348: BEGIN
349: RETURN hr_util_misc_web.get_business_group_id;
350: END Get_Business_Group;