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.PAY_AE_SI_REPORTS dependencies on PER_QUALIFICATIONS

Line 208: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl

204:
205: /* Cursor for fetching the person's qualification data */
206: CURSOR csr_p_qual_data (l_person_id number,l_qual_id number) IS
207: SELECT pq.title , pq.attendance_id , hl.meaning
208: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl
209: WHERE pq.person_id = l_person_id
210: AND pq.qualification_id = l_qual_id
211: AND pst.qualification_id = pq.qualification_id
212: AND pst.major = 'Y'

Line 220: from per_establishments est, per_establishment_attendances pea, per_qualifications pq

216:
217: /* Cursor to fetch establishment name */
218: CURSOR get_est_name (l_attendance_id number) IS
219: select est.name
220: from per_establishments est, per_establishment_attendances pea, per_qualifications pq
221: where pq.attendance_id = l_attendance_id
222: and pq.attendance_id = pea.attendance_id
223: and est.establishment_id = pea.establishment_id;
224:

Line 288: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl

284:
285: /* Cursor for fetching person's spouse's qualification details */
286: CURSOR csr_get_spouse_details (l_spouse_person_id number) IS
287: SELECT pq.title , hl.meaning
288: FROM per_qualifications_v pq , per_subjects_taken pst ,hr_lookups hl
289: WHERE pq.person_id = l_spouse_person_id
290: AND pst.qualification_id = pq.qualification_id
291: AND pst.major = 'Y'
292: AND hl.lookup_type = 'PER_SUBJECTS'