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.IEX_STRATEGY_WF dependencies on PER_COMPETENCE_ELEMENTS

Line 596: from per_competence_elements

592: l_found BOOLEAN ;
593: cursor c_get_person_id (l_person_id NUMBER,
594: l_competence_id NUMBER)is
595: select count(person_id)
596: from per_competence_elements
597: where competence_id = l_competence_id
598: and person_id = l_person_id
599: and trunc(NVL(effective_date_to,SYSDATE)) >= trunc(sysdate)
600: and trunc(effective_date_from) <= trunc(sysdate) ;

Line 3888: from per_competence_elements

3884: -- Changed for the bug#7656223 by PNAVEENK on 2-1-2009
3885: cursor c_get_person_id (l_person_id NUMBER,
3886: l_competence_id NUMBER)is
3887: select count(person_id)
3888: from per_competence_elements
3889: where competence_id =l_competence_id
3890: and person_id =l_person_id
3891: and trunc(NVL(effective_date_to,SYSDATE)) >= trunc(sysdate)
3892: and trunc(effective_date_from) <= trunc(sysdate) ;

Line 4083: from per_competence_elements

4079: -- Changed for the bug#7656223 by PNAVEENK on 2-1-2009
4080: cursor c_get_person_id (l_person_id NUMBER,
4081: l_competence_id NUMBER)is
4082: select count(person_id)
4083: from per_competence_elements
4084: where competence_id =l_competence_id
4085: and person_id =l_person_id
4086: and trunc(NVL(effective_date_to,SYSDATE)) >= trunc(sysdate)
4087: and trunc(effective_date_from) <= trunc(sysdate) ;