APPS.HR_USER_ACCT_INTERNAL dependencies on OTA_ACTIVITY_DEFINITIONS

Line 1317: -- OTA_ILEARNING_DEFAULT_ACTIVITY OTA_ACTIVITY_DEFINITIONS,

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
1320: -- HR_RESTRICT_X_BUSINESS_TRAN FND_LOOKUPS
1321: -- HR_ALLOW_MULTIPLE_ASSIGNMENTS FND_LOOKUPS

Line 1557: /*+ INDEX(tad OTA_ACTIVITY_DEFINITIONS_FK1) */

1553:
1554: -- OTA_ILEARNING_DEFAULT_ACTIVITY
1555: CURSOR lc_get_ilearn_def_act IS
1556: SELECT
1557: /*+ INDEX(tad OTA_ACTIVITY_DEFINITIONS_FK1) */
1558: TAD.NAME visible_option_value ,TAD.ACTIVITY_ID profile_option_value
1559: from ota_activity_definitions tad,
1560: hr_all_organization_units org
1561: where tad.business_group_id = org.organization_id

Line 1559: from ota_activity_definitions tad,

1555: CURSOR lc_get_ilearn_def_act IS
1556: SELECT
1557: /*+ INDEX(tad OTA_ACTIVITY_DEFINITIONS_FK1) */
1558: TAD.NAME visible_option_value ,TAD.ACTIVITY_ID profile_option_value
1559: from ota_activity_definitions tad,
1560: hr_all_organization_units org
1561: where tad.business_group_id = org.organization_id
1562: order by org.name,tad.name;
1563: