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_CERTIFICATION_MEMBERS

Line 890: from OTA_CERTIFICATION_MEMBERS ocm

886:
887: -- Get the Courses Linked to a Certification
888: cursor csr_get_cert_courses(p_cert_id number) is
889: select ocm.object_id
890: from OTA_CERTIFICATION_MEMBERS ocm
891: , OTA_CERTIFICATIONS_B oc
892: where oc.certification_id = p_cert_id
893: and ocm.certification_id = oc.certification_id
894: and ocm.object_type = 'H';

Line 3040: from OTA_CERTIFICATION_MEMBERS ocm

3036: --
3037: -- Get the Courses Linked to a Certification
3038: cursor csr_get_cert_courses(p_cert_id number) is
3039: select ocm.object_id
3040: from OTA_CERTIFICATION_MEMBERS ocm
3041: , OTA_CERTIFICATIONS_B oc
3042: where oc.certification_id = p_cert_id
3043: and ocm.certification_id = oc.certification_id
3044: and ocm.object_type = 'H';

Line 3080: from OTA_CERTIFICATION_MEMBERS ocm

3076: and pce.business_group_id = g_bg_id;
3077: --
3078: cursor csr_exists_cert_courses(p_cert_id number) is
3079: select count(ocm.object_id)
3080: from OTA_CERTIFICATION_MEMBERS ocm
3081: , OTA_CERTIFICATIONS_B oc
3082: where oc.certification_id = p_cert_id
3083: and ocm.certification_id = oc.certification_id
3084: and ocm.object_type = 'H';