DBA Data[Home] [Help]

APPS.HR_PERSON_DELETE dependencies on PER_ASSESSMENTS

Line 1788: FROM per_assessments

1784: BEGIN
1785: DELETE
1786: FROM per_competence_elements
1787: WHERE assessment_id IN (SELECT assessment_id
1788: FROM per_assessments
1789: WHERE appraisal_id IN (SELECT appraisal_id
1790: FROM per_appraisals
1791: WHERE appraisee_person_id = P_PERSON_ID));
1792: DELETE

Line 1798: FROM per_assessments

1794: WHERE appraisal_id IN (SELECT appraisal_id
1795: FROM per_appraisals
1796: WHERE appraisee_person_id = P_PERSON_ID);
1797: DELETE
1798: FROM per_assessments
1799: WHERE appraisal_id IN (SELECT appraisal_id
1800: FROM per_appraisals
1801: WHERE appraisee_person_id = P_PERSON_ID);
1802: