APPS.HR_PERSON_INTERNAL dependencies on HR_QUEST_ANSWERS

Line 2274: ,hr_quest_answers qsa

2270: delete from hr_quest_answer_values qsv2
2271: where qsv2.quest_answer_val_id in
2272: (select qsv.quest_answer_val_id
2273: from hr_quest_answer_values qsv
2274: ,hr_quest_answers qsa
2275: ,per_participants par
2276: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
2277: and qsa.type_object_id = par.participant_id
2278: and qsa.type = 'PARTICIPANT'

Line 2309: ,hr_quest_answers qsa

2305: delete from hr_quest_answer_values qsv2
2306: where qsv2.quest_answer_val_id in
2307: (select qsv.quest_answer_val_id
2308: from hr_quest_answer_values qsv
2309: ,hr_quest_answers qsa
2310: ,per_appraisals apr
2311: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
2312: and qsa.type_object_id = apr.appraisal_id
2313: and qsa.type='APPRAISAL'

Line 2328: ,hr_quest_answers qsa

2324: delete from hr_quest_answer_values qsv2
2325: where qsv2.quest_answer_val_id in
2326: (select qsv.quest_answer_val_id
2327: from hr_quest_answer_values qsv
2328: ,hr_quest_answers qsa
2329: ,per_appraisals apr
2330: ,per_participants par
2331: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
2332: and (qsa.type_object_id = apr.appraisal_id

Line 2346: -- Now delete from HR_QUEST_ANSWERS

2342: if g_debug then
2343: hr_utility.set_location(l_proc, 220);
2344: end if;
2345: end; */
2346: -- Now delete from HR_QUEST_ANSWERS
2347: begin
2348: --
2349: -- Fix 3619599 and 4894116
2350: delete from hr_quest_answers qsa2

Line 2350: delete from hr_quest_answers qsa2

2346: -- Now delete from HR_QUEST_ANSWERS
2347: begin
2348: --
2349: -- Fix 3619599 and 4894116
2350: delete from hr_quest_answers qsa2
2351: where qsa2.questionnaire_answer_id in
2352: (
2353: select qsa.questionnaire_answer_id
2354: from hr_quest_answers qsa

Line 2354: from hr_quest_answers qsa

2350: delete from hr_quest_answers qsa2
2351: where qsa2.questionnaire_answer_id in
2352: (
2353: select qsa.questionnaire_answer_id
2354: from hr_quest_answers qsa
2355: ,per_appraisals apr
2356: where (qsa.type_object_id = apr.appraisal_id
2357: and qsa.type='APPRAISAL'
2358: and (apr.appraiser_person_id = p_person_id

Line 2363: from hr_quest_answers qsa

2359: or apr.appraisee_person_id = p_person_id))
2360: Union All
2361:
2362: select qsa.questionnaire_answer_id
2363: from hr_quest_answers qsa
2364: ,per_participants par
2365: where (qsa.type_object_id = par.participant_id
2366: and qsa.type='PARTICIPANT'
2367: and par.person_id = p_person_id )