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_UTILITY dependencies on OTA_CERTIFICATIONS_B

Line 2787: p_certification_id ota_certifications_b.certification_id%TYPE)

2783: END IF;
2784: END is_lp_enrollable;
2785:
2786: FUNCTION is_cert_enrollable(
2787: p_certification_id ota_certifications_b.certification_id%TYPE)
2788: RETURN VARCHAR2
2789: IS
2790: CURSOR csr_get_cert_details IS
2791: SELECT null

Line 2792: FROM ota_certifications_b crb

2788: RETURN VARCHAR2
2789: IS
2790: CURSOR csr_get_cert_details IS
2791: SELECT null
2792: FROM ota_certifications_b crb
2793: , ota_certification_members crm
2794: WHERE crb.certification_id = crm.certification_id
2795: AND crb.certification_id = p_certification_id
2796: AND trunc(sysdate) between crb.start_date_active and nvl(crb.end_date_active, trunc(sysdate))