APPS.HR_LEGISLATION dependencies on HR_S_USER_COLUMN_INSTANCES_F

Line 4402: from hr_s_user_column_instances_f

4398: IS
4399: -- select all child user column instances for the current user row
4400:
4401: select *
4402: from hr_s_user_column_instances_f
4403: where user_row_id = p_user_row_id;
4404:
4405: r_distinct c_distinct%ROWTYPE;
4406: r_each_row c_each_row%ROWTYPE;

Line 4464: update /*+NO_INDEX*/ hr_s_user_column_instances_f

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;
4466:
4467: update hr_s_application_ownerships
4468: set key_value = key_value - 50000000

Line 4542: delete from hr_s_user_column_instances_f

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;
4544:
4545: END remove;
4546:

Line 4603: update hr_s_user_column_instances_f

4599: where key_value = to_char(r_distinct.c_surrogate_key)
4600: and key_name = 'USER_ROW_ID';
4601:
4602:
4603: update hr_s_user_column_instances_f
4604: set user_row_id = l_new_user_row_id
4605: where user_row_id = r_distinct.c_surrogate_key;
4606:
4607: END update_uid;