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 PER_COMPETENCE_ELEMENTS

Line 151: FROM per_competence_elements pce

147: AND ocd.qualification_type = 2 -- 2 is competence
148: AND FROM_DATE <= l_eff_date
149: AND nvl(TO_DATE, sysdate) >= l_eff_date
150: AND ocd.qualification_id NOT IN (SELECT competence_id
151: FROM per_competence_elements pce
152: WHERE nvl(pce.effective_date_to, sysdate) >= SYSDATE
153: AND pce.effective_date_from <= SYSDATE
154: AND pce.PROFICIENCY_LEVEL_ID >= ocd.PROFICIENCY_LEVEL_ID
155: AND pce.business_group_id = l_business_group_id

Line 269: FROM per_competence_elements pce

265: AND ocd.qualification_type = 2 -- 2 is competence
266: AND FROM_DATE <= v_date
267: AND nvl(TO_DATE,sysdate) >= v_date
268: AND ocd.qualification_id NOT IN (SELECT competence_id
269: FROM per_competence_elements pce
270: WHERE nvl(pce.effective_date_to, sysdate) >= SYSDATE
271: AND pce.effective_date_from <= SYSDATE
272: AND pce.PROFICIENCY_LEVEL_ID >= ocd.PROFICIENCY_LEVEL_ID
273: AND pce.business_group_id = v_business_id