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 148: FROM per_competence_elements pce

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

Line 266: FROM per_competence_elements pce

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