APPS.PER_CEL_BUS dependencies on PER_ASSESSMENTS

Line 1233: from per_assessments

1229: -- cursor to check that the assessment_id is valid
1230: --
1231: cursor csr_valid_assessment_id is
1232: select business_group_id
1233: from per_assessments
1234: where p_assessment_id = assessment_id;
1235: --
1236: --
1237: -- cursor to check that the assessment_type_id is valid

Line 2490: per_assessments ass,

2486: cursor csr_valid_rate_weight_id (c_rate_level_id in number,
2487: c_scale_type in varchar2)is
2488: select ast.rating_scale_id, ast.weighting_scale_id
2489: from per_assessment_types ast,
2490: per_assessments ass,
2491: per_rating_levels ral
2492: where ass.assessment_id = p_assessment_id
2493: and ass.assessment_type_id = ast.assessment_type_id
2494: and decode(c_scale_type, 'PERFORMANCE', ast.rating_scale_id,

Line 3112: from per_assessments

3108: --
3109:
3110: cursor csr_get_ass_type_id is
3111: select assessment_type_id
3112: from per_assessments
3113: where p_business_group_id + 0 = business_group_id
3114: and p_assessment_id = assessment_id;
3115: --
3116: begin

Line 4507: From per_assessments asn

4503: where type = 'ASSESSMENT'
4504: and competence_id = p_competence_id
4505: and assessment_id in
4506: (Select asn.assessment_id
4507: From per_assessments asn
4508: Where asn.assessment_type_id =
4509: (Select assessment_type_id
4510: From per_competence_elements
4511: Where competence_element_id =