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.OTA_AME_ATTRIBUTES dependencies on OTA_CERT_ENROLLMENTS

Line 796: from ota_cert_prd_enrollments cpe , ota_cert_enrollments ce

792:
793: cursor get_cert_period_date
794: is
795: select cpe.cert_period_start_date
796: from ota_cert_prd_enrollments cpe , ota_cert_enrollments ce
797: where
798: ce.cert_enrollment_id = cpe.cert_enrollment_id
799: and ce.certification_id = c_certification_id
800: and ce.person_id = c_person_id

Line 861: from ota_cert_prd_enrollments cpe , ota_cert_enrollments ce

857:
858: cursor get_cert_period_date
859: is
860: select cpe.cert_period_end_date
861: from ota_cert_prd_enrollments cpe , ota_cert_enrollments ce
862: where
863: ce.cert_enrollment_id = cpe.cert_enrollment_id
864: and ce.certification_id = c_certification_id
865: and ce.person_id = c_person_id