APPS.CS_WORKFLOW_PUB dependencies on PER_PEOPLE_X

Line 779: FROM fnd_user fnd, per_people_x emp

775: -- If we can't get that information, just use the FND username
776: --
777: SELECT fnd.user_name, emp.full_name
778: INTO l_user_name, l_emp_name
779: FROM fnd_user fnd, per_people_x emp
780: WHERE fnd.user_id = p_user_id
781: AND fnd.employee_id = emp.person_id (+);
782:
783: IF (l_emp_name IS NOT NULL) THEN

Line 1853: FROM fnd_user fnd, per_people_x emp

1849: -- If we can't get that information, just use the FND username
1850: --
1851: SELECT fnd.user_name, emp.full_name
1852: INTO l_user_name, l_emp_name
1853: FROM fnd_user fnd, per_people_x emp
1854: WHERE fnd.user_id = p_abort_user_id
1855: AND fnd.employee_id = emp.person_id (+);
1856:
1857: IF (l_emp_name IS NOT NULL) THEN

Line 2149: FROM per_people_x

2145: BEGIN
2146: IF (p_emp_last_name IS NULL) THEN
2147:
2148: SELECT person_id INTO p_employee_id_out
2149: FROM per_people_x
2150: WHERE first_name = p_emp_first_name
2151: AND employee_number IS NOT NULL;
2152:
2153: ELSIF (p_emp_first_name IS NULL) THEN

Line 2156: FROM per_people_x

2152:
2153: ELSIF (p_emp_first_name IS NULL) THEN
2154:
2155: SELECT person_id INTO p_employee_id_out
2156: FROM per_people_x
2157: WHERE last_name = p_emp_last_name
2158: AND employee_number IS NOT NULL;
2159:
2160: ELSE

Line 2163: FROM per_people_x

2159:
2160: ELSE
2161:
2162: SELECT person_id INTO p_employee_id_out
2163: FROM per_people_x
2164: WHERE last_name = p_emp_last_name
2165: AND first_name = p_emp_first_name
2166: AND employee_number IS NOT NULL;
2167:

Line 2183: FROM per_people_x

2179:
2180: BEGIN
2181:
2182: SELECT 'x' INTO l_dummy
2183: FROM per_people_x
2184: WHERE person_id = p_employee_id;
2185:
2186: p_employee_id_out := p_employee_id;
2187: