eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_USER_ACCT_INTERNAL dependencies on HR_ALL_ORGANIZATION_UNITS

Line 1211: -- hr_all_organization_units

1207: -- HR_USER_TYPE FND_COMMON_LOOKUPS where lookup_type =
1208: -- 'HR_USER_TYPE'
1209: --
1210: -- OTA_AUTO_WAITLIST_BOOKING_STATUS ota_booking_status and
1211: -- hr_all_organization_units
1212: --
1213: -- OTA_PA_INTEGRATION fnd_lookups where lookup_type ='YES_NO'
1214: --
1215: -- PER_ABSENCE_DURATION_AUTO_OVERWRITE FND_COMMON_LOOKUPS where lookup_type =

Line 1235: -- HR_ALL_ORGANIZATION_UNITS

1231: --
1232: -- PER_QUERY_ONLY_MODE fnd_lookups where lookup_type ='YES_NO'
1233: --
1234: -- PER_SECURITY_PROFILE_ID PER_SECURITY_PROFILES and
1235: -- HR_ALL_ORGANIZATION_UNITS
1236: --
1237: -- VIEW_UNPUBLISHED_360_SELF_APPR FND_COMMON_LOOKUPS where lookup_type =
1238: -- 'YES_NO'
1239: --

Line 1280: -- BEN_USER_TO_ORG_LINK HR_ALL_ORGANIZATION_UNITS,

1276: -- HR_TAX_LOCATION_CHANGE FND_LOOKUPS
1277: -- OTA_SSHR_AUTO_GL_TRANSFER FND_LOOKUPS
1278: -- BEN_NEW_USER_RESP_PROFILE FND_RESPONSIBILITY_TL,
1279: -- FND_RESPONSIBILITY
1280: -- BEN_USER_TO_ORG_LINK HR_ALL_ORGANIZATION_UNITS,
1281: -- HR_ALL_ORGANIZATION_UNITS_TL
1282: -- OTA_HR_GLOBAL_BUSINESS_GROUP_ID PER_BUSINESS_GROUPS
1283: -- HR_DISPLAY_ALL_OFFERS FND_LOOKUPS
1284: -- HR_MONITOR_BALANCE_RETRIEVAL FND_LOOKUPS

Line 1281: -- HR_ALL_ORGANIZATION_UNITS_TL

1277: -- OTA_SSHR_AUTO_GL_TRANSFER FND_LOOKUPS
1278: -- BEN_NEW_USER_RESP_PROFILE FND_RESPONSIBILITY_TL,
1279: -- FND_RESPONSIBILITY
1280: -- BEN_USER_TO_ORG_LINK HR_ALL_ORGANIZATION_UNITS,
1281: -- HR_ALL_ORGANIZATION_UNITS_TL
1282: -- OTA_HR_GLOBAL_BUSINESS_GROUP_ID PER_BUSINESS_GROUPS
1283: -- HR_DISPLAY_ALL_OFFERS FND_LOOKUPS
1284: -- HR_MONITOR_BALANCE_RETRIEVAL FND_LOOKUPS
1285: -- HR_CANCEL_APPLICATION FND_LOOKUPS

Line 1294: -- HR_ALL_ORGANIZATION_UNITS,

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

Line 1295: -- HR_ALL_ORGANIZATION_UNITS,

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

Line 1298: -- OTA_DEFAULT_EVENT_CENTER HR_ALL_ORGANIZATION_UNITS,

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
1301: -- HR_NL_JOB_LEVEL_PROFILE FND_LOOKUP_VALUES
1302: -- BEN_USER_TO_PAYROLL_LINK PAY_ALL_PAYROLLS_F

Line 1300: -- 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,
1304: -- PER_BUSINESS_GROUPS

Line 1318: -- HR_ALL_ORGANIZATION_UNITS

1314: -- PER_CAGR_LOG_DETAIL FND_COMMON_LOOKUPS
1315: -- HR_NL_ETHNICITY_PROFILE FND_LOOKUP_VALUES
1316: -- BEN_CWB_PREFERRED_CURRENCY FND_CURRENCIES_VL
1317: -- OTA_ILEARNING_DEFAULT_ACTIVITY OTA_ACTIVITY_DEFINITIONS,
1318: -- HR_ALL_ORGANIZATION_UNITS
1319: -- BEN_DSG_NO_CHG FND_LOOKUPS
1320: -- HR_RESTRICT_X_BUSINESS_TRAN FND_LOOKUPS
1321: -- HR_ALLOW_MULTIPLE_ASSIGNMENTS FND_LOOKUPS
1322: -- HR_NL_FULL_NAME_PROFILE FND_LOOKUP_VALUES

Line 1324: -- HR_ALL_ORGANIZATION_UNITS

1320: -- HR_RESTRICT_X_BUSINESS_TRAN FND_LOOKUPS
1321: -- HR_ALLOW_MULTIPLE_ASSIGNMENTS FND_LOOKUPS
1322: -- HR_NL_FULL_NAME_PROFILE FND_LOOKUP_VALUES
1323: -- OTA_ILEARNING_DEFAULT_ATTENDED OTA_BOOKING_STATUS_TYPES,
1324: -- HR_ALL_ORGANIZATION_UNITS
1325: -- HR_APPRAISAL_TEMPLATE_LOV FND_LOOKUPS
1326: -- OTA_OM_RESTRICT_ENR_BY_COUNTRY FND_LOOKUPS
1327: -- HR_AUTHORIA_ENABLED FND_LOOKUPS
1328: -- HXC_TIMEKEEPER_OVERRIDE HR_LOOKUPS

Line 1427: ,hr_all_organization_units o

1423: ,s.security_profile_id
1424: ,s.business_group_id
1425: ,o.name
1426: FROM per_security_profiles s
1427: ,hr_all_organization_units o
1428: WHERE o.business_group_id = s.business_group_id
1429: AND o.organization_id = o.business_group_id
1430: ORDER BY s.security_profile_id;
1431:

Line 1453: hr_all_organization_units org

1449:
1450: CURSOR lc_get_enroll_cancel_sts IS
1451: SELECT BST.NAME visible_option_value , BST.BOOKING_STATUS_TYPE_ID profile_option_value
1452: from ota_booking_status_types bst,
1453: hr_all_organization_units org
1454: where bst.business_group_id = org.organization_id
1455: and bst.type = 'C' order by org.name, bst.name;
1456:
1457:

Line 1472: FROM HR_ALL_ORGANIZATION_UNITS HAO,

1468:
1469: -- BEN_USER_TO_ORG_LINK
1470: CURSOR lc_get_usr_org_lnk IS
1471: SELECT HAO.NAME visible_option_value,HAO.ORGANIZATION_ID profile_option_value
1472: FROM HR_ALL_ORGANIZATION_UNITS HAO,
1473: HR_ALL_ORGANIZATION_UNITS_TL HAOTL
1474: WHERE HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
1475: AND HAOTL.LANGUAGE = USERENV('LANG')
1476: AND SYSDATE BETWEEN HAO.DATE_FROM

Line 1473: HR_ALL_ORGANIZATION_UNITS_TL HAOTL

1469: -- BEN_USER_TO_ORG_LINK
1470: CURSOR lc_get_usr_org_lnk IS
1471: SELECT HAO.NAME visible_option_value,HAO.ORGANIZATION_ID profile_option_value
1472: FROM HR_ALL_ORGANIZATION_UNITS HAO,
1473: HR_ALL_ORGANIZATION_UNITS_TL HAOTL
1474: WHERE HAO.ORGANIZATION_ID = HAOTL.ORGANIZATION_ID
1475: AND HAOTL.LANGUAGE = USERENV('LANG')
1476: AND SYSDATE BETWEEN HAO.DATE_FROM
1477: AND NVL(HAO.DATE_TO,SYSDATE)

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 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'

Line 1560: hr_all_organization_units org

1556: SELECT
1557: /*+ INDEX(tad OTA_ACTIVITY_DEFINITIONS_FK1) */
1558: TAD.NAME visible_option_value ,TAD.ACTIVITY_ID profile_option_value
1559: from ota_activity_definitions tad,
1560: hr_all_organization_units org
1561: where tad.business_group_id = org.organization_id
1562: order by org.name,tad.name;
1563:
1564:

Line 1569: hr_all_organization_units org

1565: -- OTA_ILEARNING_DEFAULT_ATTENDED
1566: CURSOR lc_get_ilearn_def_atnd IS
1567: SELECT BST.NAME visible_option_value ,BST.BOOKING_STATUS_TYPE_ID profile_option_value
1568: from ota_booking_status_types bst,
1569: hr_all_organization_units org
1570: where bst.business_group_id = org.organization_id
1571: and bst.type in ('A') order by org.name,bst.name;
1572:
1573: