APPS.PO_EMPLOYEES_SV dependencies on PER_ALL_PEOPLE_F

Line 644: from per_all_people_f prf

640: x_date date;
641:
642: cursor c1 is
643: select distinct prf.full_name,prf.effective_start_date
644: from per_all_people_f prf
645: where prf.person_id = x_person_id
646: order by prf.effective_start_date desc;
647:
648: begin

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

650: /*
651: * (1) Even the approver is no longer with the org, still need to retieve his/her
652: * Full Name.
653: * (2) Suppose a person has multiple employing history with the org, there're
654: * multiple records for the person in per_all_people_f table.
655: */
656:
657: open c1;
658: fetch c1 into x_value,x_date;