APPS.PO_EMPLOYEES_SV dependencies on PER_ALL_PEOPLE_F

Line 755: from per_all_people_f prf

751: x_date date;
752:
753: cursor c1 is
754: select distinct prf.full_name,prf.effective_start_date
755: from per_all_people_f prf
756: where prf.person_id = x_person_id
757: order by prf.effective_start_date desc;
758:
759: begin

Line 765: * multiple records for the person in per_all_people_f table.

761: /*
762: * (1) Even the approver is no longer with the org, still need to retieve his/her
763: * Full Name.
764: * (2) Suppose a person has multiple employing history with the org, there're
765: * multiple records for the person in per_all_people_f table.
766: */
767:
768: open c1;
769: fetch c1 into x_value,x_date;