APPS.HR_PERSON_DELETE dependencies on HR_QUEST_ANSWERS

Line 119: hr_quest_answers,

115: 115.3 13-Aug-98 I Harding Delete records from the table
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.

Line 182: hr_quest_answer_values and hr_quest_answers

178: validation Code in procedure
179: moderate_pre_del_validation as this check
180: is not required for CWK.
181: 115.31 12-May-2004 bdivvela 3619599 Modified delete queries on tables
182: hr_quest_answer_values and hr_quest_answers
183: in delete_a_person procedure
184: 115.32 07-Jun-2004 sbuche 3598568 Modified delete_a_person and people_default_deletes
185: procedures to call hr_security.delete_per_from_list
186: procedure for deleting a record in static list

Line 1666: ,hr_quest_answers qsa

1662: delete from hr_quest_answer_values qsv2
1663: where qsv2.quest_answer_val_id in
1664: (select qsv.quest_answer_val_id
1665: from hr_quest_answer_values qsv
1666: ,hr_quest_answers qsa
1667: ,per_participants par
1668: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
1669: and qsa.type_object_id = par.participant_id
1670: and qsa.type = 'PARTICIPANT'

Line 1699: ,hr_quest_answers qsa

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

Line 1722: , hr_quest_answers qsa

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

Line 1739: -- Now delete from HR_QUEST_ANSWERS

1735: when NO_DATA_FOUND then
1736: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1101);
1737: end;
1738: */
1739: -- Now delete from HR_QUEST_ANSWERS
1740: --
1741:
1742: -- fix for the bug 8265994
1743: BEGIN

Line 1810: delete from hr_quest_answers qsa2

1806: END;
1807: -- fix for the bug 8265994
1808: --
1809: begin
1810: delete from hr_quest_answers qsa2
1811: where qsa2.questionnaire_answer_id in (
1812: select qsa.questionnaire_answer_id
1813: from hr_quest_answers qsa
1814: , per_participants par

Line 1813: from hr_quest_answers qsa

1809: begin
1810: delete from hr_quest_answers qsa2
1811: where qsa2.questionnaire_answer_id in (
1812: select qsa.questionnaire_answer_id
1813: from hr_quest_answers qsa
1814: , per_participants par
1815: , per_appraisals apr
1816: where (qsa.type_object_id = apr.appraisal_id
1817: and qsa.type='APPRAISAL'