APPS.GHR_SF52_VALIDN_PKG dependencies on PER_PERSON_TYPES

Line 94: l_person_type per_person_types.system_person_type%type;

90: ) is
91:
92: l_proc varchar2(72) := g_package || 'primary_reqd_chk_for_update_hr';
93: l_notification_id ghr_pa_requests.pa_notification_id%type;
94: l_person_type per_person_types.system_person_type%type;
95: l_session ghr_history_api.g_session_var_type;
96:
97: l_new_line VARCHAR2(1) := substr('
98: ',1,1); -- Bug 1844515 Anil

Line 109: per_person_types ppt

105:
106: Cursor c_per_type is
107: Select ppt.system_person_type
108: from per_people_f per,
109: per_person_types ppt
110: where per.person_id = p_pa_request_rec.person_id
111: and p_pa_request_rec.effective_date
112: between per.effective_start_date and per.effective_end_date
113: and ppt.person_type_id = per.person_type_id;