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_TERMINATION_SS dependencies on PER_PERSON_TYPES

Line 98: , per_person_types pet

94: , per.object_version_number
95: from per_all_people_f per
96: , per_business_groups bus
97: , per_periods_of_service pds
98: , per_person_types pet
99: where pds.period_of_service_id = p_period_of_service_id
100: and bus.business_group_id = pds.business_group_id
101: and per.person_id = pds.person_id
102: and p_actual_termination_date + 1 between per.effective_start_date

Line 1752: lv_person_type_id per_person_types.person_type_id%TYPE;

1748:
1749: -- For SAVE_FOR_LATER
1750: ld_effective_date date default null;
1751:
1752: lv_person_type_id per_person_types.person_type_id%TYPE;
1753: lv_assignment_status_type_id
1754: per_assignment_status_types.assignment_status_type_id%TYPE;
1755: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
1756: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;