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 FND_LOOKUPS

Line 1191: -- HR:EXECUTE_LEG_FORMULA fnd_lookups where lookup_type ='YES_NO'

1187: --
1188: -- DATETRACK:SESSION_DATE_WARNING FND_COMMON_LOOKUPS where lookup_type =
1189: -- 'DATETRACK:SESSION_DATE_WARNING'
1190: --
1191: -- HR:EXECUTE_LEG_FORMULA fnd_lookups where lookup_type ='YES_NO'
1192: --
1193: -- HR_DISPLAY_PERSON_SEARCH fnd_lookups where lookup_type ='YES_NO'
1194: --
1195: -- HR_DISPLAY_SKILLS FND_COMMON_LOOKUPS where lookup_type =

Line 1193: -- HR_DISPLAY_PERSON_SEARCH fnd_lookups where lookup_type ='YES_NO'

1189: -- 'DATETRACK:SESSION_DATE_WARNING'
1190: --
1191: -- HR:EXECUTE_LEG_FORMULA fnd_lookups where lookup_type ='YES_NO'
1192: --
1193: -- HR_DISPLAY_PERSON_SEARCH fnd_lookups where lookup_type ='YES_NO'
1194: --
1195: -- HR_DISPLAY_SKILLS FND_COMMON_LOOKUPS where lookup_type =
1196: -- 'YES_NO'
1197: --

Line 1213: -- OTA_PA_INTEGRATION fnd_lookups where lookup_type ='YES_NO'

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 =
1216: -- 'YES_NO'
1217: --

Line 1218: -- PER_ATTACHMENT_USAGE fnd_lookups where lookup_type ='YES_NO'

1214: --
1215: -- PER_ABSENCE_DURATION_AUTO_OVERWRITE FND_COMMON_LOOKUPS where lookup_type =
1216: -- 'YES_NO'
1217: --
1218: -- PER_ATTACHMENT_USAGE fnd_lookups where lookup_type ='YES_NO'
1219: --
1220: -- PER_BUSINESS_GROUP_ID per_business_groups
1221: --
1222: -- PER_DEFAULT_CORRESPONDENCE_LANGUAGE fnd_languages

Line 1230: -- PER_OAB_NEW_BENEFITS_MODEL fnd_lookups where lookup_type ='YES_NO'

1226: --
1227: -- PER_NI_UNIQUE_ERROR_WARNING fnd_common_lookups where lookup_type =
1228: -- NI_UNIQUE_ERROR_WARNING'
1229: --
1230: -- PER_OAB_NEW_BENEFITS_MODEL fnd_lookups where lookup_type ='YES_NO'
1231: --
1232: -- PER_QUERY_ONLY_MODE fnd_lookups where lookup_type ='YES_NO'
1233: --
1234: -- PER_SECURITY_PROFILE_ID PER_SECURITY_PROFILES and

Line 1232: -- PER_QUERY_ONLY_MODE fnd_lookups where lookup_type ='YES_NO'

1228: -- NI_UNIQUE_ERROR_WARNING'
1229: --
1230: -- PER_OAB_NEW_BENEFITS_MODEL fnd_lookups where lookup_type ='YES_NO'
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: --

Line 1255: -- HR:EXECUTE_LEG_FORMULA fnd_lookups where lookup_type ='YES_NO'

1251: -- PAY_USER_FF_PTO
1252: --
1253: -- *** The following options are not found in Seed11.5 db as of May 2000 ***
1254: -- HR_PAYROLL_CURRENCY_RATES pay_payrolls_f and per_business_groups
1255: -- HR:EXECUTE_LEG_FORMULA fnd_lookups where lookup_type ='YES_NO'
1256: -- HR:COST_MAND_SEG_CHECK fnd_lookups where lookup_type ='YES_NO'
1257: -- HR_BG_LOCATIONS FND_COMMON_LOOKUPS where lookup_type =
1258: -- 'YES_NO'
1259: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V

Line 1256: -- HR:COST_MAND_SEG_CHECK fnd_lookups where lookup_type ='YES_NO'

1252: --
1253: -- *** The following options are not found in Seed11.5 db as of May 2000 ***
1254: -- HR_PAYROLL_CURRENCY_RATES pay_payrolls_f and per_business_groups
1255: -- HR:EXECUTE_LEG_FORMULA fnd_lookups where lookup_type ='YES_NO'
1256: -- HR:COST_MAND_SEG_CHECK fnd_lookups where lookup_type ='YES_NO'
1257: -- HR_BG_LOCATIONS FND_COMMON_LOOKUPS where lookup_type =
1258: -- 'YES_NO'
1259: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V
1260: --

Line 1276: -- HR_TAX_LOCATION_CHANGE FND_LOOKUPS

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
1280: -- BEN_USER_TO_ORG_LINK HR_ALL_ORGANIZATION_UNITS,

Line 1277: -- OTA_SSHR_AUTO_GL_TRANSFER FND_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
1280: -- BEN_USER_TO_ORG_LINK HR_ALL_ORGANIZATION_UNITS,
1281: -- HR_ALL_ORGANIZATION_UNITS_TL

Line 1283: -- HR_DISPLAY_ALL_OFFERS FND_LOOKUPS

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
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS

Line 1284: -- HR_MONITOR_BALANCE_RETRIEVAL FND_LOOKUPS

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
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS

Line 1285: -- HR_CANCEL_APPLICATION FND_LOOKUPS

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
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS
1289: -- HR_OVERRIDE_GRADE_DEFAULTS FND_LOOKUPS

Line 1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS

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
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS
1289: -- HR_OVERRIDE_GRADE_DEFAULTS FND_LOOKUPS
1290: -- NL_DISPLAY_MESSAGE FND_LOOKUPS

Line 1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS

1283: -- HR_DISPLAY_ALL_OFFERS FND_LOOKUPS
1284: -- HR_MONITOR_BALANCE_RETRIEVAL FND_LOOKUPS
1285: -- HR_CANCEL_APPLICATION FND_LOOKUPS
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS
1289: -- HR_OVERRIDE_GRADE_DEFAULTS FND_LOOKUPS
1290: -- NL_DISPLAY_MESSAGE FND_LOOKUPS
1291: -- PAY_PPM_MULTI_ASSIGNMENT_ENABLE FND_LOOKUPS

Line 1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS

1284: -- HR_MONITOR_BALANCE_RETRIEVAL FND_LOOKUPS
1285: -- HR_CANCEL_APPLICATION FND_LOOKUPS
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS
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

Line 1289: -- HR_OVERRIDE_GRADE_DEFAULTS FND_LOOKUPS

1285: -- HR_CANCEL_APPLICATION FND_LOOKUPS
1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS
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,

Line 1290: -- NL_DISPLAY_MESSAGE FND_LOOKUPS

1286: -- HR_BLANK_EFFECTIVE_DATE FND_LOOKUPS
1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS
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,

Line 1291: -- PAY_PPM_MULTI_ASSIGNMENT_ENABLE FND_LOOKUPS

1287: -- HR_SSHR_LOCALIZATION FND_LOOKUPS
1288: -- HR_USE_GRADE_DEFAULTS FND_LOOKUPS
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,

Line 1297: -- HR_USE_HIRE_MGR_APPR_CHAIN FND_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
1301: -- HR_NL_JOB_LEVEL_PROFILE FND_LOOKUP_VALUES

Line 1305: -- HR_PERINFO_CHECK_PENDING FND_LOOKUPS

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
1305: -- HR_PERINFO_CHECK_PENDING FND_LOOKUPS
1306: -- HR_SELF_SERV_SAVEFORLATER FND_COMMON_LOOKUPS
1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS
1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS
1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL

Line 1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS

1303: -- HR_BIS_REPORTING_HIERARCHY PER_ORGANIZATION_STRUCTURES_V,
1304: -- PER_BUSINESS_GROUPS
1305: -- HR_PERINFO_CHECK_PENDING FND_LOOKUPS
1306: -- HR_SELF_SERV_SAVEFORLATER FND_COMMON_LOOKUPS
1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS
1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS
1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL
1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS

Line 1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS

1304: -- PER_BUSINESS_GROUPS
1305: -- HR_PERINFO_CHECK_PENDING FND_LOOKUPS
1306: -- HR_SELF_SERV_SAVEFORLATER FND_COMMON_LOOKUPS
1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS
1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS
1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL
1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS
1312: -- PER_CHECK_ENTITLEMENT_CACHE FND_LOOKUPS

Line 1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS

1307: -- PAY_FR_CHECK_MANDATORY_ASG_ATTRIBUTES FND_LOOKUPS
1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS
1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL
1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS
1312: -- PER_CHECK_ENTITLEMENT_CACHE FND_LOOKUPS
1313: -- PER_AUTO_APPLY_ENTITLEMENTS FND_LOOKUPS
1314: -- PER_CAGR_LOG_DETAIL FND_COMMON_LOOKUPS
1315: -- HR_NL_ETHNICITY_PROFILE FND_LOOKUP_VALUES

Line 1312: -- PER_CHECK_ENTITLEMENT_CACHE FND_LOOKUPS

1308: -- HR:COST_MAND_SEG_CHECK FND_LOOKUPS
1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL
1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS
1312: -- PER_CHECK_ENTITLEMENT_CACHE FND_LOOKUPS
1313: -- PER_AUTO_APPLY_ENTITLEMENTS FND_LOOKUPS
1314: -- PER_CAGR_LOG_DETAIL FND_COMMON_LOOKUPS
1315: -- HR_NL_ETHNICITY_PROFILE FND_LOOKUP_VALUES
1316: -- BEN_CWB_PREFERRED_CURRENCY FND_CURRENCIES_VL

Line 1313: -- PER_AUTO_APPLY_ENTITLEMENTS FND_LOOKUPS

1309: -- HR_MANAGER_ACTIONS_MENU FND_MENUS_VL
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL
1311: -- PER_AUTO_EVAL_ENTITLEMENTS FND_LOOKUPS
1312: -- PER_CHECK_ENTITLEMENT_CACHE FND_LOOKUPS
1313: -- PER_AUTO_APPLY_ENTITLEMENTS FND_LOOKUPS
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,

Line 1319: -- BEN_DSG_NO_CHG FND_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
1323: -- OTA_ILEARNING_DEFAULT_ATTENDED OTA_BOOKING_STATUS_TYPES,

Line 1320: -- HR_RESTRICT_X_BUSINESS_TRAN FND_LOOKUPS

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
1323: -- OTA_ILEARNING_DEFAULT_ATTENDED OTA_BOOKING_STATUS_TYPES,
1324: -- HR_ALL_ORGANIZATION_UNITS

Line 1321: -- HR_ALLOW_MULTIPLE_ASSIGNMENTS FND_LOOKUPS

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
1323: -- OTA_ILEARNING_DEFAULT_ATTENDED OTA_BOOKING_STATUS_TYPES,
1324: -- HR_ALL_ORGANIZATION_UNITS
1325: -- HR_APPRAISAL_TEMPLATE_LOV FND_LOOKUPS

Line 1325: -- HR_APPRAISAL_TEMPLATE_LOV 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
1329: -- IMC_VIS_SOL_TYPE FND_LOOKUP_VALUES_VL

Line 1326: -- OTA_OM_RESTRICT_ENR_BY_COUNTRY 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
1329: -- IMC_VIS_SOL_TYPE FND_LOOKUP_VALUES_VL
1330: -- IRC_DEFAULT_COUNTRY FND_TERRITORIES_VL

Line 1327: -- HR_AUTHORIA_ENABLED FND_LOOKUPS

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
1329: -- IMC_VIS_SOL_TYPE FND_LOOKUP_VALUES_VL
1330: -- IRC_DEFAULT_COUNTRY FND_TERRITORIES_VL
1331: -- Update for Fix 2288014 End.

Line 1359: -- FND_LOOKUPS

1355: ,meaning
1356: FROM fnd_common_lookups
1357: WHERE lookup_type = p_lookup_type;
1358:
1359: -- FND_LOOKUPS
1360: -- NOTE: Since the lookup_type is a unique key and is mandatory, we don't
1361: -- need to compare the application id. This will make the cursor more
1362: -- generic.
1363: --

Line 1367: FROM fnd_lookups

1363: --
1364: CURSOR lc_get_fnd_lkups (p_lookup_type in varchar2) IS
1365: SELECT lookup_code
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

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 1603: -- For those sql validations against FND_COMMON_LOOKUPS, or FND_LOOKUPS

1599:
1600: BEGIN
1601: hr_utility.set_location('Entering:' || l_proc, 10);
1602:
1603: -- For those sql validations against FND_COMMON_LOOKUPS, or FND_LOOKUPS
1604: -- the validation is always against the lookup_code. So, we don't need to
1605: -- hard code the validation. But we need to first find out if the validation
1606: -- uses lookup table or not.
1607: --

Line 1614: OR instr(l_sql_validation, 'FND_LOOKUPS') > 0

1610: l_num_data := null;
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

Line 1650: ELSIF instr(l_sql_validation, 'FND_LOOKUPS') > 0

1646: l_opt_value_valid := true;
1647: END IF;
1648: END LOOP;
1649: --
1650: ELSIF instr(l_sql_validation, 'FND_LOOKUPS') > 0
1651: THEN
1652: FOR get_lkup_code IN lc_get_fnd_lkups(p_lookup_type =>l_lookup_type)
1653: LOOP
1654: IF get_lkup_code.lookup_code = p_profile_opt_value