APPS.HR_USER_ACCT_INTERNAL dependencies on PER_ALL_PEOPLE_F

Line 226: FROM per_all_people_f

222: IF p_employee_id IS NOT NULL
223: THEN
224: SELECT count(1)
225: INTO l_count
226: FROM per_all_people_f
227: WHERE person_id = p_employee_id;
228:
229: IF l_count <= 0
230: THEN

Line 1293: -- OTA_DEFAULT_EVENT_OWNER PER_ALL_PEOPLE_F,

1289: -- HR_OVERRIDE_GRADE_DEFAULTS FND_LOOKUPS
1290: -- NL_DISPLAY_MESSAGE FND_LOOKUPS
1291: -- PAY_PPM_MULTI_ASSIGNMENT_ENABLE FND_LOOKUPS
1292: -- HR_ACTIONS_VALIDATION FND_COMMON_LOOKUPS
1293: -- OTA_DEFAULT_EVENT_OWNER PER_ALL_PEOPLE_F,
1294: -- HR_ALL_ORGANIZATION_UNITS,
1295: -- HR_ALL_ORGANIZATION_UNITS,
1296: -- PER_ALL_ASSIGNMENTS_F
1297: -- HR_USE_HIRE_MGR_APPR_CHAIN FND_LOOKUPS

Line 1490: FROM PER_ALL_PEOPLE_F P,HR_ALL_ORGANIZATION_UNITS O,HR_ALL_ORGANIZATION_UNITS BG,

1486:
1487: -- OTA_DEFAULT_EVENT_OWNER
1488: CURSOR lc_get_def_envt_ownr IS
1489: SELECT P.FULL_NAME visible_option_value,P.PERSON_ID profile_option_value
1490: FROM PER_ALL_PEOPLE_F P,HR_ALL_ORGANIZATION_UNITS O,HR_ALL_ORGANIZATION_UNITS BG,
1491: PER_ALL_ASSIGNMENTS_F A
1492: WHERE P.PERSON_ID = A.PERSON_ID AND
1493: O.ORGANIZATION_ID = A.ORGANIZATION_ID AND
1494: O.BUSINESS_GROUP_ID = BG.ORGANIZATION_ID AND

Line 2440: FROM per_all_people_f

2436: ELSE
2437: -- Check for employee id if it exists
2438: SELECT count(1)
2439: INTO l_count
2440: FROM per_all_people_f
2441: WHERE person_id = p_employee_id;
2442:
2443: IF l_count <= 0
2444: THEN