APPS.HR_LEGISLATION dependencies on HR_S_USER_COLUMN_INSTANCES_F

Line 4652: from hr_s_user_column_instances_f

4648: IS
4649: -- select all child user column instances for the current user row
4650:
4651: select *
4652: from hr_s_user_column_instances_f
4653: where user_row_id = p_user_row_id;
4654:
4655: r_distinct c_distinct%ROWTYPE;
4656: r_each_row c_each_row%ROWTYPE;

Line 4714: update /*+NO_INDEX*/ hr_s_user_column_instances_f

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;
4716:
4717: update hr_s_application_ownerships
4718: set key_value = key_value - 50000000

Line 4792: delete from hr_s_user_column_instances_f

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;
4794:
4795: END remove;
4796:

Line 4853: update hr_s_user_column_instances_f

4849: where key_value = to_char(r_distinct.c_surrogate_key)
4850: and key_name = 'USER_ROW_ID';
4851:
4852:
4853: update hr_s_user_column_instances_f
4854: set user_row_id = l_new_user_row_id
4855: where user_row_id = r_distinct.c_surrogate_key;
4856:
4857: END update_uid;