DBA Data[Home] [Help]

APPS.HR_USER_ACCT_INTERNAL dependencies on HR_ORGANIZATION_INFORMATION

Line 1299: -- HR_ORGANIZATION_INFORMATION,

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
1301: -- HR_NL_JOB_LEVEL_PROFILE FND_LOOKUP_VALUES
1302: -- BEN_USER_TO_PAYROLL_LINK PAY_ALL_PAYROLLS_F
1303: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V,

Line 1506: FROM HR_ALL_ORGANIZATION_UNITS ORG,HR_ORGANIZATION_INFORMATION ORI,HR_ALL_ORGANIZATION_UNITS BG

1502:
1503: -- OTA_DEFAULT_EVENT_CENTER
1504: CURSOR lc_get_def_evnt_cntr IS
1505: SELECT ORG.NAME visible_option_value, ORG.ORGANIZATION_ID profile_option_value
1506: FROM HR_ALL_ORGANIZATION_UNITS ORG,HR_ORGANIZATION_INFORMATION ORI,HR_ALL_ORGANIZATION_UNITS BG
1507: WHERE ORG.ORGANIZATION_ID = ORI.ORGANIZATION_ID
1508: AND ORG.BUSINESS_GROUP_ID = BG.ORGANIZATION_ID
1509: AND ORI.ORG_INFORMATION_CONTEXT = 'CLASS'
1510: AND ORI.ORG_INFORMATION1 ='OTA_TC'