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

Line 131: FROM OTA_CERT_ENROLLMENTS oce

127: AND qualification_type = 1 -- 1 is certification
128: AND FROM_DATE <= l_eff_date
129: AND nvl(TO_DATE, sysdate) >= l_eff_date
130: AND qualification_id NOT IN (SELECT certification_id
131: FROM OTA_CERT_ENROLLMENTS oce
132: WHERE oce.certification_status_code ='CERTIFIED'
133: AND oce.completion_date <= SYSDATE
134: AND oce.business_group_id = l_business_group_id
135: AND oce.person_id = l_employ_id );

Line 251: FROM OTA_CERT_ENROLLMENTS oce

247: AND qualification_type = 1 -- 1 is certification
248: AND FROM_DATE <= v_date
249: AND nvl(TO_DATE,sysdate) >= v_date
250: AND qualification_id NOT IN (SELECT certification_id
251: FROM OTA_CERT_ENROLLMENTS oce
252: WHERE oce.certification_status_code ='CERTIFIED'
253: AND oce.completion_date <= SYSDATE
254: AND oce.business_group_id = l_business_group_id
255: AND oce.person_id = l_employ_id )