APPS.HXC_ABS_RETRIEVAL_PKG dependencies on PER_ALL_PEOPLE_F

Line 185: l_emp_name per_all_people_f.full_name%TYPE;

181: days_tab t_absences;
182: hours_tab t_absences;
183: l_abs_retrieval_rule VARCHAR2 (50);
184: l_retrieval_rule_grp_id hxc_retrieval_rule_groups_v.retrieval_rule_group_id%TYPE;
185: l_emp_name per_all_people_f.full_name%TYPE;
186: l_temp_row hxc_abs_ret_temp%ROWTYPE;
187: l_count NUMBER;
188: l_days_ix NUMBER;
189: l_d_ix BINARY_INTEGER := 0;

Line 242: FROM per_all_people_f

238: END IF;
239:
240: SELECT full_name, business_group_id
241: INTO l_emp_name, g_business_group_id
242: FROM per_all_people_f
243: WHERE person_id = g_resource_id
244: AND g_tc_start between effective_start_date and effective_end_date;
245:
246: IF g_debug THEN