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_LOOKUPS

Line 1198: -- HR_ELE_ENTRY_PURGE_CONTROL hr_lookups where lookup_type =

1194: --
1195: -- HR_DISPLAY_SKILLS FND_COMMON_LOOKUPS where lookup_type =
1196: -- 'YES_NO'
1197: --
1198: -- HR_ELE_ENTRY_PURGE_CONTROL hr_lookups where lookup_type =
1199: -- 'HR_ELE_ENTRY_PURGE_CONTROL'
1200: --
1201: -- HR_OTF_UPDATE_METHOD hr_lookups where lookup_type =
1202: -- 'PAY_US_OTF_UPDATE_METHODS'

Line 1201: -- HR_OTF_UPDATE_METHOD hr_lookups where lookup_type =

1197: --
1198: -- HR_ELE_ENTRY_PURGE_CONTROL hr_lookups where lookup_type =
1199: -- 'HR_ELE_ENTRY_PURGE_CONTROL'
1200: --
1201: -- HR_OTF_UPDATE_METHOD hr_lookups where lookup_type =
1202: -- 'PAY_US_OTF_UPDATE_METHODS'
1203: --
1204: -- HR_TIPS_TEST_MODE FND_COMMON_LOOKUPS where lookup_type =
1205: -- 'YES_NO'

Line 1272: -- PER_NATIONAL_IDENTIFIER_VALIDATION HR_LOOKUPS

1268: --
1269: -- Profile Option Name Validation Table
1270: -- --------------------------------- -----------------------------
1271: -- OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS OTA_BOOKING_STATUS_TYPES
1272: -- PER_NATIONAL_IDENTIFIER_VALIDATION HR_LOOKUPS
1273: -- OM_DEFAULT_EVENT_CENTER HR_LOOKUPS
1274: -- OM_DEFAULT_EVENT_SYSTEM_STATUS HR_LOOKUPS
1275: -- OM_DEFAULT_EVENT_USER_STATUS HR_LOOKUPS
1276: -- HR_TAX_LOCATION_CHANGE FND_LOOKUPS

Line 1273: -- OM_DEFAULT_EVENT_CENTER HR_LOOKUPS

1269: -- Profile Option Name Validation Table
1270: -- --------------------------------- -----------------------------
1271: -- OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS OTA_BOOKING_STATUS_TYPES
1272: -- PER_NATIONAL_IDENTIFIER_VALIDATION HR_LOOKUPS
1273: -- OM_DEFAULT_EVENT_CENTER HR_LOOKUPS
1274: -- OM_DEFAULT_EVENT_SYSTEM_STATUS HR_LOOKUPS
1275: -- OM_DEFAULT_EVENT_USER_STATUS HR_LOOKUPS
1276: -- HR_TAX_LOCATION_CHANGE FND_LOOKUPS
1277: -- OTA_SSHR_AUTO_GL_TRANSFER FND_LOOKUPS

Line 1274: -- OM_DEFAULT_EVENT_SYSTEM_STATUS HR_LOOKUPS

1270: -- --------------------------------- -----------------------------
1271: -- OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS OTA_BOOKING_STATUS_TYPES
1272: -- PER_NATIONAL_IDENTIFIER_VALIDATION HR_LOOKUPS
1273: -- OM_DEFAULT_EVENT_CENTER HR_LOOKUPS
1274: -- OM_DEFAULT_EVENT_SYSTEM_STATUS HR_LOOKUPS
1275: -- OM_DEFAULT_EVENT_USER_STATUS HR_LOOKUPS
1276: -- HR_TAX_LOCATION_CHANGE FND_LOOKUPS
1277: -- OTA_SSHR_AUTO_GL_TRANSFER FND_LOOKUPS
1278: -- BEN_NEW_USER_RESP_PROFILE FND_RESPONSIBILITY_TL,

Line 1275: -- OM_DEFAULT_EVENT_USER_STATUS HR_LOOKUPS

1271: -- OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS OTA_BOOKING_STATUS_TYPES
1272: -- PER_NATIONAL_IDENTIFIER_VALIDATION HR_LOOKUPS
1273: -- OM_DEFAULT_EVENT_CENTER HR_LOOKUPS
1274: -- OM_DEFAULT_EVENT_SYSTEM_STATUS HR_LOOKUPS
1275: -- OM_DEFAULT_EVENT_USER_STATUS HR_LOOKUPS
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

Line 1328: -- HXC_TIMEKEEPER_OVERRIDE HR_LOOKUPS

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
1329: -- IMC_VIS_SOL_TYPE FND_LOOKUP_VALUES_VL
1330: -- IRC_DEFAULT_COUNTRY FND_TERRITORIES_VL
1331: -- Update for Fix 2288014 End.
1332: -- Bug 2825757 : Added validation for ICX_LANGUAGE

Line 1370: -- HR_LOOKUPS

1366: ,meaning
1367: FROM fnd_lookups
1368: WHERE lookup_type = p_lookup_type;
1369:
1370: -- HR_LOOKUPS
1371: -- NOTE: Since the lookup_type is a unique key and is mandatory, we don't
1372: -- need to compare the application id. This will make the cursor more
1373: -- generic.
1374: --

Line 1378: FROM hr_lookups

1374: --
1375: CURSOR lc_get_hr_lkups (p_lookup_type in varchar2) IS
1376: SELECT lookup_code
1377: ,meaning
1378: FROM hr_lookups
1379: WHERE lookup_type = p_lookup_type;
1380:
1381: -- FND_LOOKUP_VALUES
1382: -- NOTE: Since the lookup_type is a unique key and is mandatory, we don't

Line 1445: -- fnd_lookups , hr_lookups, fnd_lookup_values and fnd_common_lookups.

1441: ORDER BY pay.payroll_id;
1442:
1443: -- Fix 2288014 start
1444: -- Generic cursors are already defined for validations using
1445: -- fnd_lookups , hr_lookups, fnd_lookup_values and fnd_common_lookups.
1446: -- Define cursors for profile option validations
1447:
1448: -- OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS
1449:

Line 1615: OR instr(l_sql_validation, 'HR_LOOKUPS') > 0

1611: l_varchar2_data := null;
1612: --
1613: IF instr(l_sql_validation, 'FND_COMMON_LOOKUPS') > 0
1614: OR instr(l_sql_validation, 'FND_LOOKUPS') > 0
1615: OR instr(l_sql_validation, 'HR_LOOKUPS') > 0
1616: OR instr(l_sql_validation, 'FND_LOOKUP_VALUES') > 0
1617: THEN
1618: -- Extract the string starting from the where clause to the end of the
1619: -- statement

Line 1670: ELSIF instr(l_sql_validation, 'HR_LOOKUPS') > 0

1666: l_opt_value_valid := true;
1667: END IF;
1668: END LOOP;
1669: --
1670: ELSIF instr(l_sql_validation, 'HR_LOOKUPS') > 0
1671: THEN
1672: FOR get_lkup_code IN lc_get_hr_lkups(p_lookup_type =>l_lookup_type)
1673: LOOP
1674: IF get_lkup_code.lookup_code = p_profile_opt_value