DBA Data[Home] [Help]

APPS.BIX_REAL_TIME_RPTS_PKG dependencies on PER_COMPETENCES

Line 811: from per_competences p1, per_competence_elements p2, jtf_rs_resource_extns j1,

807: order by I1.begin_date_time;
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