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.

[Home] [Help]

APPS.HR_EMPLOYEE_APPLICANT_API dependencies on PER_PERSON_TYPE_USAGES

Line 873: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;

869: l_no_managers_warning BOOLEAN;
870: l_org_now_no_manager_warning BOOLEAN;
871: l_hourly_salaried_warning BOOLEAN;
872: l_oversubscribed_vacancy_id number;
873: l_person_type_usage_id per_person_type_usages.person_type_usage_id%TYPE;
874: l_object_version_number NUMBER := p_per_object_version_number; -- 3684087
875: --
876: l_per_details_rec csr_per_details%ROWTYPE;
877: l_pds_details_rec csr_pds_details%ROWTYPE;

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