APPS.HR_PERSON_INTERNAL dependencies on HR_QUEST_ANSWERS

Line 2306: ,hr_quest_answers qsa

2302: delete from hr_quest_answer_values qsv2
2303: where qsv2.quest_answer_val_id in
2304: (select qsv.quest_answer_val_id
2305: from hr_quest_answer_values qsv
2306: ,hr_quest_answers qsa
2307: ,per_participants par
2308: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
2309: and qsa.type_object_id = par.participant_id
2310: and qsa.type = 'PARTICIPANT'

Line 2341: ,hr_quest_answers qsa

2337: delete from hr_quest_answer_values qsv2
2338: where qsv2.quest_answer_val_id in
2339: (select qsv.quest_answer_val_id
2340: from hr_quest_answer_values qsv
2341: ,hr_quest_answers qsa
2342: ,per_appraisals apr
2343: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
2344: and qsa.type_object_id = apr.appraisal_id
2345: and qsa.type='APPRAISAL'

Line 2360: ,hr_quest_answers qsa

2356: delete from hr_quest_answer_values qsv2
2357: where qsv2.quest_answer_val_id in
2358: (select qsv.quest_answer_val_id
2359: from hr_quest_answer_values qsv
2360: ,hr_quest_answers qsa
2361: ,per_appraisals apr
2362: ,per_participants par
2363: where qsv.questionnaire_answer_id = qsa.questionnaire_answer_id
2364: and (qsa.type_object_id = apr.appraisal_id

Line 2378: -- Now delete from HR_QUEST_ANSWERS

2374: if g_debug then
2375: hr_utility.set_location(l_proc, 220);
2376: end if;
2377: end; */
2378: -- Now delete from HR_QUEST_ANSWERS
2379: begin
2380: --
2381: -- Fix 3619599 and 4894116
2382: delete from hr_quest_answers qsa2

Line 2382: delete from hr_quest_answers qsa2

2378: -- Now delete from HR_QUEST_ANSWERS
2379: begin
2380: --
2381: -- Fix 3619599 and 4894116
2382: delete from hr_quest_answers qsa2
2383: where qsa2.questionnaire_answer_id in
2384: (
2385: select qsa.questionnaire_answer_id
2386: from hr_quest_answers qsa

Line 2386: from hr_quest_answers qsa

2382: delete from hr_quest_answers qsa2
2383: where qsa2.questionnaire_answer_id in
2384: (
2385: select qsa.questionnaire_answer_id
2386: from hr_quest_answers qsa
2387: ,per_appraisals apr
2388: where (qsa.type_object_id = apr.appraisal_id
2389: and qsa.type='APPRAISAL'
2390: and (apr.appraiser_person_id = p_person_id

Line 2395: from hr_quest_answers qsa

2391: or apr.appraisee_person_id = p_person_id))
2392: Union All
2393:
2394: select qsa.questionnaire_answer_id
2395: from hr_quest_answers qsa
2396: ,per_participants par
2397: where (qsa.type_object_id = par.participant_id
2398: and qsa.type='PARTICIPANT'
2399: and par.person_id = p_person_id )