DBA Data[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 1190: from per_person_type_usages_f ptuf, per_person_types ppt

1186: -- PTU : Following Code has been added
1187: --
1188: begin
1189: select ptuf.person_type_id into l_person_type_id1
1190: from per_person_type_usages_f ptuf, per_person_types ppt
1191: where ptuf.person_id = p_person_id
1192: and l_hire_date between ptuf.effective_start_date and ptuf.effective_end_date
1193: and ppt.person_type_id = ptuf.person_type_id
1194: and ppt.system_person_type = 'EMP';