APPS.HR_LEGISLATION dependencies on HR_S_USER_ROWS_F

Line 4618: -- and hr_s_user_rows_f.

4614: l_last_urow_id number(15);
4615:
4616: -- This cursor returns the earliest record for each user_row_id,
4617: -- which is mandatory to examine matching between pay_user_rows_f
4618: -- and hr_s_user_rows_f.
4619:
4620: CURSOR c_distinct
4621: IS
4622: --

Line 4630: from hr_s_user_rows_f r1

4626: , r1.row_high_range
4627: , r1.legislation_code
4628: , r1.legislation_subgroup
4629: , r1.user_table_id
4630: from hr_s_user_rows_f r1
4631: where not exists(
4632: select null
4633: from hr_s_user_rows_f r2
4634: where r2.user_row_id = r1.user_row_id

Line 4633: from hr_s_user_rows_f r2

4629: , r1.user_table_id
4630: from hr_s_user_rows_f r1
4631: where not exists(
4632: select null
4633: from hr_s_user_rows_f r2
4634: where r2.user_row_id = r1.user_row_id
4635: and r2.effective_start_date < r1.effective_start_date);
4636:
4637: CURSOR c_each_row (pc_user_row_id varchar2)

Line 4644: from hr_s_user_rows_f

4640: -- This cursor accepts the primary key as a parameter and selects all
4641: -- date effective rows for it.
4642:
4643: select *
4644: from hr_s_user_rows_f
4645: where user_row_id = pc_user_row_id;
4646:
4647: CURSOR c_col_inst (p_user_row_id number)
4648: IS

Line 4694: from hr_s_user_rows_f;

4690:
4691:
4692: select count(*)
4693: into cnt
4694: from hr_s_user_rows_f;
4695:
4696: If cnt=0 then return; end if;
4697:
4698:

Line 4704: from hr_s_user_rows_f b

4700: into l_null_return
4701: from pay_user_rows_f a
4702: where exists
4703: (select null
4704: from hr_s_user_rows_f b
4705: where a.user_row_id = b.user_row_id
4706: );
4707:
4708: --conflict may exist

Line 4711: update /*+NO_INDEX*/ hr_s_user_rows_f

4707:
4708: --conflict may exist
4709: --update all user_row_id's to remove conflict
4710:
4711: update /*+NO_INDEX*/ hr_s_user_rows_f
4712: set user_row_id = user_row_id - 50000000;
4713:
4714: update /*+NO_INDEX*/ hr_s_user_column_instances_f
4715: set user_row_id = user_row_id - 50000000;

Line 4731: from hr_s_user_rows_f;

4727: select min(user_row_id) - (count(*) *3)
4728: , max(user_row_id) + (count(*) *3)
4729: into v_min_delivered
4730: , v_max_delivered
4731: from hr_s_user_rows_f;
4732:
4733: select max(user_row_id)
4734: into v_max_live
4735: from pay_user_rows_f;

Line 4789: delete from hr_s_user_rows_f

4785: -- application ownership rows
4786:
4787: BEGIN
4788:
4789: delete from hr_s_user_rows_f
4790: where user_row_id = v_id;
4791:
4792: delete from hr_s_user_column_instances_f
4793: where user_row_id = v_id;

Line 4842: update hr_s_user_rows_f

4838: --
4839: END;
4840:
4841:
4842: update hr_s_user_rows_f
4843: set user_row_id = l_new_user_row_id
4844: where user_row_id = r_distinct.c_surrogate_key;
4845:
4846: