APPS.HR_LEGISLATION_ELEMENTS dependencies on HR_S_USER_TABLES

Line 3342: from hr_s_user_tables;

3338: , created_by
3339: , creation_date
3340: , rowid
3341: , user_row_title
3342: from hr_s_user_tables;
3343:
3344: stu_rec stu%ROWTYPE;
3345:
3346:

Line 3383: from hr_s_user_tables b

3379: into l_null_return
3380: from pay_user_tables a
3381: where exists
3382: (select null
3383: from hr_s_user_tables b
3384: where a.user_table_id = b.user_table_id
3385: );
3386:
3387: --conflict may exist

Line 3396: update /*+NO_INDEX*/ hr_s_user_tables

3392:
3393: update /*+NO_INDEX*/ hr_s_user_rows_f
3394: set user_table_id = user_table_id - 50000000;
3395:
3396: update /*+NO_INDEX*/ hr_s_user_tables
3397: set user_table_id = user_table_id - 50000000;
3398:
3399: update hr_s_application_ownerships
3400: set key_value = key_value - 50000000

Line 3413: from hr_s_user_tables;

3409: select min(user_table_id) - (count(*) *3)
3410: , max(user_table_id) + (count(*) *3)
3411: into v_min_delivered
3412: , v_max_delivered
3413: from hr_s_user_tables;
3414:
3415: select pay_user_tables_s.nextval
3416: into v_sequence_number
3417: from dual;

Line 3495: update hr_s_user_tables

3491:
3492: END;
3493:
3494: -- Update all child entities
3495: update hr_s_user_tables
3496: set user_table_id = l_new_surrogate_key
3497: where user_table_id = stu_rec.c_surrogate_key;
3498:
3499: update hr_s_application_ownerships

Line 3521: delete from hr_s_user_tables

3517: -- Remove a row from either the startup tables or the installed tables
3518:
3519: BEGIN
3520:
3521: delete from hr_s_user_tables
3522: where rowid = stu_rec.rowid;
3523:
3524: END remove;
3525:

Line 4165: from hr_s_user_tables

4161: -- Check the tables in the delivery account
4162:
4163: select distinct null
4164: into l_null_return
4165: from hr_s_user_tables
4166: where user_table_id = stu_rec.user_table_id;
4167:
4168: crt_exc('Parent user table remains in delivery tables');
4169: