DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 1332: from per_person_type_usages_f ptuf, per_person_types ppt

1328: -- PTU : Following Code has been added
1329: --
1330: begin
1331: select ptuf.person_type_id into l_person_type_id1
1332: from per_person_type_usages_f ptuf, per_person_types ppt
1333: where ptuf.person_id = p_person_id
1334: and l_hire_date between ptuf.effective_start_date and ptuf.effective_end_date
1335: and ppt.person_type_id = ptuf.person_type_id
1336: and ppt.system_person_type = 'EMP';