APPS.FF_DATA_DICT dependencies on HR_S_GLOBALS_F

Line 4341: from hr_s_globals_f

4337: select max(effective_end_date) c_end
4338: , global_id c_surrogate_key
4339: , global_name c_true_key
4340: , legislation_code
4341: from hr_s_globals_f
4342: group by global_id
4343: , global_name
4344: , legislation_code;
4345:

Line 4354: from hr_s_globals_f

4350: -- This cursor accepts the primary key as a parameter and selects all
4351: -- date effective rows for it.
4352:
4353: select *
4354: from hr_s_globals_f
4355: where global_id = pc_global_id;
4356:
4357: -- These records are defined here so all sub procedures may use the
4358: -- values selected. This saves the need for all sub procedures to have

Line 4392: delete from hr_s_globals_f

4388:
4389: BEGIN
4390:
4391:
4392: delete from hr_s_globals_f
4393: where global_id = v_id;
4394:
4395: END remove;
4396:

Line 4433: from hr_s_globals_f b

4429: into l_null_return
4430: from ff_globals_f a
4431: where exists
4432: (select null
4433: from hr_s_globals_f b
4434: where a.global_id = b.global_id
4435: );
4436:
4437: --conflict may exist

Line 4440: update /*+NO_INDEX*/ hr_s_globals_f

4436:
4437: --conflict may exist
4438: --update all global_id's to remove conflict
4439:
4440: update /*+NO_INDEX*/ hr_s_globals_f
4441: set global_id = global_id - 50000000;
4442:
4443: update hr_s_application_ownerships
4444: set key_value = key_value - 50000000

Line 4456: from hr_s_globals_f;

4452: select min(global_id) - (count(*) *3)
4453: , max(global_id) + (count(*) *3)
4454: into v_min_delivered
4455: , v_max_delivered
4456: from hr_s_globals_f;
4457:
4458: select ff_globals_s.nextval
4459: into v_sequence_number
4460: from dual;

Line 4515: update hr_s_globals_f

4511: hr_legislation.hrrunprc_trace_off;
4512: raise;
4513: END;
4514:
4515: update hr_s_globals_f
4516: set global_id = l_new_global_id
4517: where global_id = r_distinct.c_surrogate_key;
4518:
4519: update hr_s_application_ownerships

Line 4740: delete from hr_s_globals_f

4736: -- Get new surrogate id and update child references
4737:
4738: update_uid;
4739:
4740: delete from hr_s_globals_f
4741: where global_id = l_new_global_id
4742: and not exists
4743: ((select
4744: EFFECTIVE_START_DATE,

Line 4752: from hr_s_globals_f

4748: DATA_TYPE,
4749: GLOBAL_NAME,
4750: GLOBAL_DESCRIPTION,
4751: GLOBAL_VALUE
4752: from hr_s_globals_f
4753: where global_id = l_new_global_id
4754: MINUS
4755: select
4756: EFFECTIVE_START_DATE,

Line 4789: from hr_s_globals_f

4785: DATA_TYPE,
4786: GLOBAL_NAME,
4787: GLOBAL_DESCRIPTION,
4788: GLOBAL_VALUE
4789: from hr_s_globals_f
4790: where global_id = l_new_global_id
4791: ))
4792: and exists (select distinct null
4793: from ff_user_entities u,