APPS.PER_RTL_BUS dependencies on PER_COMPETENCE_ELEMENTS

Line 460: per_competence_elements ce

456: -- condition added to cursor to check the competence element type.
457: Cursor csr_chk_competence is
458: select null
459: from per_rating_levels rtl, per_competences cp,
460: per_competence_elements ce
461: where rtl.competence_id = p_competence_id
462: and rtl.competence_id = cp.competence_id
463: and cp.competence_id = ce.competence_id
464: and ce.type in ('ASSESSMENT_COMPETENCE','REQUIREMENT',

Line 605: from per_rating_levels rtl,per_competence_elements perce

601: -- check if rating level is used in competence element
602: hr_utility.set_location (l_proc, 1);
603: l_error := 'N';
604: l_sql_stmt := 'select null
605: from per_rating_levels rtl,per_competence_elements perce
606: where rtl.rating_level_id = '||p_rating_level_id||
607: ' and rtl.rating_level_id = ';
608: l_sql_stmt1 := l_sql_stmt||'perce.rating_level_id';
609: