APPS.HR_USER_ACCT_INTERNAL dependencies on OTA_BOOKING_STATUS_TYPES

Line 1271: -- OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS OTA_BOOKING_STATUS_TYPES

1267: -- Non-HR profile options are not used for validation.
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

Line 1323: -- OTA_ILEARNING_DEFAULT_ATTENDED OTA_BOOKING_STATUS_TYPES,

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
1327: -- HR_AUTHORIA_ENABLED FND_LOOKUPS

Line 1397: FROM ota_booking_status_types bst

1393: CURSOR lc_get_bkg_status IS
1394: SELECT bst.name booking_status
1395: ,bst.booking_status_type_id
1396: ,org.name org_name
1397: FROM ota_booking_status_types bst
1398: ,hr_organization_units org
1399: WHERE bst.business_group_id = org.organization_id
1400: AND bst.type in ('A', 'P')
1401: ORDER BY org.name;

Line 1452: from ota_booking_status_types bst,

1448: -- OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS
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:

Line 1568: from ota_booking_status_types bst,

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