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_REVTERMINATION_SS dependencies on PER_ALL_PEOPLE_F

Line 18: PER_ALL_PEOPLE_F ppf

14: cursor csr_person_type(l_person_id Number) is
15: select pps.SYSTEM_PERSON_TYPE
16: FROM
17: PER_PERSON_TYPES pps,
18: PER_ALL_PEOPLE_F ppf
19: where ppf.person_id = l_person_id
20: AND ppf.person_type_id = pps.person_type_id
21: AND ppf.effective_start_date = (select max(effective_start_date) from PER_ALL_PEOPLE_F papf1 where papf1.person_id = ppf.person_id);
22:

Line 21: AND ppf.effective_start_date = (select max(effective_start_date) from PER_ALL_PEOPLE_F papf1 where papf1.person_id = ppf.person_id);

17: PER_PERSON_TYPES pps,
18: PER_ALL_PEOPLE_F ppf
19: where ppf.person_id = l_person_id
20: AND ppf.person_type_id = pps.person_type_id
21: AND ppf.effective_start_date = (select max(effective_start_date) from PER_ALL_PEOPLE_F papf1 where papf1.person_id = ppf.person_id);
22:
23: cursor csr_get_person_type(l_person_type_id Number) is
24: select pps.SYSTEM_PERSON_TYPE
25: from PER_PERSON_TYPES pps

Line 1366: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;

1362:
1363: -- For SAVE_FOR_LATER
1364:
1365:
1366: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
1367: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;
1368: lv_person_id per_periods_of_placement.person_id%TYPE;
1369: lv_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
1370: lv_clear_details varchar2(10) default 'Y';

Line 1367: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;

1363: -- For SAVE_FOR_LATER
1364:
1365:
1366: lv_rehire_recommendation per_all_people_f.rehire_recommendation%TYPE;
1367: lv_rehire_reason per_all_people_f.rehire_reason%TYPE;
1368: lv_person_id per_periods_of_placement.person_id%TYPE;
1369: lv_actual_termination_date per_periods_of_placement.actual_termination_date%TYPE;
1370: lv_clear_details varchar2(10) default 'Y';
1371: l_person_type varchar2(25);

Line 1467: lv_person_id per_all_people_f.person_id%type;

1463:
1464: is
1465: -- local variables
1466: c_proc constant varchar2(30) := 'checkPersonType';
1467: lv_person_id per_all_people_f.person_id%type;
1468: l_person_type VARCHAR2(100) default 'EX_EMP';
1469:
1470: begin
1471: g_debug := hr_utility.debug_enabled;