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 1665: ,hr_quest_answers qsa

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

Line 1698: ,hr_quest_answers qsa

1694: delete from hr_quest_answer_values qsv2
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'

Line 1721: , hr_quest_answers qsa

1717: /* delete from hr_quest_answer_values qsv2
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

Line 1738: -- Now delete from HR_QUEST_ANSWERS

1734: when NO_DATA_FOUND then
1735: hr_utility.set_location('HR_PERSON_DELETE.DELETE_A_PERSON', 1101);
1736: end;
1737: */
1738: -- Now delete from HR_QUEST_ANSWERS
1739: begin
1740: delete from hr_quest_answers qsa2
1741: where qsa2.questionnaire_answer_id in (
1742: select qsa.questionnaire_answer_id

Line 1740: delete from hr_quest_answers qsa2

1736: end;
1737: */
1738: -- Now delete from HR_QUEST_ANSWERS
1739: begin
1740: delete from hr_quest_answers qsa2
1741: where qsa2.questionnaire_answer_id in (
1742: select qsa.questionnaire_answer_id
1743: from hr_quest_answers qsa
1744: , per_participants par

Line 1743: from hr_quest_answers qsa

1739: begin
1740: delete from hr_quest_answers qsa2
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'