APPS.HR_LEGISLATION dependencies on PAY_USER_ROWS_F

Line 148: -- 115.14 A.Alogue 12-May-1999 Fix to handling of pay_user_rows_f

144: -- 110.10 S.Sivasub 15-Mar-1999 Created additional procedures to seed
145: -- seven MLS's TL tables.
146: -- 110.11 S.Sivasub 12-Apr-1999 Modified procedures to seed seven MLS's
147: -- TL tables with a double check on the not exist.
148: -- 115.14 A.Alogue 12-May-1999 Fix to handling of pay_user_rows_f
149: -- to cope with null legislation_codes
150: -- in the seeding of core data.
151: -- 115.15 I.Harding 21-May-99 removed dbms_output.put_line
152: -- 115.16 IHARDING 26-may-99 replaced dbms_output.put_line by null

Line 4617: -- which is mandatory to examine matching between pay_user_rows_f

4613: l_null_return varchar2(1);
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

Line 4701: from pay_user_rows_f a

4697:
4698:
4699: select distinct null
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

Line 4735: from pay_user_rows_f;

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;
4736:
4737: select pay_user_rows_s.nextval
4738: into v_sequence_number
4739: from dual;

Line 4773: insert_hr_stu_exceptions('pay_user_rows_f'

4769: -- not be raised more than once.
4770:
4771: rollback to new_row_low_range_or_name;
4772:
4773: insert_hr_stu_exceptions('pay_user_rows_f'
4774: , r_distinct.c_surrogate_key
4775: , exception_type
4776: , r_distinct.c_true_key);
4777:

Line 4816: from pay_user_rows_f

4812: BEGIN
4813: --
4814: select distinct user_row_id
4815: into l_new_user_row_id
4816: from pay_user_rows_f
4817: where user_table_id = r_distinct.user_table_id
4818: and row_low_range_or_name = r_distinct.c_true_key
4819: and nvl(row_high_range, 'NULL') =
4820: nvl(r_distinct.row_high_range, 'NULL')

Line 4960: from pay_user_rows_f a

4956: -- matching rows with null row_high_ranges are not detected.
4957: --
4958: select distinct null
4959: into l_null_return
4960: from pay_user_rows_f a
4961: where a.user_table_id = r_distinct.user_table_id
4962: and a.effective_start_date = r_distinct.effective_start_date
4963: and a.row_low_range_or_name = r_distinct.c_true_key
4964: and nvl(row_high_range, 'NULL') =

Line 4999: from pay_user_rows_f

4995: -- matching rows with null row_high_ranges are not detected.
4996: --
4997: select distinct null
4998: into l_null_return
4999: from pay_user_rows_f
5000: where row_low_range_or_name = r_distinct.c_true_key
5001: and effective_start_date = r_distinct.effective_start_date
5002: and nvl(row_high_range, 'NULL') =
5003: nvl(r_distinct.row_high_range, 'NULL')

Line 5149: delete from pay_user_rows_f

5145: delete from pay_user_column_instances_f
5146: where user_row_id = r_distinct.c_surrogate_key
5147: and business_group_id is null;
5148:
5149: delete from pay_user_rows_f
5150: where user_row_id = r_distinct.c_surrogate_key;
5151:
5152: FOR each_row IN c_each_row(r_distinct.c_surrogate_key) LOOP
5153: r_each_row := each_row;

Line 5158: insert into pay_user_rows_f

5154:
5155: IF NOT check_parents THEN RAISE row_in_error; END IF;
5156:
5157: BEGIN
5158: insert into pay_user_rows_f
5159: (user_row_id
5160: ,effective_start_date
5161: ,effective_end_date
5162: ,business_group_id