APPS.HR_GENERAL_UTILITIES dependencies on PER_ALL_PEOPLE_F

Line 48: ( last_name per_all_people_f.last_name%TYPE

44: );
45: --
46: TYPE g_person_details_rec_type
47: IS RECORD
48: ( last_name per_all_people_f.last_name%TYPE
49: , first_name per_all_people_f.first_name%TYPE
50: , full_name per_all_people_f.full_name%TYPE
51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE

Line 49: , first_name per_all_people_f.first_name%TYPE

45: --
46: TYPE g_person_details_rec_type
47: IS RECORD
48: ( last_name per_all_people_f.last_name%TYPE
49: , first_name per_all_people_f.first_name%TYPE
50: , full_name per_all_people_f.full_name%TYPE
51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE
53: , suffix per_all_people_f.suffix%TYPE

Line 50: , full_name per_all_people_f.full_name%TYPE

46: TYPE g_person_details_rec_type
47: IS RECORD
48: ( last_name per_all_people_f.last_name%TYPE
49: , first_name per_all_people_f.first_name%TYPE
50: , full_name per_all_people_f.full_name%TYPE
51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE
53: , suffix per_all_people_f.suffix%TYPE
54: , title per_all_people_f.title%TYPE

Line 51: , middle_names per_all_people_f.middle_names%TYPE

47: IS RECORD
48: ( last_name per_all_people_f.last_name%TYPE
49: , first_name per_all_people_f.first_name%TYPE
50: , full_name per_all_people_f.full_name%TYPE
51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE
53: , suffix per_all_people_f.suffix%TYPE
54: , title per_all_people_f.title%TYPE
55: , business_group_id per_all_people_f.business_group_id%TYPE

Line 52: , previous_last_name per_all_people_f.previous_last_name%TYPE

48: ( last_name per_all_people_f.last_name%TYPE
49: , first_name per_all_people_f.first_name%TYPE
50: , full_name per_all_people_f.full_name%TYPE
51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE
53: , suffix per_all_people_f.suffix%TYPE
54: , title per_all_people_f.title%TYPE
55: , business_group_id per_all_people_f.business_group_id%TYPE
56: );

Line 53: , suffix per_all_people_f.suffix%TYPE

49: , first_name per_all_people_f.first_name%TYPE
50: , full_name per_all_people_f.full_name%TYPE
51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE
53: , suffix per_all_people_f.suffix%TYPE
54: , title per_all_people_f.title%TYPE
55: , business_group_id per_all_people_f.business_group_id%TYPE
56: );
57: --

Line 54: , title per_all_people_f.title%TYPE

50: , full_name per_all_people_f.full_name%TYPE
51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE
53: , suffix per_all_people_f.suffix%TYPE
54: , title per_all_people_f.title%TYPE
55: , business_group_id per_all_people_f.business_group_id%TYPE
56: );
57: --
58: TYPE g_lookup_values_tab_type

Line 55: , business_group_id per_all_people_f.business_group_id%TYPE

51: , middle_names per_all_people_f.middle_names%TYPE
52: , previous_last_name per_all_people_f.previous_last_name%TYPE
53: , suffix per_all_people_f.suffix%TYPE
54: , title per_all_people_f.title%TYPE
55: , business_group_id per_all_people_f.business_group_id%TYPE
56: );
57: --
58: TYPE g_lookup_values_tab_type
59: IS TABLE OF

Line 130: -- per_all_people_f to get the information. This method is faster than using

126: -- {Start Of Comments}
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:

Line 149: ( p_person_id IN per_all_people_f.person_id%TYPE

145: --
146: -- {End Of Comments}
147: -- ----------------------------------------------------------------------------
148: FUNCTION Get_Person_Details
149: ( p_person_id IN per_all_people_f.person_id%TYPE
150: , p_effective_date IN DATE DEFAULT SYSDATE
151: )
152: RETURN g_person_details_rec_type;
153: