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.

[Home] [Help]

APPS.GMO_OPER_CERT_PUB dependencies on OTA_CERT_ENROLLMENTS

Line 134: FROM OTA_CERT_ENROLLMENTS oce

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

Line 254: FROM OTA_CERT_ENROLLMENTS oce

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