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.PER_ZA_WSP_ARCHIVE_PKG dependencies on OTA_CERTIFICATIONS_TL

Line 2971: ,ota_certifications_tl oc_tl

2967: -- Certifications
2968: cursor csr_wsp_cert(p_person_id number) is
2969: select oc.certification_id, oc_tl.name
2970: from ota_certifications_b oc
2971: ,ota_certifications_tl oc_tl
2972: ,ota_cert_enrollments oce
2973: where oce.person_id = p_person_id
2974: and oce.certification_id = oc.certification_id
2975: and oc.certification_id = oc_tl.certification_id

Line 3609: ,ota_certifications_tl oc_tl

3605: -- Certifications
3606: cursor csr_atr_cert(p_person_id number) is
3607: select oc.certification_id, oc_tl.name,oce.completion_date, oce.certification_status_code
3608: from ota_certifications_b oc
3609: ,ota_certifications_tl oc_tl
3610: ,ota_cert_enrollments oce
3611: where oce.person_id = p_person_id
3612: and oce.certification_id = oc.certification_id
3613: and oc.certification_id = oc_tl.certification_id