DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on PER_ALL_ASSIGNMENTS_F

Line 1296: -- PER_ALL_ASSIGNMENTS_F

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
1298: -- OTA_DEFAULT_EVENT_CENTER HR_ALL_ORGANIZATION_UNITS,
1299: -- HR_ORGANIZATION_INFORMATION,
1300: -- HR_ALL_ORGANIZATION_UNITS

Line 1491: PER_ALL_ASSIGNMENTS_F A

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
1495: A.PRIMARY_FLAG = 'Y' AND