APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_USER_TABLES

Line 3310: from hr_s_user_tables;

3306: , created_by
3307: , creation_date
3308: , rowid
3309: , user_row_title
3310: from hr_s_user_tables;
3311:
3312: stu_rec stu%ROWTYPE;
3313:
3314:

Line 3351: from hr_s_user_tables b

3347: into l_null_return
3348: from pay_user_tables a
3349: where exists
3350: (select null
3351: from hr_s_user_tables b
3352: where a.user_table_id = b.user_table_id
3353: );
3354:
3355: --conflict may exist

Line 3364: update /*+NO_INDEX*/ hr_s_user_tables

3360:
3361: update /*+NO_INDEX*/ hr_s_user_rows_f
3362: set user_table_id = user_table_id - 50000000;
3363:
3364: update /*+NO_INDEX*/ hr_s_user_tables
3365: set user_table_id = user_table_id - 50000000;
3366:
3367: update hr_s_application_ownerships
3368: set key_value = key_value - 50000000

Line 3381: from hr_s_user_tables;

3377: select min(user_table_id) - (count(*) *3)
3378: , max(user_table_id) + (count(*) *3)
3379: into v_min_delivered
3380: , v_max_delivered
3381: from hr_s_user_tables;
3382:
3383: select pay_user_tables_s.nextval
3384: into v_sequence_number
3385: from dual;

Line 3463: update hr_s_user_tables

3459:
3460: END;
3461:
3462: -- Update all child entities
3463: update hr_s_user_tables
3464: set user_table_id = l_new_surrogate_key
3465: where user_table_id = stu_rec.c_surrogate_key;
3466:
3467: update hr_s_application_ownerships

Line 3489: delete from hr_s_user_tables

3485: -- Remove a row from either the startup tables or the installed tables
3486:
3487: BEGIN
3488:
3489: delete from hr_s_user_tables
3490: where rowid = stu_rec.rowid;
3491:
3492: END remove;
3493:

Line 4133: from hr_s_user_tables

4129: -- Check the tables in the delivery account
4130:
4131: select distinct null
4132: into l_null_return
4133: from hr_s_user_tables
4134: where user_table_id = stu_rec.user_table_id;
4135:
4136: crt_exc('Parent user table remains in delivery tables');
4137: