APPS.HR_PERSON_INTERNAL dependencies on PER_PARTICIPANTS

Line 1122: from per_participants par

1118: into l_delete_permitted
1119: from sys.dual
1120: where not exists (
1121: select null
1122: from per_participants par
1123: where par.person_id = P_PERSON_ID);
1124: --
1125: exception
1126: when NO_DATA_FOUND then

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 2290: from per_participants par

2286: into l_dummy
2287: from sys.dual
2288: where exists (
2289: select null
2290: from per_participants par
2291: where par.person_id = P_PERSON_ID);
2292: exception
2293: when NO_DATA_FOUND then
2294: l_dummy := null;

Line 2307: ,per_participants par

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'
2311: and par.person_id = P_PERSON_ID);

Line 2362: ,per_participants par

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
2365: and qsa.type='APPRAISAL'
2366: and (apr.appraisee_person_id = P_PERSON_ID

Line 2396: ,per_participants par

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 )
2400: ) ;

Line 2410: -- Now delete from per_participants

2406: hr_utility.set_location(l_proc, 230);
2407: end if;
2408: end;
2409: --
2410: -- Now delete from per_participants
2411: begin
2412:
2413: -- Fix 4894116
2414: delete from per_participants par2

Line 2414: delete from per_participants par2

2410: -- Now delete from per_participants
2411: begin
2412:
2413: -- Fix 4894116
2414: delete from per_participants par2
2415: where par2.participant_id in
2416: ( select par.participant_id
2417: from per_participants par
2418: where par.person_id = P_PERSON_Id

Line 2417: from per_participants par

2413: -- Fix 4894116
2414: delete from per_participants par2
2415: where par2.participant_id in
2416: ( select par.participant_id
2417: from per_participants par
2418: where par.person_id = P_PERSON_Id
2419: union all
2420: select par.participant_id
2421: from per_participants par

Line 2421: from per_participants par

2417: from per_participants par
2418: where par.person_id = P_PERSON_Id
2419: union all
2420: select par.participant_id
2421: from per_participants par
2422: ,per_appraisals apr
2423: where
2424: (par.participation_in_column = 'APPRAISAL_ID'
2425: and par.participation_in_table = 'PER_APPRAISALS'