DBA Data[Home] [Help]

APPS.OTA_GENERAL dependencies on PER_PERSON_TYPES

Line 169: per_person_types ppt

165: Cursor c_current_employee is
166: select 'X'
167: from per_all_people_f ppf,
168: per_person_type_usages_f ptu,
169: per_person_types ppt
170: where p_date between ptu.effective_start_date and ptu.effective_end_date
171: and p_date between ppf.effective_start_date and ppf.effective_end_date
172: and ptu.person_id = ppf.person_id
173: and ppt.system_person_type in ('EMP','CWK','APL') -- Added 'APL' for 3885568