DBA Data[Home] [Help]

APPS.PER_TMPROFILE_PKG dependencies on PER_ALL_PEOPLE_F

Line 205: from per_all_people_f papf,

201: ,p_effective_date IN DATE ) RETURN VARCHAR2 IS
202:
203: cursor c_person_type is
204: select ppt.SYSTEM_PERSON_TYPE person_type
205: from per_all_people_f papf,
206: per_person_types ppt
207: where papf.person_id = p_person_id
208: and sysdate between papf.EFFECTIVE_START_DATE and papf.EFFECTIVE_END_DATE
209: and papf.PERSON_TYPE_ID = ppt.PERSON_TYPE_ID