APPS.HXT_BATCH_VAL dependencies on PER_ALL_PEOPLE_F

Line 2208: FROM per_all_people_f

2204: RETURN g_name_tab(p_person_id);
2205: ELSE
2206: SELECT full_name
2207: INTO g_name_tab(p_person_id)
2208: FROM per_all_people_f
2209: WHERE person_id = p_person_id
2210: AND TRUNC(SYSDATE) BETWEEN effective_start_date -- Bug 10143866
2211: AND effective_end_date;
2212: RETURN g_name_tab(p_person_id);

Line 2246: FROM per_all_people_f

2242: RETURN g_assig_tab(p_person_id);
2243: ELSE
2244: SELECT employee_number
2245: INTO g_assig_tab(p_person_id)
2246: FROM per_all_people_f
2247: WHERE person_id = p_person_id
2248: AND TRUNC(SYSDATE) BETWEEN effective_start_date -- Bug 10143866
2249: AND effective_end_date;
2250: RETURN g_assig_tab(p_person_id);