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_COMMON_LOOKUPS

Line 1185: -- DATETRACK:DATE_SECURITY FND_COMMON_LOOKUPS where lookup_type =

1181: -- which use SQL validation at the time of coding (May 2000) in R11.5 and the
1182: -- options are updateable at either Responsibility or User level.
1183: -- Profile Option Name Validation Table
1184: -- --------------------------------- ----------------------------------------
1185: -- DATETRACK:DATE_SECURITY FND_COMMON_LOOKUPS where lookup_type =
1186: -- 'DATETRACK:DATE_SECURITY'
1187: --
1188: -- DATETRACK:SESSION_DATE_WARNING FND_COMMON_LOOKUPS where lookup_type =
1189: -- 'DATETRACK:SESSION_DATE_WARNING'

Line 1188: -- DATETRACK:SESSION_DATE_WARNING FND_COMMON_LOOKUPS where lookup_type =

1184: -- --------------------------------- ----------------------------------------
1185: -- DATETRACK:DATE_SECURITY FND_COMMON_LOOKUPS where lookup_type =
1186: -- 'DATETRACK:DATE_SECURITY'
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: --

Line 1195: -- HR_DISPLAY_SKILLS FND_COMMON_LOOKUPS where lookup_type =

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: --
1198: -- HR_ELE_ENTRY_PURGE_CONTROL hr_lookups where lookup_type =
1199: -- 'HR_ELE_ENTRY_PURGE_CONTROL'

Line 1204: -- HR_TIPS_TEST_MODE FND_COMMON_LOOKUPS where lookup_type =

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'
1206: --
1207: -- HR_USER_TYPE FND_COMMON_LOOKUPS where lookup_type =
1208: -- 'HR_USER_TYPE'

Line 1207: -- HR_USER_TYPE FND_COMMON_LOOKUPS where lookup_type =

1203: --
1204: -- HR_TIPS_TEST_MODE FND_COMMON_LOOKUPS where lookup_type =
1205: -- 'YES_NO'
1206: --
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

Line 1215: -- PER_ABSENCE_DURATION_AUTO_OVERWRITE FND_COMMON_LOOKUPS where lookup_type =

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: --
1218: -- PER_ATTACHMENT_USAGE fnd_lookups where lookup_type ='YES_NO'
1219: --

Line 1224: -- PER_DEFAULT_NATIONALITY FND_COMMON_LOOKUPS where lookup_type =

1220: -- PER_BUSINESS_GROUP_ID per_business_groups
1221: --
1222: -- PER_DEFAULT_CORRESPONDENCE_LANGUAGE fnd_languages
1223: --
1224: -- PER_DEFAULT_NATIONALITY FND_COMMON_LOOKUPS where lookup_type =
1225: -- 'NATIONALITY'
1226: --
1227: -- PER_NI_UNIQUE_ERROR_WARNING fnd_common_lookups where lookup_type =
1228: -- NI_UNIQUE_ERROR_WARNING'

Line 1227: -- PER_NI_UNIQUE_ERROR_WARNING fnd_common_lookups where lookup_type =

1223: --
1224: -- PER_DEFAULT_NATIONALITY FND_COMMON_LOOKUPS where lookup_type =
1225: -- 'NATIONALITY'
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: --

Line 1237: -- VIEW_UNPUBLISHED_360_SELF_APPR FND_COMMON_LOOKUPS where lookup_type =

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: --
1240: -- *** The following options are not updateable in Responsibility or User
1241: -- level in Seed11.5 db as of May 2000 ***

Line 1257: -- HR_BG_LOCATIONS FND_COMMON_LOOKUPS where lookup_type =

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: --
1261: -- --------------------------------------------------------------------------

Line 1292: -- HR_ACTIONS_VALIDATION FND_COMMON_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,
1296: -- PER_ALL_ASSIGNMENTS_F

Line 1306: -- HR_SELF_SERV_SAVEFORLATER FND_COMMON_LOOKUPS

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
1310: -- HR_PERSONAL_ACTIONS_MENU FND_MENUS_VL

Line 1314: -- PER_CAGR_LOG_DETAIL FND_COMMON_LOOKUPS

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,
1318: -- HR_ALL_ORGANIZATION_UNITS

Line 1348: -- FND_COMMON_LOOKUPS

1344: ,p_varchar2_data out nocopy varchar2
1345: ) IS
1346: --
1347: --
1348: -- FND_COMMON_LOOKUPS
1349: -- NOTE: Since the lookup_type is a unique key and is mandatory, we don't
1350: -- need to compare the application id. This will make the cursor more
1351: -- generic.
1352: --

Line 1356: FROM fnd_common_lookups

1352: --
1353: CURSOR lc_get_fnd_cmn_lkups (p_lookup_type in varchar2) IS
1354: SELECT lookup_code
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

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 1613: IF instr(l_sql_validation, 'FND_COMMON_LOOKUPS') > 0

1609: l_sql_validation := upper(p_sql_validation);
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

Line 1640: IF instr(l_sql_validation, 'FND_COMMON_LOOKUPS') > 0

1636:
1637:
1638:
1639: -- Now we can call the cursor
1640: IF instr(l_sql_validation, 'FND_COMMON_LOOKUPS') > 0
1641: THEN
1642: FOR get_lkup_code IN lc_get_fnd_cmn_lkups(p_lookup_type =>l_lookup_type)
1643: LOOP
1644: IF get_lkup_code.lookup_code = p_profile_opt_value