APPS.FF_DATA_DICT dependencies on HR_S_GLOBALS_F

Line 4290: from hr_s_globals_f

4286: select max(effective_end_date) c_end
4287: , global_id c_surrogate_key
4288: , global_name c_true_key
4289: , legislation_code
4290: from hr_s_globals_f
4291: group by global_id
4292: , global_name
4293: , legislation_code;
4294:

Line 4303: from hr_s_globals_f

4299: -- This cursor accepts the primary key as a parameter and selects all
4300: -- date effective rows for it.
4301:
4302: select *
4303: from hr_s_globals_f
4304: where global_id = pc_global_id;
4305:
4306: -- These records are defined here so all sub procedures may use the
4307: -- values selected. This saves the need for all sub procedures to have

Line 4341: delete from hr_s_globals_f

4337:
4338: BEGIN
4339:
4340:
4341: delete from hr_s_globals_f
4342: where global_id = v_id;
4343:
4344: END remove;
4345:

Line 4382: from hr_s_globals_f b

4378: into l_null_return
4379: from ff_globals_f a
4380: where exists
4381: (select null
4382: from hr_s_globals_f b
4383: where a.global_id = b.global_id
4384: );
4385:
4386: --conflict may exist

Line 4389: update /*+NO_INDEX*/ hr_s_globals_f

4385:
4386: --conflict may exist
4387: --update all global_id's to remove conflict
4388:
4389: update /*+NO_INDEX*/ hr_s_globals_f
4390: set global_id = global_id - 50000000;
4391:
4392: update hr_s_application_ownerships
4393: set key_value = key_value - 50000000

Line 4405: from hr_s_globals_f;

4401: select min(global_id) - (count(*) *3)
4402: , max(global_id) + (count(*) *3)
4403: into v_min_delivered
4404: , v_max_delivered
4405: from hr_s_globals_f;
4406:
4407: select ff_globals_s.nextval
4408: into v_sequence_number
4409: from dual;

Line 4464: update hr_s_globals_f

4460: hr_legislation.hrrunprc_trace_off;
4461: raise;
4462: END;
4463:
4464: update hr_s_globals_f
4465: set global_id = l_new_global_id
4466: where global_id = r_distinct.c_surrogate_key;
4467:
4468: update hr_s_application_ownerships

Line 4689: delete from hr_s_globals_f

4685: -- Get new surrogate id and update child references
4686:
4687: update_uid;
4688:
4689: delete from hr_s_globals_f
4690: where global_id = l_new_global_id
4691: and not exists
4692: ((select
4693: EFFECTIVE_START_DATE,

Line 4701: from hr_s_globals_f

4697: DATA_TYPE,
4698: GLOBAL_NAME,
4699: GLOBAL_DESCRIPTION,
4700: GLOBAL_VALUE
4701: from hr_s_globals_f
4702: where global_id = l_new_global_id
4703: MINUS
4704: select
4705: EFFECTIVE_START_DATE,

Line 4738: from hr_s_globals_f

4734: DATA_TYPE,
4735: GLOBAL_NAME,
4736: GLOBAL_DESCRIPTION,
4737: GLOBAL_VALUE
4738: from hr_s_globals_f
4739: where global_id = l_new_global_id
4740: ))
4741: and exists (select distinct null
4742: from ff_user_entities u,