APPS.HR_PERSON_DELETE dependencies on PER_PERSONAL_SCORECARDS

Line 1747: FROM per_personal_scorecards

1743: BEGIN
1744: DELETE
1745: FROM per_objectives
1746: WHERE scorecard_id IN (SELECT scorecard_id
1747: FROM per_personal_scorecards
1748: WHERE person_id = P_PERSON_ID)
1749: OR appraisal_id in (SELECT appraisal_id
1750: FROM per_appraisals
1751: WHERE appraisee_person_id = p_person_id) ;

Line 1756: FROM per_personal_scorecards

1752:
1753: DELETE
1754: FROM per_scorecard_sharing
1755: WHERE scorecard_id IN (SELECT scorecard_id
1756: FROM per_personal_scorecards
1757: WHERE person_id = P_PERSON_ID);
1758: DELETE
1759: FROM hr_api_transaction_steps
1760: WHERE transaction_id IN (SELECT a.transaction_id

Line 1762: per_personal_scorecards sc

1758: DELETE
1759: FROM hr_api_transaction_steps
1760: WHERE transaction_id IN (SELECT a.transaction_id
1761: FROM hr_api_transactions a,
1762: per_personal_scorecards sc
1763: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1764: AND a.transaction_ref_id = sc.scorecard_id
1765: AND sc.person_id = P_PERSON_ID);
1766:

Line 1763: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

1759: FROM hr_api_transaction_steps
1760: WHERE transaction_id IN (SELECT a.transaction_id
1761: FROM hr_api_transactions a,
1762: per_personal_scorecards sc
1763: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1764: AND a.transaction_ref_id = sc.scorecard_id
1765: AND sc.person_id = P_PERSON_ID);
1766:
1767: DELETE

Line 1771: per_personal_scorecards sc

1767: DELETE
1768: FROM hr_api_transactions
1769: WHERE transaction_id IN (SELECT transaction_id
1770: FROM hr_api_transactions a,
1771: per_personal_scorecards sc
1772: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1773: AND a.transaction_ref_id = sc.scorecard_id
1774: AND sc.person_id = P_PERSON_ID);
1775: DELETE

Line 1772: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'

1768: FROM hr_api_transactions
1769: WHERE transaction_id IN (SELECT transaction_id
1770: FROM hr_api_transactions a,
1771: per_personal_scorecards sc
1772: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1773: AND a.transaction_ref_id = sc.scorecard_id
1774: AND sc.person_id = P_PERSON_ID);
1775: DELETE
1776: FROM per_personal_scorecards

Line 1776: FROM per_personal_scorecards

1772: WHERE a.transaction_ref_table = 'PER_PERSONAL_SCORECARDS'
1773: AND a.transaction_ref_id = sc.scorecard_id
1774: AND sc.person_id = P_PERSON_ID);
1775: DELETE
1776: FROM per_personal_scorecards
1777: WHERE person_id = P_PERSON_ID;
1778:
1779: EXCEPTION
1780: WHEN Others Then