APPS.PO_INQ_SV dependencies on PER_ALL_PEOPLE_F

Line 417: Any time we will have one record in the per_all_people_f which

413:
414: /* Bug 3223368. Replaced the old statement which was there in the cursor with
415: the below statement to improve performance.
416:
417: Any time we will have one record in the per_all_people_f which
418: will be valid in the sysdate and this will be the record with
419: the maximum effective_start_date.
420:
421: Now with this fix, we will avoid the sort which was most expensive.

Line 426: FROM per_all_people_f prf

422: */
423:
424: SELECT prf.full_name
425: INTO x_person_name
426: FROM per_all_people_f prf
427: WHERE prf.person_id = x_person_id
428: AND trunc(sysdate) between prf.effective_start_date and prf.effective_end_date;
429:
430: return(x_person_name);