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 2851: p_certification_id ota_certifications_b.certification_id%TYPE)

2847: END IF;
2848: END is_lp_enrollable;
2849:
2850: FUNCTION is_cert_enrollable(
2851: p_certification_id ota_certifications_b.certification_id%TYPE)
2852: RETURN VARCHAR2
2853: IS
2854: CURSOR csr_get_cert_details IS
2855: SELECT null

Line 2856: FROM ota_certifications_b crb

2852: RETURN VARCHAR2
2853: IS
2854: CURSOR csr_get_cert_details IS
2855: SELECT null
2856: FROM ota_certifications_b crb
2857: , ota_certification_members crm
2858: WHERE crb.certification_id = crm.certification_id
2859: AND crb.certification_id = p_certification_id
2860: AND trunc(sysdate) between crb.start_date_active and nvl(crb.end_date_active, trunc(sysdate))