APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_DIMENSIONS

Line 2826: from hr_s_balance_dimensions;

2822: , database_item_function
2823: , save_run_balance_enabled
2824: , start_date_code
2825: , rowid
2826: from hr_s_balance_dimensions;
2827:
2828: stu_rec stu%ROWTYPE; -- Record for the above select
2829:
2830:

Line 2866: from hr_s_balance_dimensions;

2862:
2863:
2864: select count(*)
2865: into cnt
2866: from hr_s_balance_dimensions;
2867:
2868: If cnt=0 then return; end if;
2869:
2870:

Line 2876: from hr_s_balance_dimensions b

2872: into l_null_return
2873: from pay_balance_dimensions a
2874: where exists
2875: (select null
2876: from hr_s_balance_dimensions b
2877: where a.balance_dimension_id = b.balance_dimension_id
2878: );
2879:
2880: --conflict may exist

Line 2883: update /*+NO_INDEX*/ hr_s_balance_dimensions

2879:
2880: --conflict may exist
2881: --update all balance_dimension_id's to remove conflict
2882:
2883: update /*+NO_INDEX*/ hr_s_balance_dimensions
2884: set balance_dimension_id = balance_dimension_id - 50000000;
2885:
2886: update /*+NO_INDEX*/ hr_s_defined_balances
2887: set balance_dimension_id = balance_dimension_id - 50000000;

Line 2889: update /*+NO_INDEX*/ hr_s_balance_dimensions

2885:
2886: update /*+NO_INDEX*/ hr_s_defined_balances
2887: set balance_dimension_id = balance_dimension_id - 50000000;
2888:
2889: update /*+NO_INDEX*/ hr_s_balance_dimensions
2890: set asg_action_balance_dim_id = asg_action_balance_dim_id
2891: - 50000000;
2892:
2893: update /*+NO_INDEX*/ hr_s_dimension_routes

Line 2913: from hr_s_balance_dimensions;

2909: select min(balance_dimension_id) - (count(*) *3)
2910: , max(balance_dimension_id) + (count(*) *3)
2911: into v_min_delivered
2912: , v_max_delivered
2913: from hr_s_balance_dimensions;
2914:
2915: select max(balance_dimension_id)
2916: into v_max_live
2917: from pay_balance_dimensions;

Line 2996: update hr_s_balance_dimensions

2992:
2993: -- Update all child entities
2994:
2995:
2996: update hr_s_balance_dimensions
2997: set balance_dimension_id = l_new_surrogate_key
2998: where balance_dimension_id = stu_rec.c_surrogate_key;
2999:
3000: update hr_s_application_ownerships

Line 3017: update hr_s_balance_dimensions

3013: update hr_s_dimension_routes
3014: set run_dimension_id = l_new_surrogate_key
3015: where run_dimension_id = stu_rec.c_surrogate_key;
3016:
3017: update hr_s_balance_dimensions
3018: set asg_action_balance_dim_id = l_new_surrogate_key
3019: where asg_action_balance_dim_id = stu_rec.c_surrogate_key;
3020:
3021:

Line 3031: delete from hr_s_balance_dimensions

3027: --+++ Comment used to say remove from either s/u or installed
3028:
3029: BEGIN
3030:
3031: delete from hr_s_balance_dimensions
3032: where rowid = stu_rec.rowid;
3033:
3034:
3035: END remove;

Line 3241: delete from hr_s_balance_dimensions a

3237: -- After the above two checks, no contention exists with the same
3238: -- true primary key. Now compare the row details. If the rows are
3239: -- identical the delivered row will be deleted.
3240:
3241: delete from hr_s_balance_dimensions a
3242: where a.balance_dimension_id = stu_rec.c_surrogate_key
3243: and exists (
3244: select 1 from pay_balance_dimensions b
3245: where a.ROUTE_ID = b.route_id

Line 3518: from hr_s_balance_dimensions

3514: BEGIN
3515:
3516: select distinct null
3517: into l_null_return
3518: from hr_s_balance_dimensions
3519: where balance_dimension_id = stu_rec.balance_dimension_id;
3520:
3521: crt_exc('Parent balance dimension remains in delivery tables');
3522: return FALSE; -- Parent row still in startup account