eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_LEGISLATION dependencies on PAY_BALANCE_DIMENSIONS

Line 62: -- PAY_BALANCE_DIMENSIONS;

58: -- number - improves performance.
59: -- Also added two new columns to
60: -- installation procedures:
61: -- - FEED_CHECKING_TYPE in
62: -- PAY_BALANCE_DIMENSIONS;
63: -- - JURISDICTION_LEVEL in
64: -- PAY_BALANCE_TYPES.
65: -- 70.18 Rod Fine 23-Nov-1994 - Suppressed index on business_group_id
66: -- 70.19 Rod Fine 27-Mar-1995 - Added tax_type column to

Line 557: ,pay_balance_dimensions pbd

553: SELECT distinct ao.key_name
554: ,ao.product_name
555: ,ao.key_value
556: FROM hr_s_application_ownerships ao
557: ,pay_balance_dimensions pbd
558: WHERE pbd.legislation_code ='ZZ'
559: AND ao.key_name = 'BALANCE_DIMENSION_ID'
560: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id
561: AND NOT EXISTS (SELECT null

Line 586: ,pay_balance_dimensions pbd

582: ,ao.product_name
583: ,ao.key_value
584: FROM hr_s_application_ownerships ao
585: ,ff_routes fr
586: ,pay_balance_dimensions pbd
587: WHERE pbd.legislation_code ='ZZ'
588: AND ao.key_name = 'ROUTE_ID'
589: AND TO_NUMBER(ao.key_value) = fr.route_id
590: AND fr.route_id = pbd.route_id

Line 2316: from pay_balance_dimensions

2312:
2313: BEGIN
2314: select distinct null
2315: into l_null_return
2316: from pay_balance_dimensions
2317: where balance_dimension_id = def_bals.balance_dimension_id;
2318:
2319: EXCEPTION WHEN NO_DATA_FOUND THEN
2320: crt_exc('Parent balance dimension does not exist');

Line 2548: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_DIMENSIONS

2544: --
2545: END install_bal_types;
2546:
2547: --****************************************************************************
2548: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_DIMENSIONS
2549: --****************************************************************************
2550:
2551: PROCEDURE install_dimensions (p_phase IN number)
2552: ------------------------------------------------

Line 2627: from pay_balance_dimensions a

2623:
2624:
2625: select distinct null
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

Line 2671: from pay_balance_dimensions;

2667: from hr_s_balance_dimensions;
2668:
2669: select max(balance_dimension_id)
2670: into v_max_live
2671: from pay_balance_dimensions;
2672:
2673: select pay_balance_dimensions_s.nextval
2674: into v_sequence_number
2675: from dual;

Line 2673: select pay_balance_dimensions_s.nextval

2669: select max(balance_dimension_id)
2670: into v_max_live
2671: from pay_balance_dimensions;
2672:
2673: select pay_balance_dimensions_s.nextval
2674: into v_sequence_number
2675: from dual;
2676:
2677: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 2682: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2678: OR (v_sequence_number < v_max_live) THEN
2679:
2680: IF v_max_live > v_max_delivered THEN
2681:
2682: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2683: v_sequence_number,
2684: v_max_live);
2685: ELSE
2686:

Line 2687: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2683: v_sequence_number,
2684: v_max_live);
2685: ELSE
2686:
2687: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2688: v_sequence_number,
2689: v_max_delivered);
2690: END IF;
2691: END IF;

Line 2699: -- PAY_BALANCE_DIMENSIONS

2695: PROCEDURE crt_exc (exception_type IN varchar2)
2696: ----------------------------------------------
2697: IS
2698: -- Reports any exceptions during the delivery of startup data to
2699: -- PAY_BALANCE_DIMENSIONS
2700:
2701: BEGIN
2702: -- See procedure crt_exc in procedure install_past above for generic
2703: -- details.

Line 2706: insert_hr_stu_exceptions('pay_balance_dimensions'

2702: -- See procedure crt_exc in procedure install_past above for generic
2703: -- details.
2704:
2705: rollback to new_dimension_name;
2706: insert_hr_stu_exceptions('pay_balance_dimensions'
2707: , stu_rec.c_surrogate_key
2708: , exception_type
2709: , stu_rec.c_true_key);
2710:

Line 2724: from pay_balance_dimensions

2720:
2721: BEGIN
2722: select distinct balance_dimension_id
2723: into l_new_surrogate_key
2724: from pay_balance_dimensions
2725: where dimension_name = stu_rec.c_true_key
2726: and business_group_id is null
2727: and ( (legislation_code is null and stu_rec.c_leg_code is null)
2728: or (legislation_code = stu_rec.c_leg_code) );

Line 2732: select pay_balance_dimensions_s.nextval

2728: or (legislation_code = stu_rec.c_leg_code) );
2729:
2730: EXCEPTION WHEN NO_DATA_FOUND THEN
2731:
2732: select pay_balance_dimensions_s.nextval
2733: into l_new_surrogate_key
2734: from dual;
2735:
2736: WHEN TOO_MANY_ROWS THEN

Line 2738: hr_utility.trace('sel pay_balance_dimensions TMR');

2734: from dual;
2735:
2736: WHEN TOO_MANY_ROWS THEN
2737: hrrunprc_trace_on;
2738: hr_utility.trace('sel pay_balance_dimensions TMR');
2739: hr_utility.trace('dimension_name ' ||
2740: stu_rec.c_true_key);
2741: hr_utility.trace(':lc: ' || ':' ||
2742: stu_rec.c_leg_code || ':');

Line 2933: from pay_balance_dimensions a

2929: form_count number;
2930: --
2931: cursor c_get_baldim is
2932: select distinct null
2933: from pay_balance_dimensions a
2934: where a.dimension_name = stu_rec.c_true_key
2935: and a.business_group_id is not null
2936: and exists (select null from per_business_groups b
2937: where b.business_group_id = a.business_group_id

Line 2942: from pay_balance_dimensions

2938: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
2939:
2940: cursor c_get_baldim_null is
2941: select distinct null
2942: from pay_balance_dimensions
2943: where dimension_name = stu_rec.c_true_key
2944: and legislation_code <> stu_rec.c_leg_code
2945: and (legislation_code is null or stu_rec.c_leg_code is null);
2946: --

Line 2998: select 1 from pay_balance_dimensions b

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
3000: and a.DATABASE_ITEM_SUFFIX = b.DATABASE_ITEM_SUFFIX
3001: and a.DIMENSION_TYPE = b.DIMENSION_TYPE
3002: and length(a.FEED_CHECKING_CODE) = length(b.FEED_CHECKING_CODE)

Line 3045: from pay_balance_dimensions

3041: BEGIN
3042:
3043: select route_id
3044: into l_route_id
3045: from pay_balance_dimensions
3046: where balance_dimension_id = stu_rec.c_surrogate_key;
3047:
3048: EXCEPTION WHEN NO_DATA_FOUND THEN
3049: l_route_id := stu_rec.route_id;

Line 3060: pay_balance_dimensions bd,

3056: select fdi.formula_id
3057: from ff_fdi_usages_f fdi,
3058: ff_user_entities ue,
3059: pay_defined_balances db,
3060: pay_balance_dimensions bd,
3061: ff_database_items di
3062: where fdi.item_name = di.user_name
3063: and ue.creator_type = 'B'
3064: and ue.creator_id = db.defined_balance_id

Line 3075: pay_balance_dimensions bd,

3071: (select fdi.formula_id
3072: from ff_fdi_usages_f fdi,
3073: ff_user_entities ue,
3074: pay_defined_balances db,
3075: pay_balance_dimensions bd,
3076: ff_database_items di
3077: where fdi.item_name = di.user_name
3078: and ue.creator_type = 'B'
3079: and ue.creator_id = db.defined_balance_id

Line 3093: update pay_balance_dimensions

3089: where pdb.balance_dimension_id = stu_rec.c_surrogate_key);
3090:
3091: end if;
3092:
3093: update pay_balance_dimensions
3094: set route_id = stu_rec.route_id
3095: , database_item_suffix = stu_rec.database_item_suffix
3096: , dimension_type = stu_rec.dimension_type
3097: , description = stu_rec.description

Line 3113: insert into pay_balance_dimensions

3109: where balance_dimension_id = stu_rec.c_surrogate_key;
3110:
3111: IF NOT SQL%FOUND THEN
3112: BEGIN
3113: insert into pay_balance_dimensions
3114: (dimension_name
3115: ,balance_dimension_id
3116: ,route_id
3117: ,legislation_code

Line 3288: from pay_balance_dimensions

3284: BEGIN
3285:
3286: select distinct null
3287: into l_null_return
3288: from pay_balance_dimensions
3289: where balance_dimension_id = stu_rec.balance_dimension_id;
3290:
3291: EXCEPTION WHEN NO_DATA_FOUND THEN
3292: remove;