APPS.FF_DATA_DICT dependencies on HR_S_DATABASE_ITEMS

Line 1931: from hr_s_database_items

1927: IS
1928: -- Cursor to install database items for a given user entity
1929:
1930: select *
1931: from hr_s_database_items
1932: where user_entity_id = ue_id;
1933:
1934: stu_rec stu%ROWTYPE;
1935:

Line 2106: update /*+NO_INDEX*/ hr_s_database_items

2102:
2103: update /*+NO_INDEX*/ hr_s_user_entities
2104: set user_entity_id = user_entity_id -50000000;
2105:
2106: update /*+NO_INDEX*/ hr_s_database_items
2107: set user_entity_id = user_entity_id -50000000;
2108:
2109: update /*+NO_INDEX*/ hr_s_route_parameter_values
2110: set user_entity_id = user_entity_id -50000000;

Line 2359: update hr_s_database_items

2355: set user_entity_id = l_new_entity_id
2356: , route_id = l_new_surrogate_key
2357: where user_entity_id = delivered_entities.user_entity_id;
2358:
2359: update hr_s_database_items
2360: set user_entity_id = l_new_entity_id
2361: where user_entity_id = delivered_entities.user_entity_id;
2362:
2363: update hr_s_route_parameter_values

Line 2382: delete from hr_s_database_items a

2378: -- Remove a row from the startup tables
2379:
2380: BEGIN
2381:
2382: delete from hr_s_database_items a
2383: where a.user_entity_id in
2384: (select b.user_entity_id
2385: from hr_s_user_entities b
2386: where b.route_id = v_route_id

Line 2647: from hr_s_database_items

2643: data_type,
2644: definition_text,
2645: null_allowed_flag,
2646: description
2647: from hr_s_database_items
2648: where user_entity_id = v_user_entity_id
2649: MINUS
2650: select user_name,
2651: data_type,