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 105: FROM per_all_people_f per,per_all_assignments_f paa

101: AND language = 'US';
102:
103: CURSOR c_get_person_age IS
104: SELECT to_char(per.date_of_birth,'RRRR')
105: FROM per_all_people_f per,per_all_assignments_f paa
106: WHERE per.person_id = paa.person_id
107: AND p_date_earned between paa.effective_start_date and paa.effective_end_date
108: AND p_date_earned between per.effective_start_date and per.effective_end_date
109: AND paa.assignment_id = p_assignment_id;

Line 5487: FROM per_all_people_f per

5483: -- Cursor to get the date of birth
5484: --
5485: CURSOR get_dob IS
5486: SELECT TRUNC(date_of_birth)
5487: FROM per_all_people_f per
5488: ,per_all_assignments_f paf
5489: WHERE per.person_id = paf.person_id
5490: AND paf.assignment_id = p_assignment_id
5491: AND p_date_earned BETWEEN per.effective_start_date AND per.effective_end_date