DBA Data[Home] [Help]

APPS.POS_GET dependencies on PER_PEOPLE_F

Line 23: FROM PER_PEOPLE_F

19: INTO x_person_name
20: FROM PER_ALL_PEOPLE_F
21: WHERE x_person_id = person_id
22: AND EFFECTIVE_END_DATE >= ALL(SELECT EFFECTIVE_END_DATE
23: FROM PER_PEOPLE_F
24: WHERE PERSON_ID=x_person_id);
25:
26: return(x_person_name);
27: