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_EX_EMPLOYEE_API dependencies on PER_PERSON_TYPE_USAGES_F

Line 651: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;

647: l_actual_termination_date date;
648: l_status varchar2(11);
649: l_current_dod date;
650: l_date_of_death date;
651: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;
652: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
653: l_action_chk VARCHAR2(1) := 'N';
654:
655: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;

Line 652: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;

648: l_status varchar2(11);
649: l_current_dod date;
650: l_date_of_death date;
651: l_ptu_object_version_number per_person_type_usages_f.object_version_number%TYPE;
652: l_person_type_usage_id per_person_type_usages_f.person_type_usage_id%TYPE;
653: l_action_chk VARCHAR2(1) := 'N';
654:
655: l_saved_atd per_periods_of_service.actual_termination_date%TYPE;
656: l_saved_lspd per_periods_of_service.last_standard_process_date%TYPE;

Line 1924: , per_person_type_usages_f ptu

1920: --
1921: cursor csr_valid_ex_emp is
1922: select null
1923: from per_all_people_f per
1924: , per_person_type_usages_f ptu
1925: , per_person_types pet
1926: where per.person_id = l_person_id
1927: and l_exemppet_eff_date between per.effective_start_date
1928: and per.effective_end_date