APPS.GHR_VALIDATE_CHECK dependencies on PER_PERSON_TYPES

Line 31: l_person_usr_type per_person_types.user_person_type%type;

27: l_per_system_status VARCHAR2(30);
28:
29: /* Get Person Type */
30: l_person_type_id per_people_f.person_type_id%type;
31: l_person_usr_type per_person_types.user_person_type%type;
32: l_person_sys_type per_person_types.system_person_type%type;
33: l_psn_status per_positions.status%type;
34:
35: l_part_time_hr ghr_pa_requests.part_time_hours%type;

Line 32: l_person_sys_type per_person_types.system_person_type%type;

28:
29: /* Get Person Type */
30: l_person_type_id per_people_f.person_type_id%type;
31: l_person_usr_type per_person_types.user_person_type%type;
32: l_person_sys_type per_person_types.system_person_type%type;
33: l_psn_status per_positions.status%type;
34:
35: l_part_time_hr ghr_pa_requests.part_time_hours%type;
36: l_work_schedule_code ghr_pa_requests.WORK_SCHEDULE%type;

Line 118: select ppt.system_person_type, ppt.user_person_type from PER_PERSON_TYPES ppt, PER_PEOPLE_F ppf

114: -------
115:
116: ------- Retrieve Person Types (System/User) --
117: cursor c_get_person_types(p_person_id number, p_eff_date date) is
118: select ppt.system_person_type, ppt.user_person_type from PER_PERSON_TYPES ppt, PER_PEOPLE_F ppf
119: where ppf.person_id = p_person_id
120: and trunc(p_eff_date) between ppf.effective_start_date and ppf.effective_end_date
121: and ppt.person_type_id = ppf.person_type_id;
122: -------