DBA Data[Home] [Help]

APPS.PER_TMPROFILE_PKG dependencies on PER_PERSON_TYPES

Line 206: per_person_types ppt

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
210: and papf.BUSINESS_GROUP_ID = ppt.BUSINESS_GROUP_ID;