APPS.PER_RTL_BUS dependencies on PER_COMPETENCES

Line 129: from per_competences

125: --
126: Cursor csr_competence_bus_grp_exist
127: is
128: select business_group_id
129: from per_competences
130: where competence_id = p_competence_id;
131: --
132: begin
133: hr_utility.set_location('Entering:'|| l_proc, 1);

Line 448: from per_competences cpn

444: -- that has a general proficiency scale assigned to it.
445: --
446: Cursor csr_chk_rating_in_competence is
447: select null
448: from per_competences cpn
449: where cpn.competence_id = p_competence_id
450: and cpn.rating_scale_id is not null;
451: --
452: -- Cursor to check if rating level used in a competence that is used

Line 459: from per_rating_levels rtl, per_competences cp,

455: -- bug fix 4063493
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

Line 474: per_competences cp

470: Cursor csr_chk_rat_competence is
471: select null
472: from per_rating_levels rtl,
473: per_rating_scales rsc,
474: per_competences cp
475: where rtl.rating_scale_id = p_rating_scale_id
476: and rtl.rating_scale_id = rsc.rating_scale_id
477: and rsc.rating_scale_id = cp.rating_scale_id ;
478: