APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_ALL_PEOPLE_F

Line 187: appraisee_name per_all_people_f.full_name%TYPE,

183:
184:
185: PROCEDURE generate_appraisal_status
186: (appraisal_date per_appraisals.appraisal_date%TYPE,
187: appraisee_name per_all_people_f.full_name%TYPE,
188: appraisal_status hr_lookups.meaning%TYPE,
189: appraisal_type hr_lookups.meaning%TYPE,
190: result fnd_new_messages.message_text%TYPE,
191: reason varchar2,

Line 265: from per_appraisals appr, per_all_people_f ppf, hr_lookups apprstatus,

261: select appr.appraisal_id, appr.object_version_number,
262: appr.appraiser_person_id, appr.appraisee_person_id, ppf.full_name,
263: appr.appraisal_date, apprstatus.meaning appraisal_status, apprtype.meaning appraisal_type,
264: nvl(appr.provide_overall_feedback,'N') provide_overall_feedback, appr.appraisal_system_status
265: from per_appraisals appr, per_all_people_f ppf, hr_lookups apprstatus,
266: hr_lookups apprtype
267: where appr.appraisal_id = appr_id
268: and ppf.person_id = appr.appraisee_person_id
269: and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date

Line 288: full_name per_all_people_f.full_name%TYPE,

284: appraisal_id per_appraisals.appraisal_id%TYPE,
285: object_version_number per_appraisals.object_version_number%TYPE,
286: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
287: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
288: full_name per_all_people_f.full_name%TYPE,
289: appraisal_date per_appraisals.appraisal_date%TYPE,
290: apprstatus hr_lookups.meaning%TYPE,
291: apprtype hr_lookups.meaning%TYPE,
292: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,

Line 449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,

445: cursor get_assessment_competences (appr_id IN number) is
446: select pce.competence_id, pc.name, pce.competence_element_id, pce.proficiency_level_id,
447: pce.business_group_id, pce.enterprise_id,pce.effective_date_from, pce.effective_date_to, pa.appraisal_id, pa.appraisee_person_id,
448: ppf.party_id, decode(rating.step_value, null, null, rating.step_value||' - '||rating.name) prof_level
449: from per_competence_elements pce, per_appraisals pa, per_all_people_f ppf, per_competences pc,
450: per_rating_levels rating
451: where pce.type='ASSESSMENT'
452: and pce.object_name = 'APPRAISAL_ID'
453: and pce.object_id = appr_id

Line 1445: cursor check_contingent_worker(appraisee_person_id per_all_people_f.person_id%TYPE) IS

1441: );
1442:
1443: appraisal_rec appraisal_record;
1444:
1445: cursor check_contingent_worker(appraisee_person_id per_all_people_f.person_id%TYPE) IS
1446: select current_npw_flag from per_all_people_f
1447: where person_id = appraisee_person_id
1448: and trunc(sysdate) between effective_start_date and effective_end_date;
1449:

Line 1446: select current_npw_flag from per_all_people_f

1442:
1443: appraisal_rec appraisal_record;
1444:
1445: cursor check_contingent_worker(appraisee_person_id per_all_people_f.person_id%TYPE) IS
1446: select current_npw_flag from per_all_people_f
1447: where person_id = appraisee_person_id
1448: and trunc(sysdate) between effective_start_date and effective_end_date;
1449:
1450: current_npw_flag per_all_people_f.current_npw_flag%TYPE default '';

Line 1450: current_npw_flag per_all_people_f.current_npw_flag%TYPE default '';

1446: select current_npw_flag from per_all_people_f
1447: where person_id = appraisee_person_id
1448: and trunc(sysdate) between effective_start_date and effective_end_date;
1449:
1450: current_npw_flag per_all_people_f.current_npw_flag%TYPE default '';
1451: found_overall_performance boolean := false;
1452: error_message varchar2(500) default null;
1453:
1454: -- Declare program variables as shown above