APPS.GHR_VALIDATE_CHECK dependencies on PER_PEOPLE_F

Line 30: l_person_type_id per_people_f.person_type_id%type;

26: l_assignment_found boolean := FALSE;
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:

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: -------