DBA Data[Home] [Help]

APPS.HR_GENERAL_UTILITIES dependencies on PER_PEOPLE_F

Line 101: -- per_people_f which requires us to do an insert and delete of sessionId in

97: -- {Start Of Comments}
98: --
99: -- Description:
100: -- get the person record at the given date. This method uses the secured view
101: -- per_people_f which requires us to do an insert and delete of sessionId in
102: -- FND_SESSIONS
103: --
104: -- Prerequisites:
105: -- person must exist

Line 119: ( p_person_id IN per_people_f.person_id%TYPE

115: --
116: -- {End Of Comments}
117: -- ----------------------------------------------------------------------------
118: FUNCTION Get_Person_Record
119: ( p_person_id IN per_people_f.person_id%TYPE
120: , p_effective_date IN DATE DEFAULT SYSDATE
121: )
122: RETURN per_people_f%ROWTYPE;
123: -- ----------------------------------------------------------------------------

Line 122: RETURN per_people_f%ROWTYPE;

118: FUNCTION Get_Person_Record
119: ( p_person_id IN per_people_f.person_id%TYPE
120: , p_effective_date IN DATE DEFAULT SYSDATE
121: )
122: RETURN per_people_f%ROWTYPE;
123: -- ----------------------------------------------------------------------------
124: -- |--< Get_Person_Details >---------------------------------------------------|
125: -- ----------------------------------------------------------------------------
126: -- {Start Of Comments}

Line 131: -- Get_person_record which uses the secured view per_people_f which also has

127: --
128: -- Description:
129: -- get the person details record at the given date. we go to the base table
130: -- per_all_people_f to get the information. This method is faster than using
131: -- Get_person_record which uses the secured view per_people_f which also has
132: -- an overhead of inserting and deleting row from FND_SESSIONS
133: --
134: -- Prerequisites:
135: -- person must exist

Line 178: RETURN per_people_f.business_group_id%TYPE;

174: --
175: -- {End Of Comments}
176: -- ----------------------------------------------------------------------------
177: FUNCTION Get_Business_Group
178: RETURN per_people_f.business_group_id%TYPE;
179: -- ----------------------------------------------------------------------------
180: -- |--< Use_Message >---------------------------------------------------------|
181: -- ----------------------------------------------------------------------------
182: -- {Start Of Comments}