APPS.HR_WPM_UTIL dependencies on PER_APPRAISALS

Line 9: FROM per_appraisals

5: SELECT appraisal_id,
6: overall_performance_level_id,
7: appraisal_date,
8: appraisal_system_status
9: FROM per_appraisals
10: WHERE appraisee_person_id = p_person_id AND appraisal_date <= TRUNC (SYSDATE)
11: ORDER BY appraisal_date DESC;
12:
13: TYPE get_appraisal_info_rec IS RECORD (

Line 14: appraisal_id per_appraisals.appraisal_id%TYPE,

10: WHERE appraisee_person_id = p_person_id AND appraisal_date <= TRUNC (SYSDATE)
11: ORDER BY appraisal_date DESC;
12:
13: TYPE get_appraisal_info_rec IS RECORD (
14: appraisal_id per_appraisals.appraisal_id%TYPE,
15: overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE,
16: appraisal_date per_appraisals.appraisal_date%TYPE,
17: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
18: );

Line 15: overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE,

11: ORDER BY appraisal_date DESC;
12:
13: TYPE get_appraisal_info_rec IS RECORD (
14: appraisal_id per_appraisals.appraisal_id%TYPE,
15: overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE,
16: appraisal_date per_appraisals.appraisal_date%TYPE,
17: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
18: );
19:

Line 16: appraisal_date per_appraisals.appraisal_date%TYPE,

12:
13: TYPE get_appraisal_info_rec IS RECORD (
14: appraisal_id per_appraisals.appraisal_id%TYPE,
15: overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE,
16: appraisal_date per_appraisals.appraisal_date%TYPE,
17: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
18: );
19:
20: FUNCTION get_latest_appraisal_id (p_person_id IN NUMBER)

Line 17: appraisal_system_status per_appraisals.appraisal_system_status%TYPE

13: TYPE get_appraisal_info_rec IS RECORD (
14: appraisal_id per_appraisals.appraisal_id%TYPE,
15: overall_performance_level_id per_appraisals.overall_performance_level_id%TYPE,
16: appraisal_date per_appraisals.appraisal_date%TYPE,
17: appraisal_system_status per_appraisals.appraisal_system_status%TYPE
18: );
19:
20: FUNCTION get_latest_appraisal_id (p_person_id IN NUMBER)
21: RETURN NUMBER