APPS.BEN_QUA_LER dependencies on PER_ALL_PEOPLE_F

Line 117: from per_all_people_f

113: -- bug 2850744
114: -- get the effective start date of the person record.
115: cursor get_person_date(p_person_id in number) is
116: select effective_start_date
117: from per_all_people_f
118: where person_id = p_person_id
119: and business_group_id = p_new.business_group_id
120: and sysdate between effective_start_date
121: and effective_end_date;

Line 130: from per_all_people_f per

126: where pea.attendance_id = cv_attendance_id;
127: --
128: cursor c_from_party(cv_party_id number) is
129: select person_id
130: from per_all_people_f per
131: where per.party_id = cv_party_id ;
132: --
133: l_changed BOOLEAN;
134: l_effective_end_date DATE := to_date('31/12/4712','DD/MM/YYYY');