DBA Data[Home] [Help]

APPS.PER_PRT_BUS dependencies on PER_ASSESSMENT_TYPES

Line 397: per_assessment_types a

393: select null
394: from per_rating_levels r,
395: per_appraisal_templates t,
396: per_appraisals p,
397: per_assessment_types a
398: where p.appraisal_id = p_appraisal_id
399: and p.appraisal_template_id = t.appraisal_template_id
400: and t.objective_asmnt_type_id = a.assessment_type_id(+)
401: and r.rating_scale_id = decode(t.objective_asmnt_type_id, null, t.rating_scale_id, a.rating_scale_id)