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 599: from pay_defined_balances pdb, pay_balance_dimensions pbd, pay_balance_types pbt

595: elsif l_table_name='PAY_DEFINED_BALANCES' then
596:
597: Select 'Y' into v_exists from dual where exists(
598: select null
599: from pay_defined_balances pdb, pay_balance_dimensions pbd, pay_balance_types pbt
600: where pdb.business_group_id is null
601: and pdb.legislation_code = p_legislation_code
602: and pdb.created_by > 2
603: and pdb.last_updated_by > 2

Line 762: ,pay_balance_dimensions pbd

758: SELECT distinct ao.key_name
759: ,ao.product_name
760: ,ao.key_value
761: FROM hr_s_application_ownerships ao
762: ,pay_balance_dimensions pbd
763: WHERE pbd.legislation_code ='ZZ'
764: AND ao.key_name = 'BALANCE_DIMENSION_ID'
765: AND TO_NUMBER(ao.key_value) = pbd.balance_dimension_id
766: AND NOT EXISTS (SELECT null

Line 791: ,pay_balance_dimensions pbd

787: ,ao.product_name
788: ,ao.key_value
789: FROM hr_s_application_ownerships ao
790: ,ff_routes fr
791: ,pay_balance_dimensions pbd
792: WHERE pbd.legislation_code ='ZZ'
793: AND ao.key_name = 'ROUTE_ID'
794: AND TO_NUMBER(ao.key_value) = fr.route_id
795: AND fr.route_id = pbd.route_id

Line 2543: from pay_balance_dimensions

2539:
2540: BEGIN
2541: select distinct null
2542: into l_null_return
2543: from pay_balance_dimensions
2544: where balance_dimension_id = def_bals.balance_dimension_id;
2545:
2546: EXCEPTION WHEN NO_DATA_FOUND THEN
2547: crt_exc('Parent balance dimension does not exist');

Line 2794: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_DIMENSIONS

2790: --
2791: END install_bal_types;
2792:
2793: --****************************************************************************
2794: -- INSTALLATION PROCEDURE FOR : PAY_BALANCE_DIMENSIONS
2795: --****************************************************************************
2796:
2797: PROCEDURE install_dimensions (p_phase IN number)
2798: ------------------------------------------------

Line 2873: from pay_balance_dimensions a

2869:
2870:
2871: select distinct null
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

Line 2917: from pay_balance_dimensions;

2913: from hr_s_balance_dimensions;
2914:
2915: select max(balance_dimension_id)
2916: into v_max_live
2917: from pay_balance_dimensions;
2918:
2919: select pay_balance_dimensions_s.nextval
2920: into v_sequence_number
2921: from dual;

Line 2919: select pay_balance_dimensions_s.nextval

2915: select max(balance_dimension_id)
2916: into v_max_live
2917: from pay_balance_dimensions;
2918:
2919: select pay_balance_dimensions_s.nextval
2920: into v_sequence_number
2921: from dual;
2922:
2923: IF (v_sequence_number BETWEEN v_min_delivered AND v_max_delivered)

Line 2928: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2924: OR (v_sequence_number < v_max_live) THEN
2925:
2926: IF v_max_live > v_max_delivered THEN
2927:
2928: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2929: v_sequence_number,
2930: v_max_live);
2931: ELSE
2932:

Line 2933: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',

2929: v_sequence_number,
2930: v_max_live);
2931: ELSE
2932:
2933: hr_legislation.munge_sequence('PAY_BALANCE_DIMENSIONS_S',
2934: v_sequence_number,
2935: v_max_delivered);
2936: END IF;
2937: END IF;

Line 2945: -- PAY_BALANCE_DIMENSIONS

2941: PROCEDURE crt_exc (exception_type IN varchar2)
2942: ----------------------------------------------
2943: IS
2944: -- Reports any exceptions during the delivery of startup data to
2945: -- PAY_BALANCE_DIMENSIONS
2946:
2947: BEGIN
2948: -- See procedure crt_exc in procedure install_past above for generic
2949: -- details.

Line 2952: insert_hr_stu_exceptions('pay_balance_dimensions'

2948: -- See procedure crt_exc in procedure install_past above for generic
2949: -- details.
2950:
2951: rollback to new_dimension_name;
2952: insert_hr_stu_exceptions('pay_balance_dimensions'
2953: , stu_rec.c_surrogate_key
2954: , exception_type
2955: , stu_rec.c_true_key);
2956:

Line 2970: from pay_balance_dimensions

2966:
2967: BEGIN
2968: select distinct balance_dimension_id
2969: into l_new_surrogate_key
2970: from pay_balance_dimensions
2971: where dimension_name = stu_rec.c_true_key
2972: and business_group_id is null
2973: and ( (legislation_code is null and stu_rec.c_leg_code is null)
2974: or (legislation_code = stu_rec.c_leg_code) );

Line 2978: select pay_balance_dimensions_s.nextval

2974: or (legislation_code = stu_rec.c_leg_code) );
2975:
2976: EXCEPTION WHEN NO_DATA_FOUND THEN
2977:
2978: select pay_balance_dimensions_s.nextval
2979: into l_new_surrogate_key
2980: from dual;
2981:
2982: WHEN TOO_MANY_ROWS THEN

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

2980: from dual;
2981:
2982: WHEN TOO_MANY_ROWS THEN
2983: hrrunprc_trace_on;
2984: hr_utility.trace('sel pay_balance_dimensions TMR');
2985: hr_utility.trace('dimension_name ' ||
2986: stu_rec.c_true_key);
2987: hr_utility.trace(':lc: ' || ':' ||
2988: stu_rec.c_leg_code || ':');

Line 3179: from pay_balance_dimensions a

3175: form_count number;
3176: --
3177: cursor c_get_baldim is
3178: select distinct null
3179: from pay_balance_dimensions a
3180: where a.dimension_name = stu_rec.c_true_key
3181: and a.business_group_id is not null
3182: and exists (select null from per_business_groups b
3183: where b.business_group_id = a.business_group_id

Line 3188: from pay_balance_dimensions

3184: and b.legislation_code = nvl(stu_rec.c_leg_code,b.legislation_code));
3185:
3186: cursor c_get_baldim_null is
3187: select distinct null
3188: from pay_balance_dimensions
3189: where dimension_name = stu_rec.c_true_key
3190: and legislation_code <> stu_rec.c_leg_code
3191: and (legislation_code is null or stu_rec.c_leg_code is null);
3192: --

Line 3244: select 1 from pay_balance_dimensions b

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
3246: and a.DATABASE_ITEM_SUFFIX = b.DATABASE_ITEM_SUFFIX
3247: and a.DIMENSION_TYPE = b.DIMENSION_TYPE
3248: and length(a.FEED_CHECKING_CODE) = length(b.FEED_CHECKING_CODE)

Line 3291: from pay_balance_dimensions

3287: BEGIN
3288:
3289: select route_id
3290: into l_route_id
3291: from pay_balance_dimensions
3292: where balance_dimension_id = stu_rec.c_surrogate_key;
3293:
3294: EXCEPTION WHEN NO_DATA_FOUND THEN
3295: l_route_id := stu_rec.route_id;

Line 3306: pay_balance_dimensions bd,

3302: select fdi.formula_id
3303: from ff_fdi_usages_f fdi,
3304: ff_user_entities ue,
3305: pay_defined_balances db,
3306: pay_balance_dimensions bd,
3307: ff_database_items di
3308: where fdi.item_name = di.user_name
3309: and ue.creator_type = 'B'
3310: and ue.creator_id = db.defined_balance_id

Line 3321: pay_balance_dimensions bd,

3317: (select fdi.formula_id
3318: from ff_fdi_usages_f fdi,
3319: ff_user_entities ue,
3320: pay_defined_balances db,
3321: pay_balance_dimensions bd,
3322: ff_database_items di
3323: where fdi.item_name = di.user_name
3324: and ue.creator_type = 'B'
3325: and ue.creator_id = db.defined_balance_id

Line 3339: update pay_balance_dimensions

3335: where pdb.balance_dimension_id = stu_rec.c_surrogate_key);
3336:
3337: end if;
3338:
3339: update pay_balance_dimensions
3340: set route_id = stu_rec.route_id
3341: , database_item_suffix = stu_rec.database_item_suffix
3342: , dimension_type = stu_rec.dimension_type
3343: , description = stu_rec.description

Line 3359: insert into pay_balance_dimensions

3355: where balance_dimension_id = stu_rec.c_surrogate_key;
3356:
3357: IF NOT SQL%FOUND THEN
3358: BEGIN
3359: insert into pay_balance_dimensions
3360: (dimension_name
3361: ,balance_dimension_id
3362: ,route_id
3363: ,legislation_code

Line 3534: from pay_balance_dimensions

3530: BEGIN
3531:
3532: select distinct null
3533: into l_null_return
3534: from pay_balance_dimensions
3535: where balance_dimension_id = stu_rec.balance_dimension_id;
3536:
3537: EXCEPTION WHEN NO_DATA_FOUND THEN
3538: remove;