APPS.HR_PERSON_DELETE dependencies on PER_APPRAISALS

Line 120: per_appraisals,

116: per_person_dlvry_methods
117: 115.4 07-Sep-98 smcmilla Added to delete_a_person to delete from
118: hr_quest_answer_values,
119: hr_quest_answers,
120: per_appraisals,
121: per_participants.
122: 115.5 08-SEP-98 smcmilla Disallow delete if orws exist in
123: PER_APPRAISALS or PER_PARTICIPANTS.
124: Change made to moderate_predel...

Line 123: PER_APPRAISALS or PER_PARTICIPANTS.

119: hr_quest_answers,
120: per_appraisals,
121: per_participants.
122: 115.5 08-SEP-98 smcmilla Disallow delete if orws exist in
123: PER_APPRAISALS or PER_PARTICIPANTS.
124: Change made to moderate_predel...
125: 115.6 17-MAR-1999 mmillmor 814301 Altered DELETE_A_PERSON to delete from
126: per_all_people_f and per_all_assignments_f
127: 115.7 18-MAR-98 CColeman Added WIP pre-del validation.

Line 209: HR_QUEST_ANSWER_VALUES and PER_APPRAISALS.

205: 115.41 19-JAN-2006 vbanner 4873360 Performance Fix of SQL ID:14959971
206: Rewrote Delete from HR_QUEST_ANSWER_VALUES
207: to avoid a cartesian join and a full
208: table scan on PER_PARTICIPANTS,
209: HR_QUEST_ANSWER_VALUES and PER_APPRAISALS.
210: Broke query into two peices using Conditional logic in a pl/sql block to see
211: if delete needs to be run.
212: 115.42 27-Jul-2006 pdkundu 5405424 Modified the procedure hr_person_delete.
213: moderate_predel_validation to change the

Line 907: from per_appraisals apr

903: into v_delete_permitted
904: from sys.dual
905: where not exists (
906: select null
907: from per_appraisals apr
908: where apr.appraisee_person_id = P_PERSON_ID
909: or apr.appraiser_person_id = P_PERSON_ID);
910: exception
911: when NO_DATA_FOUND then

Line 1643: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS

1639: --
1640: -- Bug 4873360 fix for performance repository sql id 14959971.
1641: -- Rewrote the delete query commented out below (and already once tuned for
1642: -- bug 3619599) to avoid a merge join cartesian and a full table scan on
1643: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS
1644: --
1645: -- Broke query into two peices using conditional logic in a pl/sql block to
1646: -- see if delete needs to be run.
1647: --

Line 1687: from per_appraisals apr

1683: into v_dummy
1684: from sys.dual
1685: where exists (
1686: select null
1687: from per_appraisals apr
1688: where (apr.appraiser_person_id = P_PERSON_ID
1689: or apr.appraisee_person_id = P_PERSON_ID));
1690:
1691: if v_dummy = 2

Line 1699: ,per_appraisals apr

1695: where qsv2.quest_answer_val_id in
1696: (select qsv.quest_answer_val_id
1697: from hr_quest_answer_values qsv
1698: ,hr_quest_answers qsa
1699: ,per_appraisals apr
1700: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
1701: and qsa.type_object_id = apr.appraisal_id
1702: and qsa.type='APPRAISAL'
1703: and (apr.appraisee_person_id = P_PERSON_ID

Line 1722: , per_appraisals apr

1718: where qsv2.quest_answer_val_id in (
1719: select qsv.quest_answer_val_id
1720: from hr_quest_answer_values qsv
1721: , hr_quest_answers qsa
1722: , per_appraisals apr
1723: , per_participants par
1724: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
1725: and (qsa.type_object_id = apr.appraisal_id
1726: and qsa.type='APPRAISAL'

Line 1745: , per_appraisals apr

1741: where qsa2.questionnaire_answer_id in (
1742: select qsa.questionnaire_answer_id
1743: from hr_quest_answers qsa
1744: , per_participants par
1745: , per_appraisals apr
1746: where (qsa.type_object_id = apr.appraisal_id
1747: and qsa.type='APPRAISAL'
1748: and (apr.appraiser_person_id = P_PERSON_ID
1749: or apr.appraisee_person_id = P_PERSON_ID))

Line 1768: AND par2.participation_in_table = 'PER_APPRAISALS'

1764: WHERE par2.person_id = P_PERSON_ID
1765: OR
1766: (
1767: par2.participation_in_column = 'APPRAISAL_ID'
1768: AND par2.participation_in_table = 'PER_APPRAISALS'
1769: AND par2.participation_in_id in
1770: (
1771: SELECT
1772: apr.appraisal_id

Line 1773: FROM per_appraisals apr

1769: AND par2.participation_in_id in
1770: (
1771: SELECT
1772: apr.appraisal_id
1773: FROM per_appraisals apr
1774: WHERE
1775: (
1776: apr.appraisee_person_id = P_PERSON_ID
1777: OR apr.appraiser_person_id = P_PERSON_ID

Line 1786: -- Now delete from per_appraisals

1782: when NO_DATA_FOUND then
1783: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1103);
1784: end;
1785: --
1786: -- Now delete from per_appraisals
1787: --
1788: begin
1789: delete from per_appraisals apr
1790: where apr.appraiser_person_id = P_PERSON_ID

Line 1789: delete from per_appraisals apr

1785: --
1786: -- Now delete from per_appraisals
1787: --
1788: begin
1789: delete from per_appraisals apr
1790: where apr.appraiser_person_id = P_PERSON_ID
1791: or apr.appraisee_person_id = P_PERSON_ID;
1792: exception
1793: when NO_DATA_FOUND then