APPS.PER_RSC_BUS dependencies on PER_RATING_LEVELS

Line 499: select null from per_rating_levels rle

495: -- Define a cursor to to check id rating scales has any levels that
496: -- are referenced in competence element
497: --
498: cursor csr_get_rl_rating_level is --Bug fix 3732129
499: select null from per_rating_levels rle
500: where rle.rating_scale_id = p_rating_scale_id and
501: exists (select /*+ INDEX(pce)*/ null
502: from per_competence_elements pce
503: where (rle.rating_level_id= pce.rating_level_id)