eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_PERSON_INTERNAL dependencies on HR_QUEST_ANSWER_VALUES

Line 2277: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS

2273: --
2274: -- Bug 4873360 fix for performance repository sql id 14960331.
2275: -- Rewrote the delete query commented out below (and already once tuned for
2276: -- bug 3619599) to avoid a merge join cartesian and a full table scan on
2277: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS
2278: --
2279: -- Broke query into two peices using conditional logic in a pl/sql block to
2280: -- see if delete needs to be run.
2281: --

Line 2282: begin -- Delete from HR_QUEST_ANSWER_VALUES

2278: --
2279: -- Broke query into two peices using conditional logic in a pl/sql block to
2280: -- see if delete needs to be run.
2281: --
2282: begin -- Delete from HR_QUEST_ANSWER_VALUES
2283: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2284: begin
2285: select 1
2286: into l_dummy

Line 2283: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS

2279: -- Broke query into two peices using conditional logic in a pl/sql block to
2280: -- see if delete needs to be run.
2281: --
2282: begin -- Delete from HR_QUEST_ANSWER_VALUES
2283: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2284: begin
2285: select 1
2286: into l_dummy
2287: from sys.dual

Line 2302: delete from hr_quest_answer_values qsv2

2298: end;
2299: if l_dummy = 1
2300: then
2301: l_dummy := null;
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

Line 2305: from hr_quest_answer_values qsv

2301: l_dummy := null;
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

Line 2316: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS

2312: end if;
2313: if g_debug then
2314: hr_utility.set_location(l_proc, 215);
2315: end if;
2316: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2317: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2318: begin
2319: select 2
2320: into l_dummy

Line 2317: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS

2313: if g_debug then
2314: hr_utility.set_location(l_proc, 215);
2315: end if;
2316: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2317: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2318: begin
2319: select 2
2320: into l_dummy
2321: from sys.dual

Line 2337: delete from hr_quest_answer_values qsv2

2333: end;
2334: if l_dummy = 2
2335: then
2336: l_dummy := null;
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

Line 2340: from hr_quest_answer_values qsv

2336: l_dummy := null;
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

Line 2352: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS

2348: if g_debug then
2349: hr_utility.set_location(l_proc, 221);
2350: end if;
2351: end if;
2352: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2353: end; -- Delete from HR_QUEST_ANSWER_VALUES
2354: -- original sql.
2355: /* -- Delete from HR_QUEST_ANSWER_VALUES
2356: delete from hr_quest_answer_values qsv2

Line 2353: end; -- Delete from HR_QUEST_ANSWER_VALUES

2349: hr_utility.set_location(l_proc, 221);
2350: end if;
2351: end if;
2352: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2353: end; -- Delete from HR_QUEST_ANSWER_VALUES
2354: -- original sql.
2355: /* -- Delete from HR_QUEST_ANSWER_VALUES
2356: delete from hr_quest_answer_values qsv2
2357: where qsv2.quest_answer_val_id in

Line 2355: /* -- Delete from HR_QUEST_ANSWER_VALUES

2351: end if;
2352: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2353: end; -- Delete from HR_QUEST_ANSWER_VALUES
2354: -- original sql.
2355: /* -- Delete from HR_QUEST_ANSWER_VALUES
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

Line 2356: delete from hr_quest_answer_values qsv2

2352: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2353: end; -- Delete from HR_QUEST_ANSWER_VALUES
2354: -- original sql.
2355: /* -- Delete from HR_QUEST_ANSWER_VALUES
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

Line 2359: from hr_quest_answer_values qsv

2355: /* -- Delete from HR_QUEST_ANSWER_VALUES
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