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 PER_APPRAISALS

Line 1101: from per_appraisals apr

1097: into l_delete_permitted
1098: from sys.dual
1099: where not exists (
1100: select null
1101: from per_appraisals apr
1102: where apr.appraisee_person_id = P_PERSON_ID
1103: or apr.appraiser_person_id = P_PERSON_ID);
1104: --
1105: exception

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 2324: from per_appraisals apr

2320: into l_dummy
2321: from sys.dual
2322: where exists (
2323: select null
2324: from per_appraisals apr
2325: where (apr.appraiser_person_id = P_PERSON_ID
2326: or apr.appraisee_person_id = P_PERSON_ID));
2327: exception
2328: when NO_DATA_FOUND then

Line 2342: ,per_appraisals apr

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'
2346: and (apr.appraisee_person_id = P_PERSON_ID

Line 2361: ,per_appraisals apr

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
2365: and qsa.type='APPRAISAL'

Line 2387: ,per_appraisals apr

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
2391: or apr.appraisee_person_id = p_person_id))

Line 2422: ,per_appraisals apr

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'
2426: and participation_in_id = apr.appraisal_id

Line 2425: and par.participation_in_table = 'PER_APPRAISALS'

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'
2426: and participation_in_id = apr.appraisal_id
2427: and (apr.appraisee_person_id = P_PERSON_ID
2428: or apr.appraiser_person_id = p_person_id)
2429: )

Line 2439: -- Now delete from per_appraisals

2435: hr_utility.set_location(l_proc, 240);
2436: end if;
2437: end;
2438: --
2439: -- Now delete from per_appraisals
2440: /*
2441: --
2442: begin
2443: --

Line 2444: delete from per_appraisals apr

2440: /*
2441: --
2442: begin
2443: --
2444: delete from per_appraisals apr
2445: where -- apr.appraiser_person_id = P_PERSON_ID or
2446: -- changed as part of bug#8865114
2447: apr.appraisee_person_id = P_PERSON_ID;
2448: --

Line 3806: FROM per_appraisals

3802: WHERE scorecard_id IN (SELECT scorecard_id
3803: FROM per_personal_scorecards
3804: WHERE person_id = P_PERSON_ID)
3805: OR appraisal_id in (SELECT appraisal_id
3806: FROM per_appraisals
3807: WHERE appraisee_person_id = p_person_id) ;
3808:
3809: DELETE
3810: FROM per_scorecard_sharing

Line 3846: FROM per_appraisals

3842: FROM per_competence_elements
3843: WHERE assessment_id IN (SELECT assessment_id
3844: FROM per_assessments
3845: WHERE appraisal_id IN (SELECT appraisal_id
3846: FROM per_appraisals
3847: WHERE appraisee_person_id = P_PERSON_ID));
3848: DELETE
3849: FROM per_performance_ratings
3850: WHERE appraisal_id IN (SELECT appraisal_id

Line 3851: FROM per_appraisals

3847: WHERE appraisee_person_id = P_PERSON_ID));
3848: DELETE
3849: FROM per_performance_ratings
3850: WHERE appraisal_id IN (SELECT appraisal_id
3851: FROM per_appraisals
3852: WHERE appraisee_person_id = P_PERSON_ID);
3853: DELETE
3854: FROM per_assessments
3855: WHERE appraisal_id IN (SELECT appraisal_id

Line 3856: FROM per_appraisals

3852: WHERE appraisee_person_id = P_PERSON_ID);
3853: DELETE
3854: FROM per_assessments
3855: WHERE appraisal_id IN (SELECT appraisal_id
3856: FROM per_appraisals
3857: WHERE appraisee_person_id = P_PERSON_ID);
3858:
3859: EXCEPTION
3860: WHEN Others Then

Line 3866: delete from per_appraisals apr

3862: END;
3863: -- fix 9885957
3864: begin
3865: --
3866: delete from per_appraisals apr
3867: where -- apr.appraiser_person_id = P_PERSON_ID or
3868: -- changed as part of bug#8865114
3869: apr.appraisee_person_id = P_PERSON_ID;
3870: --