DBA Data[Home] [Help]

APPS.HRI_BPL_FAST_FORMULA dependencies on PER_RATING_LEVELS

Line 836: FROM per_rating_levels

832: IS
833: --
834: CURSOR csr_rating_template_scales (cp_rating_scale_id NUMBER) IS
835: SELECT COUNT(step_value)
836: FROM per_rating_levels
837: WHERE rating_scale_id = cp_rating_scale_id;
838: --
839: -- Used to store the number of levels in the rating scale.
840: --

Line 927: ,per_rating_levels prl

923: ,prs.rating_scale_id
924: ,prl.step_value
925: FROM per_appraisal_templates pat
926: ,per_rating_scales prs
927: ,per_rating_levels prl
928: WHERE pat.business_group_id = cp_business_group_id
929: AND pat.rating_scale_id = prs.rating_scale_id
930: AND pat.rating_scale_id = prl.rating_scale_id
931: ORDER BY business_group_id