DBA Data[Home] [Help]

APPS.HR_PERSON_INTERNAL dependencies on PER_ASSESSMENTS

Line 3844: FROM per_assessments

3840: BEGIN
3841: DELETE
3842: FROM per_competence_elements
3843: WHERE assessment_id IN (SELECT assessment_id
3844: FROM per_assessments
3845: WHERE appraisal_id IN (SELECT appraisal_id
3846: FROM per_appraisals
3847: WHERE appraisee_person_id = P_PERSON_ID));
3848: DELETE

Line 3854: FROM per_assessments

3850: WHERE appraisal_id IN (SELECT appraisal_id
3851: FROM per_appraisals
3852: WHERE appraisee_person_id = P_PERSON_ID);
3853: DELETE
3854: FROM per_assessments
3855: WHERE appraisal_id IN (SELECT appraisal_id
3856: FROM per_appraisals
3857: WHERE appraisee_person_id = P_PERSON_ID);
3858: