APPS.HR_LEGISLATION dependencies on HR_S_BALANCE_DIMENSIONS

Line 2580: from hr_s_balance_dimensions;

2576: , database_item_function
2577: , save_run_balance_enabled
2578: , start_date_code
2579: , rowid
2580: from hr_s_balance_dimensions;
2581:
2582: stu_rec stu%ROWTYPE; -- Record for the above select
2583:
2584:

Line 2620: from hr_s_balance_dimensions;

2616:
2617:
2618: select count(*)
2619: into cnt
2620: from hr_s_balance_dimensions;
2621:
2622: If cnt=0 then return; end if;
2623:
2624:

Line 2630: from hr_s_balance_dimensions b

2626: into l_null_return
2627: from pay_balance_dimensions a
2628: where exists
2629: (select null
2630: from hr_s_balance_dimensions b
2631: where a.balance_dimension_id = b.balance_dimension_id
2632: );
2633:
2634: --conflict may exist

Line 2637: update /*+NO_INDEX*/ hr_s_balance_dimensions

2633:
2634: --conflict may exist
2635: --update all balance_dimension_id's to remove conflict
2636:
2637: update /*+NO_INDEX*/ hr_s_balance_dimensions
2638: set balance_dimension_id = balance_dimension_id - 50000000;
2639:
2640: update /*+NO_INDEX*/ hr_s_defined_balances
2641: set balance_dimension_id = balance_dimension_id - 50000000;

Line 2643: update /*+NO_INDEX*/ hr_s_balance_dimensions

2639:
2640: update /*+NO_INDEX*/ hr_s_defined_balances
2641: set balance_dimension_id = balance_dimension_id - 50000000;
2642:
2643: update /*+NO_INDEX*/ hr_s_balance_dimensions
2644: set asg_action_balance_dim_id = asg_action_balance_dim_id
2645: - 50000000;
2646:
2647: update /*+NO_INDEX*/ hr_s_dimension_routes

Line 2667: from hr_s_balance_dimensions;

2663: select min(balance_dimension_id) - (count(*) *3)
2664: , max(balance_dimension_id) + (count(*) *3)
2665: into v_min_delivered
2666: , v_max_delivered
2667: from hr_s_balance_dimensions;
2668:
2669: select max(balance_dimension_id)
2670: into v_max_live
2671: from pay_balance_dimensions;

Line 2750: update hr_s_balance_dimensions

2746:
2747: -- Update all child entities
2748:
2749:
2750: update hr_s_balance_dimensions
2751: set balance_dimension_id = l_new_surrogate_key
2752: where balance_dimension_id = stu_rec.c_surrogate_key;
2753:
2754: update hr_s_application_ownerships

Line 2771: update hr_s_balance_dimensions

2767: update hr_s_dimension_routes
2768: set run_dimension_id = l_new_surrogate_key
2769: where run_dimension_id = stu_rec.c_surrogate_key;
2770:
2771: update hr_s_balance_dimensions
2772: set asg_action_balance_dim_id = l_new_surrogate_key
2773: where asg_action_balance_dim_id = stu_rec.c_surrogate_key;
2774:
2775:

Line 2785: delete from hr_s_balance_dimensions

2781: --+++ Comment used to say remove from either s/u or installed
2782:
2783: BEGIN
2784:
2785: delete from hr_s_balance_dimensions
2786: where rowid = stu_rec.rowid;
2787:
2788:
2789: END remove;

Line 2995: delete from hr_s_balance_dimensions a

2991: -- After the above two checks, no contention exists with the same
2992: -- true primary key. Now compare the row details. If the rows are
2993: -- identical the delivered row will be deleted.
2994:
2995: delete from hr_s_balance_dimensions a
2996: where a.balance_dimension_id = stu_rec.c_surrogate_key
2997: and exists (
2998: select 1 from pay_balance_dimensions b
2999: where a.ROUTE_ID = b.route_id

Line 3272: from hr_s_balance_dimensions

3268: BEGIN
3269:
3270: select distinct null
3271: into l_null_return
3272: from hr_s_balance_dimensions
3273: where balance_dimension_id = stu_rec.balance_dimension_id;
3274:
3275: crt_exc('Parent balance dimension remains in delivery tables');
3276: return FALSE; -- Parent row still in startup account