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_OCL_BUS dependencies on PER_COMPETENCES

Line 380: FROM PER_COMPETENCES

376: --
377: CURSOR csr_competence
378: IS
379: SELECT null
380: FROM PER_COMPETENCES
381: WHERE COMPETENCE_ID = p_competence_id and
382: Business_group_id = l_business_group_id ;
383:
384: CURSOR csr_competence_cross

Line 387: FROM per_competences

383:
384: CURSOR csr_competence_cross
385: IS
386: SELECT null
387: FROM per_competences
388: WHERE COMPETENCE_ID = p_competence_id and
389: (business_group_id = l_business_group_id OR
390: business_group_id is null);
391:

Line 475: ,per_competences pce

471: */
472: select null
473: from
474: per_rating_levels prl
475: ,per_competences pce
476: where (prl.rating_scale_id = pce.rating_scale_id
477: OR pce.competence_id = prl.competence_id)
478: AND pce.competence_id = p_competence_id
479: AND prl.rating_level_id = p_min_proficiency_level_id;