APPS.HXC_HXCMISTC_XMLP_PKG dependencies on PER_PEOPLE_F

Line 38: from per_people_f ppf

34:
35: cursor c_per_dtl (cp_person_id in number,
36: cp_effective_date in date) is
37: select ppf.full_name, nvl(ppf.employee_number, ppf.npw_number)
38: from per_people_f ppf
39: where ppf.person_id = cp_person_id
40: and cp_effective_date between ppf.effective_start_date
41: and ppf.effective_end_date;
42:

Line 251: from per_people_f

247: end if;
248:
249: person_type1 := 'and ppf.effective_start_date = (select max(effective_start_date)
250:
251: from per_people_f
252: where person_id = ppf.person_id
253: and effective_start_date <= :p_date_to
254: and effective_end_date >= :p_date_from
255: and ptu.person_id = person_id