eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_PERSON_TYPE_USAGES

Line 822: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

818: l_no_managers_warning BOOLEAN;
819: l_org_now_no_manager_warning BOOLEAN;
820: l_hourly_salaried_warning BOOLEAN;
821: l_oversubscribed_vacancy_id number;
822: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
823: l_object_version_number NUMBER := p_per_object_version_number; -- 3684087
824: --
825: l_per_details_rec csr_per_details%ROWTYPE;
826: l_pds_details_rec csr_pds_details%ROWTYPE;

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';