[Home] [Help]
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
1305: -- HR_PERINFO_CHECK_PENDING FND_LOOKUPS
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
1319: -- BEN_DSG_NO_CHG FND_LOOKUPS
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
1326: -- OTA_OM_RESTRICT_ENR_BY_COUNTRY FND_LOOKUPS
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
1333: -- ----------------------------------------------------------------------------
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
1383: -- need to compare the application id. This will make the cursor more
1384: -- generic.
1385: --
1385: --
1386: CURSOR lc_get_fnd_lkup_val (p_lookup_type in varchar2) IS
1387: SELECT lookup_code
1388: ,meaning
1389: FROM fnd_lookup_values
1390: WHERE lookup_type = p_lookup_type;
1391:
1392: -- OTA_AUTO_WAITLIST_BOOKING_STATUS
1393: CURSOR lc_get_bkg_status IS
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:
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
1620: -- E.g. "where l.lookup_type = 'HR_USER_TYPE' and ...."
1656: l_opt_value_valid := true;
1657: END IF;
1658: END LOOP;
1659: --
1660: ELSIF instr(l_sql_validation, 'FND_LOOKUP_VALUES') > 0
1661: THEN
1662: FOR get_lkup_code IN lc_get_fnd_lkup_val (p_lookup_type =>l_lookup_type)
1663: LOOP
1664: IF get_lkup_code.lookup_code = p_profile_opt_value