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 2245: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS

2241: --
2242: -- Bug 4873360 fix for performance repository sql id 14960331.
2243: -- Rewrote the delete query commented out below (and already once tuned for
2244: -- bug 3619599) to avoid a merge join cartesian and a full table scan on
2245: -- PER_PARTICIPANTS, HR_QUEST_ANSWER_VALUES and PER_APPRAISALS
2246: --
2247: -- Broke query into two peices using conditional logic in a pl/sql block to
2248: -- see if delete needs to be run.
2249: --

Line 2250: begin -- Delete from HR_QUEST_ANSWER_VALUES

2246: --
2247: -- Broke query into two peices using conditional logic in a pl/sql block to
2248: -- see if delete needs to be run.
2249: --
2250: begin -- Delete from HR_QUEST_ANSWER_VALUES
2251: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2252: begin
2253: select 1
2254: into l_dummy

Line 2251: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS

2247: -- Broke query into two peices using conditional logic in a pl/sql block to
2248: -- see if delete needs to be run.
2249: --
2250: begin -- Delete from HR_QUEST_ANSWER_VALUES
2251: begin -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2252: begin
2253: select 1
2254: into l_dummy
2255: from sys.dual

Line 2270: delete from hr_quest_answer_values qsv2

2266: end;
2267: if l_dummy = 1
2268: then
2269: l_dummy := null;
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

Line 2273: from hr_quest_answer_values qsv

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

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

2280: end if;
2281: if g_debug then
2282: hr_utility.set_location(l_proc, 215);
2283: end if;
2284: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2285: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2286: begin
2287: select 2
2288: into l_dummy

Line 2285: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS

2281: if g_debug then
2282: hr_utility.set_location(l_proc, 215);
2283: end if;
2284: end; -- Delete from HR_QUEST_ANSWER_VALUES: PARTICIPANTS
2285: begin -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2286: begin
2287: select 2
2288: into l_dummy
2289: from sys.dual

Line 2305: delete from hr_quest_answer_values qsv2

2301: end;
2302: if l_dummy = 2
2303: then
2304: l_dummy := null;
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

Line 2308: from hr_quest_answer_values qsv

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

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

2316: if g_debug then
2317: hr_utility.set_location(l_proc, 221);
2318: end if;
2319: end if;
2320: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2321: end; -- Delete from HR_QUEST_ANSWER_VALUES
2322: -- original sql.
2323: /* -- Delete from HR_QUEST_ANSWER_VALUES
2324: delete from hr_quest_answer_values qsv2

Line 2321: end; -- Delete from HR_QUEST_ANSWER_VALUES

2317: hr_utility.set_location(l_proc, 221);
2318: end if;
2319: end if;
2320: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2321: end; -- Delete from HR_QUEST_ANSWER_VALUES
2322: -- original sql.
2323: /* -- Delete from HR_QUEST_ANSWER_VALUES
2324: delete from hr_quest_answer_values qsv2
2325: where qsv2.quest_answer_val_id in

Line 2323: /* -- Delete from HR_QUEST_ANSWER_VALUES

2319: end if;
2320: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2321: end; -- Delete from HR_QUEST_ANSWER_VALUES
2322: -- original sql.
2323: /* -- Delete from HR_QUEST_ANSWER_VALUES
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

Line 2324: delete from hr_quest_answer_values qsv2

2320: end; -- Delete from HR_QUEST_ANSWER_VALUES: APPRAISALS
2321: end; -- Delete from HR_QUEST_ANSWER_VALUES
2322: -- original sql.
2323: /* -- Delete from HR_QUEST_ANSWER_VALUES
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

Line 2327: from hr_quest_answer_values qsv

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