APPS.HR_LEGISLATION dependencies on HR_S_USER_ROWS_F

Line 4368: -- and hr_s_user_rows_f.

4364: l_last_urow_id number(15);
4365:
4366: -- This cursor returns the earliest record for each user_row_id,
4367: -- which is mandatory to examine matching between pay_user_rows_f
4368: -- and hr_s_user_rows_f.
4369:
4370: CURSOR c_distinct
4371: IS
4372: --

Line 4380: from hr_s_user_rows_f r1

4376: , r1.row_high_range
4377: , r1.legislation_code
4378: , r1.legislation_subgroup
4379: , r1.user_table_id
4380: from hr_s_user_rows_f r1
4381: where not exists(
4382: select null
4383: from hr_s_user_rows_f r2
4384: where r2.user_row_id = r1.user_row_id

Line 4383: from hr_s_user_rows_f r2

4379: , r1.user_table_id
4380: from hr_s_user_rows_f r1
4381: where not exists(
4382: select null
4383: from hr_s_user_rows_f r2
4384: where r2.user_row_id = r1.user_row_id
4385: and r2.effective_start_date < r1.effective_start_date);
4386:
4387: CURSOR c_each_row (pc_user_row_id varchar2)

Line 4394: from hr_s_user_rows_f

4390: -- This cursor accepts the primary key as a parameter and selects all
4391: -- date effective rows for it.
4392:
4393: select *
4394: from hr_s_user_rows_f
4395: where user_row_id = pc_user_row_id;
4396:
4397: CURSOR c_col_inst (p_user_row_id number)
4398: IS

Line 4444: from hr_s_user_rows_f;

4440:
4441:
4442: select count(*)
4443: into cnt
4444: from hr_s_user_rows_f;
4445:
4446: If cnt=0 then return; end if;
4447:
4448:

Line 4454: from hr_s_user_rows_f b

4450: into l_null_return
4451: from pay_user_rows_f a
4452: where exists
4453: (select null
4454: from hr_s_user_rows_f b
4455: where a.user_row_id = b.user_row_id
4456: );
4457:
4458: --conflict may exist

Line 4461: update /*+NO_INDEX*/ hr_s_user_rows_f

4457:
4458: --conflict may exist
4459: --update all user_row_id's to remove conflict
4460:
4461: update /*+NO_INDEX*/ hr_s_user_rows_f
4462: set user_row_id = user_row_id - 50000000;
4463:
4464: update /*+NO_INDEX*/ hr_s_user_column_instances_f
4465: set user_row_id = user_row_id - 50000000;

Line 4481: from hr_s_user_rows_f;

4477: select min(user_row_id) - (count(*) *3)
4478: , max(user_row_id) + (count(*) *3)
4479: into v_min_delivered
4480: , v_max_delivered
4481: from hr_s_user_rows_f;
4482:
4483: select max(user_row_id)
4484: into v_max_live
4485: from pay_user_rows_f;

Line 4539: delete from hr_s_user_rows_f

4535: -- application ownership rows
4536:
4537: BEGIN
4538:
4539: delete from hr_s_user_rows_f
4540: where user_row_id = v_id;
4541:
4542: delete from hr_s_user_column_instances_f
4543: where user_row_id = v_id;

Line 4592: update hr_s_user_rows_f

4588: --
4589: END;
4590:
4591:
4592: update hr_s_user_rows_f
4593: set user_row_id = l_new_user_row_id
4594: where user_row_id = r_distinct.c_surrogate_key;
4595:
4596: