DBA Data[Home] [Help]

APPS.HR_ASSIGNMENT_API dependencies on PER_PERSON_TYPES

Line 253: ,per_person_types ppt

249:
250: cursor csr_ptu_row (p_date_received in date ) is
251: select ptu.effective_start_date
252: from per_person_type_usages_f ptu
253: ,per_person_types ppt
254: where ptu.person_id = p_person_id
255: and ptu.effective_start_date > p_date_received
256: and ptu.person_type_id = ppt.person_type_id
257: and ppt.system_person_type = 'EX_APL'