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 2147: l_table_name(i) := 'PER_ALL_PEOPLE_F';

2143: l_table_name(i) := 'PAY_ELEMENT_ENTRIES_F';
2144: i := i + 1;
2145: l_table_name(i) := 'PAY_ELEMENT_ENTRY_VALUES_F';
2146: i := i + 1;
2147: l_table_name(i) := 'PER_ALL_PEOPLE_F';
2148: i := i + 1;
2149: l_table_name(i) := 'PER_ABSENCE_ATTENDANCES';
2150: i := i + 1;
2151: l_table_name(i) := 'PER_PERIODS_OF_SERVICE';

Line 2724: FROM per_all_people_f per, per_periods_of_service pps

2720: -- Cursor to get latest start date
2721: CURSOR csr_get_latest_date
2722: IS
2723: SELECT DECODE(per.current_employee_flag, 'Y', pps.date_start, NULL)
2724: FROM per_all_people_f per, per_periods_of_service pps
2725: WHERE per.person_id = p_person_id
2726: AND pps.person_id = p_person_id
2727: AND p_effective_date BETWEEN per.effective_start_date
2728: AND NVL(