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.BIX_REAL_TIME_RPTS_PKG dependencies on PER_COMPETENCE_LEVELS_V

Line 812: PER_COMPETENCE_LEVELS_V p3

808:
809: cursor getAgentSkills IS
810: select p1.name skillname,p3.NAME skilllevel
811: from per_competences p1, per_competence_elements p2, jtf_rs_resource_extns j1,
812: PER_COMPETENCE_LEVELS_V p3
813: where p1.competence_id = p2.competence_id
814: and j1.resource_id = v_resource_id
815: and p2.person_id = j1.source_id
816: and (p2.EFFECTIVE_DATE_TO is null or p2.EFFECTIVE_DATE_TO >= sysdate)