DBA Data[Home] [Help]

APPS.PER_RTL_BUS dependencies on PER_RATING_SCALES

Line 120: from per_rating_scales

116: --
117: Cursor csr_rat_scale_bus_grp_exist
118: is
119: select business_group_id
120: from per_rating_scales
121: where rating_scale_id = p_rating_scale_id;
122: --
123: --
124: -- Cursor to check if competence exists

Line 473: per_rating_scales rsc,

469: --
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 ;

Line 485: per_rating_scales rsc,

481: --
482: Cursor csr_chk_ass_types is
483: select null
484: from per_rating_levels rtl,
485: per_rating_scales rsc,
486: per_assessment_types aty
487: where rtl.rating_scale_id = p_rating_scale_id
488: and rtl.rating_scale_id = rsc.rating_scale_id
489: and ( (rsc.rating_scale_id = aty.rating_scale_id)