APPS.CS_CORE_UTIL dependencies on PER_PEOPLE_X

Line 280: FROM per_people_x

276:
277: IF p_employee_number <> fnd_api.g_miss_char THEN
278: BEGIN
279: SELECT person_id INTO x_employee_id
280: FROM per_people_x
281: WHERE employee_number = p_employee_number;
282: EXCEPTION
283: WHEN no_data_found THEN
284: x_return_status := fnd_api.g_ret_sts_error;

Line 299: FROM per_people_x

295: END IF;
296: ELSE
297: BEGIN
298: SELECT person_id INTO x_employee_id
299: FROM per_people_x
300: WHERE full_name = p_employee_name;
301: EXCEPTION
302: WHEN no_data_found THEN
303: x_return_status := fnd_api.g_ret_sts_error;

Line 1183: -- Validate against per_people_x, which contains all employees across

1179: l_dummy VARCHAR2(1);
1180: BEGIN
1181: x_return_status := fnd_api.g_ret_sts_success;
1182:
1183: -- Validate against per_people_x, which contains all employees across
1184: -- multiple business groups
1185: SELECT 'x' INTO l_dummy
1186: FROM per_people_x p, per_assignments_x a
1187: WHERE a.person_id = p_person_id

Line 1186: FROM per_people_x p, per_assignments_x a

1182:
1183: -- Validate against per_people_x, which contains all employees across
1184: -- multiple business groups
1185: SELECT 'x' INTO l_dummy
1186: FROM per_people_x p, per_assignments_x a
1187: WHERE a.person_id = p_person_id
1188: AND a.person_id = p.person_id
1189: AND a.assignment_type = 'E'
1190: AND a.primary_flag = 'Y'