APPS.EAM_ASSIGN_EMP_PUB dependencies on PER_COMPETENCE_ELEMENTS

Line 569: FROM PER_COMPETENCE_ELEMENTS pce

565: --msg('inside competence id check. Person id ==>'||p_person_id);
566: --msg('p_competence_id ==>'||p_competence_id);
567:
568: SELECT count(1) INTO l_count_competence
569: FROM PER_COMPETENCE_ELEMENTS pce
570: WHERE pce.person_id = p_person_id
571: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
572: AND pce.type = 'PERSONAL'
573: AND pce.competence_id = p_competence_id

Line 604: FROM PER_COMPETENCE_ELEMENTS pce,

600:
601: --msg('inside competence type check. Person id ==>'||p_person_id);
602: --msg('Competence type ==>'||p_competence_type);
603: SELECT COUNT(1) INTO l_count_competence_type
604: FROM PER_COMPETENCE_ELEMENTS pce,
605: PER_COMPETENCE_ELEMENTS pce1
606: WHERE pce.person_id = p_person_id
607: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
608: AND pce.type = 'PERSONAL'

Line 605: PER_COMPETENCE_ELEMENTS pce1

601: --msg('inside competence type check. Person id ==>'||p_person_id);
602: --msg('Competence type ==>'||p_competence_type);
603: SELECT COUNT(1) INTO l_count_competence_type
604: FROM PER_COMPETENCE_ELEMENTS pce,
605: PER_COMPETENCE_ELEMENTS pce1
606: WHERE pce.person_id = p_person_id
607: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
608: AND pce.type = 'PERSONAL'
609: AND pce.competence_id = pce1.competence_id

Line 700: FROM PER_COMPETENCE_ELEMENTS pce

696: AND ( ppf.current_employee_flag is null
697: OR ppf.current_employee_flag = 'Y' )
698: AND ( p_competence_id IS NULL OR p_competence_id IN
699: ( SELECT competence_id
700: FROM PER_COMPETENCE_ELEMENTS pce
701: WHERE pce.person_id = ppf.person_id
702: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
703: AND pce.type = 'PERSONAL'
704: AND pce.competence_id = p_competence_id

Line 711: FROM PER_COMPETENCE_ELEMENTS pce, PER_COMPETENCE_ELEMENTS pce1

707: )
708: )
709: AND ( p_competence_type IS NULL OR p_competence_type IN
710: ( SELECT pce1.competence_type
711: FROM PER_COMPETENCE_ELEMENTS pce, PER_COMPETENCE_ELEMENTS pce1
712: WHERE pce.person_id = ppf.person_id
713: AND pce.business_group_id = HR_GENERAL.GET_BUSINESS_GROUP_ID
714: AND pce.type = 'PERSONAL'
715: AND pce.competence_id = pce1.competence_id