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

Line 63: FROM per_all_people_f per,per_all_assignments_f paa

59: AND language = 'US';
60:
61: CURSOR c_get_person_age IS
62: SELECT to_char(per.date_of_birth,'RRRR')
63: FROM per_all_people_f per,per_all_assignments_f paa
64: WHERE per.person_id = paa.person_id
65: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
66: AND p_date_earned between per.effective_start_date and per.effective_end_date
67: AND paa.assignment_id = p_assignment_id;

Line 5390: FROM per_all_people_f per

5386: -- Cursor to get the date of birth
5387: --
5388: CURSOR get_dob IS
5389: SELECT TRUNC(date_of_birth)
5390: FROM per_all_people_f per
5391: ,per_all_assignments_f paf
5392: WHERE per.person_id = paf.person_id
5393: AND paf.assignment_id = p_assignment_id
5394: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date