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.PQP_GB_PSI_SERVICE_HISTORY dependencies on PER_ALL_PEOPLE_F

Line 2129: l_table_name(i) := 'PER_ALL_PEOPLE_F';

2125: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2126: i := i + 1;
2127: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2128: i := i + 1;
2129: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2130: i := i + 1;
2131: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2132: i := i + 1;
2133: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';

Line 2706: FROM per_all_people_f per, per_periods_of_service pps

2702: -- Cursor to get latest start date
2703: CURSOR csr_get_latest_date
2704: IS
2705: SELECT DECODE(per.current_employee_flag, 'Y', pps.date_start, NULL)
2706: FROM per_all_people_f per, per_periods_of_service pps
2707: WHERE per.person_id = p_person_id
2708: AND pps.person_id = p_person_id
2709: AND p_effective_date BETWEEN per.effective_start_date
2710: AND NVL(