APPS.IEX_STRATEGY_WF dependencies on PER_COMPETENCE_ELEMENTS

Line 658: from per_competence_elements

654: l_found BOOLEAN ;
655: cursor c_get_person_id (l_person_id NUMBER,
656: l_competence_id NUMBER)is
657: select count(person_id)
658: from per_competence_elements
659: where competence_id = l_competence_id
660: and person_id = l_person_id
661: and trunc(NVL(effective_date_to,SYSDATE)) >= trunc(sysdate)
662: and trunc(effective_date_from) <= trunc(sysdate) ;

Line 4196: from per_competence_elements

4192: -- Changed for the bug#7656223 by PNAVEENK on 2-1-2009
4193: cursor c_get_person_id (l_person_id NUMBER,
4194: l_competence_id NUMBER)is
4195: select count(person_id)
4196: from per_competence_elements
4197: where competence_id =l_competence_id
4198: and person_id =l_person_id
4199: and trunc(NVL(effective_date_to,SYSDATE)) >= trunc(sysdate)
4200: and trunc(effective_date_from) <= trunc(sysdate) ;

Line 4391: from per_competence_elements

4387: -- Changed for the bug#7656223 by PNAVEENK on 2-1-2009
4388: cursor c_get_person_id (l_person_id NUMBER,
4389: l_competence_id NUMBER)is
4390: select count(person_id)
4391: from per_competence_elements
4392: where competence_id =l_competence_id
4393: and person_id =l_person_id
4394: and trunc(NVL(effective_date_to,SYSDATE)) >= trunc(sysdate)
4395: and trunc(effective_date_from) <= trunc(sysdate) ;