APPS.HR_COMPLETE_APPRAISAL_SS dependencies on PER_ALL_PEOPLE_F

Line 215: appraisee_name per_all_people_f.full_name%TYPE,

211: END;
212:
213: PROCEDURE generate_appraisal_status (
214: appraisal_date per_appraisals.appraisal_date%TYPE,
215: appraisee_name per_all_people_f.full_name%TYPE,
216: appraisal_status hr_lookups.meaning%TYPE,
217: appraisal_type hr_lookups.meaning%TYPE,
218: RESULT fnd_new_messages.MESSAGE_TEXT%TYPE,
219: reason VARCHAR2,

Line 326: per_all_people_f ppf,

322: apprtype.meaning appraisal_type,
323: NVL (appr.provide_overall_feedback, 'N') provide_overall_feedback,
324: appr.appraisal_system_status
325: FROM per_appraisals appr,
326: per_all_people_f ppf,
327: hr_lookups apprstatus,
328: hr_lookups apprtype
329: WHERE appr.appraisal_id = appr_id
330: AND ppf.person_id = appr.appraisee_person_id

Line 350: full_name per_all_people_f.full_name%TYPE,

346: appraisal_id per_appraisals.appraisal_id%TYPE,
347: object_version_number per_appraisals.object_version_number%TYPE,
348: appraiser_person_id per_appraisals.appraiser_person_id%TYPE,
349: appraisee_person_id per_appraisals.appraisee_person_id%TYPE,
350: full_name per_all_people_f.full_name%TYPE,
351: appraisal_date per_appraisals.appraisal_date%TYPE,
352: apprstatus hr_lookups.meaning%TYPE,
353: apprtype hr_lookups.meaning%TYPE,
354: provide_overall_feedback per_appraisals.provide_overall_feedback%TYPE,

Line 561: per_all_people_f ppf,

557: DECODE (rating.step_value, NULL, NULL, rating.step_value || ' - ' || rating.NAME)
558: prof_level
559: FROM per_competence_elements pce,
560: per_appraisals pa,
561: per_all_people_f ppf,
562: per_competences pc,
563: per_rating_levels rating
564: WHERE pce.TYPE = 'ASSESSMENT'
565: AND pce.object_name = 'APPRAISAL_ID'

Line 1987: CURSOR check_contingent_worker (appraisee_person_id per_all_people_f.person_id%TYPE)

1983: );
1984:
1985: appraisal_rec appraisal_record;
1986:
1987: CURSOR check_contingent_worker (appraisee_person_id per_all_people_f.person_id%TYPE)
1988: IS
1989: SELECT current_npw_flag
1990: FROM per_all_people_f
1991: WHERE person_id = appraisee_person_id

Line 1990: FROM per_all_people_f

1986:
1987: CURSOR check_contingent_worker (appraisee_person_id per_all_people_f.person_id%TYPE)
1988: IS
1989: SELECT current_npw_flag
1990: FROM per_all_people_f
1991: WHERE person_id = appraisee_person_id
1992: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
1993:
1994: current_npw_flag per_all_people_f.current_npw_flag%TYPE DEFAULT '';

Line 1994: current_npw_flag per_all_people_f.current_npw_flag%TYPE DEFAULT '';

1990: FROM per_all_people_f
1991: WHERE person_id = appraisee_person_id
1992: AND TRUNC (SYSDATE) BETWEEN effective_start_date AND effective_end_date;
1993:
1994: current_npw_flag per_all_people_f.current_npw_flag%TYPE DEFAULT '';
1995: found_overall_performance BOOLEAN := FALSE;
1996: error_message VARCHAR2 (500) DEFAULT NULL;
1997: -- Declare program variables as shown above
1998: BEGIN