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.PAY_BALANCE_PKG dependencies on PAY_BALANCE_DIMENSIONS

Line 112: (dimension_type pay_balance_dimensions.dimension_type%type,

108: --
109: -- tables for dimension cache
110: --
111: type t_def_bal_rec is record
112: (dimension_type pay_balance_dimensions.dimension_type%type,
113: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,
114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,

Line 113: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,

109: -- tables for dimension cache
110: --
111: type t_def_bal_rec is record
112: (dimension_type pay_balance_dimensions.dimension_type%type,
113: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,
114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,

Line 114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,

110: --
111: type t_def_bal_rec is record
112: (dimension_type pay_balance_dimensions.dimension_type%type,
113: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,
114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,

Line 115: dimension_name pay_balance_dimensions.dimension_name%type,

111: type t_def_bal_rec is record
112: (dimension_type pay_balance_dimensions.dimension_type%type,
113: expiry_check_code pay_balance_dimensions.expiry_checking_code%type,
114: expiry_check_lvl pay_balance_dimensions.expiry_checking_level%type,
115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,

Line 119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,

115: dimension_name pay_balance_dimensions.dimension_name%type,
116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,
121: period_type pay_balance_dimensions.period_type%type,
122: balance_type_id pay_balance_types.balance_type_id%type,
123: dim_rou_rr_route_id pay_dimension_routes.route_id%type,

Line 120: dimension_lvl pay_balance_dimensions.dimension_level%type,

116: jurisdiction_lvl pay_balance_types.jurisdiction_level%type,
117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,
121: period_type pay_balance_dimensions.period_type%type,
122: balance_type_id pay_balance_types.balance_type_id%type,
123: dim_rou_rr_route_id pay_dimension_routes.route_id%type,
124: tu_needed boolean,

Line 121: period_type pay_balance_dimensions.period_type%type,

117: balance_type_column pay_dimension_routes.balance_type_column%type,
118: decode_required pay_dimension_routes.decode_required%type,
119: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
120: dimension_lvl pay_balance_dimensions.dimension_level%type,
121: period_type pay_balance_dimensions.period_type%type,
122: balance_type_id pay_balance_types.balance_type_id%type,
123: dim_rou_rr_route_id pay_dimension_routes.route_id%type,
124: tu_needed boolean,
125: jc_needed boolean,

Line 150: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,

146: -- tables for dimension route cache
147: --
148: type t_dim_rou_rec is record
149: (
150: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
151: priority pay_dimension_routes.priority%type,
152: route_type pay_dimension_routes.route_type%type,
153: run_def_bal_id pay_defined_balances.defined_balance_id%type,
154: retrieval_column pay_dimension_routes.retrieval_column%type

Line 167: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,

163: --
164: type t_int_bal_rec is record
165: (
166: defined_balance_id pay_defined_balances.defined_balance_id%type,
167: balance_dimension_id pay_balance_dimensions.balance_dimension_id%type,
168: balance_type_id pay_balance_types.balance_type_id%type,
169: balance_found boolean,
170: balance_value number,
171: jurisdiction_level pay_balance_types.jurisdiction_level%type,

Line 309: type dim_nm_tab is table of pay_balance_dimensions.dimension_name%type

305: --
306: type pay_act_id_tab is table of pay_payroll_actions.payroll_action_id%type
307: index by binary_integer;
308: type expiry_tab is table of NUMBER(38) index by binary_integer;
309: type dim_nm_tab is table of pay_balance_dimensions.dimension_name%type
310: index by binary_integer;
311: --
312: t_own_pay_action pay_act_id_tab;
313: t_usr_pay_action pay_act_id_tab;

Line 780: pay_balance_dimensions pbd,

776: cursor get_bal_contexts (p_def_bal_id in number) is
777: select context_name
778: from ff_contexts fc,
779: ff_route_context_usages frcu,
780: pay_balance_dimensions pbd,
781: pay_defined_balances pdb
782: where pdb.defined_balance_id = p_def_bal_id
783: and pdb.balance_dimension_id = pbd.balance_dimension_id
784: and pbd.route_id = frcu.route_id

Line 845: from pay_balance_dimensions DIM

841: g_defbal_cache(p_defined_balance_id).balance_dimension_id,
842: g_defbal_cache(p_defined_balance_id).balance_type_id,
843: g_defbal_cache(p_defined_balance_id).dimension_lvl,
844: g_defbal_cache(p_defined_balance_id).period_type
845: from pay_balance_dimensions DIM
846: , pay_defined_balances DEF
847: , pay_balance_types TYP
848: where DIM.balance_dimension_id = DEF.balance_dimension_id
849: and TYP.balance_type_id = DEF.balance_type_id

Line 3224: l_period_type pay_balance_dimensions.period_type%type;

3220: l_load_date pay_balance_validation.balance_load_date%type;
3221: l_retrieval_date pay_payroll_actions.effective_date%type;
3222: l_bus_grp_id pay_payroll_actions.business_group_id%type;
3223: l_payroll_id pay_payroll_actions.payroll_id%type;
3224: l_period_type pay_balance_dimensions.period_type%type;
3225: l_start_date_code pay_balance_dimensions.start_date_code%type;
3226: l_action_type pay_payroll_actions.action_type%type;
3227: l_start_date date;
3228: --

Line 3225: l_start_date_code pay_balance_dimensions.start_date_code%type;

3221: l_retrieval_date pay_payroll_actions.effective_date%type;
3222: l_bus_grp_id pay_payroll_actions.business_group_id%type;
3223: l_payroll_id pay_payroll_actions.payroll_id%type;
3224: l_period_type pay_balance_dimensions.period_type%type;
3225: l_start_date_code pay_balance_dimensions.start_date_code%type;
3226: l_action_type pay_payroll_actions.action_type%type;
3227: l_start_date date;
3228: --
3229: begin

Line 3273: from pay_balance_dimensions pbd,

3269: select nvl(pbd.period_type, 'NULL'),
3270: pbd.start_date_code
3271: into l_period_type,
3272: l_start_date_code
3273: from pay_balance_dimensions pbd,
3274: pay_defined_balances pdb
3275: where pdb.defined_balance_id = p_retreival_db_id
3276: and pdb.balance_dimension_id = pbd.balance_dimension_id;
3277:

Line 4731: ||'with the dimension_type on pay_balance_dimensions. '

4727: ,'Core Balance pkg - Dimension_type is NOT A or P. '
4728: ||'Latest balances are only availbale for assignment '
4729: ||'or person level balances, that are not also Run '
4730: ||'level balances. The level of the balance is set '
4731: ||'with the dimension_type on pay_balance_dimensions. '
4732: ||'Dimension types for seeded data must not be '
4733: ||'updated.');
4734: end if;
4735: --

Line 5312: l_batch_bd_id pay_balance_dimensions.balance_dimension_id%type;

5308: l_defbal_rec t_def_bal_rec;
5309: l_balance_value number;
5310: l_found boolean;
5311: l_balance_cache t_int_bal_cache;
5312: l_batch_bd_id pay_balance_dimensions.balance_dimension_id%type;
5313: l_batch_list t_batch_list;
5314: l_batch_cnt number;
5315: l_dummy_value number;
5316: l_decode_required boolean;

Line 6239: pay_balance_dimensions pbd

6235: -- bug 13455833 only fetch run balances after the invalidate date
6236: -- and check if there are results that will feed them from that date
6237: select pdb.defined_balance_id
6238: from pay_defined_balances pdb,
6239: pay_balance_dimensions pbd
6240: where pdb.balance_type_id = p_bal_id
6241: and pbd.balance_dimension_id = pdb.balance_dimension_id
6242: and pbd.dimension_level <> 'GRP'
6243: and pdb.save_run_balance = 'Y'

Line 6268: pay_balance_dimensions pbd

6264: )
6265: is
6266: select pdb.defined_balance_id
6267: from pay_defined_balances pdb,
6268: pay_balance_dimensions pbd
6269: where pdb.balance_type_id = p_bal_id
6270: and pbd.balance_dimension_id = pdb.balance_dimension_id
6271: and pbd.dimension_level = 'GRP'
6272: and pdb.save_run_balance = 'Y'

Line 6303: pay_balance_dimensions pbd

6299: -- bug 13455833 only fetch run balances after the invalidate date
6300: -- and check if there are results that will feed them from that date
6301: select pdb.defined_balance_id
6302: from pay_defined_balances pdb,
6303: pay_balance_dimensions pbd
6304: where pdb.balance_type_id = p_bal_id
6305: and pbd.balance_dimension_id = pdb.balance_dimension_id
6306: and pbd.dimension_level <> 'GRP'
6307: and pdb.save_run_balance = 'Y'

Line 6332: pay_balance_dimensions pbd

6328: )
6329: is
6330: select pdb.defined_balance_id
6331: from pay_defined_balances pdb,
6332: pay_balance_dimensions pbd
6333: where pdb.balance_type_id = p_bal_id
6334: and pbd.balance_dimension_id = pdb.balance_dimension_id
6335: and pbd.dimension_level = 'GRP'
6336: and pdb.save_run_balance = 'Y'

Line 7162: pay_balance_dimensions pbd

7158: select pdb.defined_balance_id
7159: into g_rlb_asg_defbals(l_cnt).defined_balance_id
7160: from pay_defined_balances pdb,
7161: pay_defined_balances pdb_grp,
7162: pay_balance_dimensions pbd
7163: where pdb_grp.defined_balance_id = g_rlb_grp_defbals(l_cnt).defined_balance_id
7164: and pdb_grp.balance_dimension_id = pbd.balance_dimension_id
7165: and pdb.balance_type_id = pdb_grp.balance_type_id
7166: and pdb.balance_dimension_id = pbd.asg_action_balance_dim_id;

Line 7851: ,pay_balance_dimensions pbd

7847: from
7848: pay_input_values_f piv
7849: ,pay_balance_feeds_f pbf
7850: ,pay_defined_balances pdb
7851: ,pay_balance_dimensions pbd
7852: ,pay_run_result_values prrv
7853: where
7854: pbd.dimension_level = 'ASG'
7855: and pdb.save_run_balance = 'Y'

Line 8626: pay_balance_dimensions pbd,

8622: pay_input_values_f piv,
8623: pay_balance_feeds_f pbf,
8624: pay_balance_types pbt,
8625: pay_defined_balances pdb,
8626: pay_balance_dimensions pbd,
8627: pay_run_result_values prrv
8628: where pbd.dimension_level = 'GRP'
8629: and pdb.save_run_balance|| decode (pbt.balance_type_id, 0, '', '')= 'Y'
8630: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 8688: pay_balance_dimensions pbd

8684: from
8685: pay_bal_attribute_definitions pbad,
8686: pay_balance_attributes pba,
8687: pay_defined_balances pdb,
8688: pay_balance_dimensions pbd
8689: where
8690: pbad.attribute_name = p_bal_list
8691: and pbad.attribute_id = pba.attribute_id
8692: and pba.defined_balance_id = pdb.defined_balance_id

Line 8718: pay_balance_dimensions pbd

8714: from
8715: pay_bal_attribute_definitions pbad,
8716: pay_balance_attributes pba,
8717: pay_defined_balances pdb,
8718: pay_balance_dimensions pbd
8719: where
8720: pbad.attribute_name = p_bal_list
8721: and pbad.attribute_id = pba.attribute_id
8722: and pba.defined_balance_id = pdb.defined_balance_id

Line 8752: pay_balance_dimensions pbd

8748: from
8749: pay_bal_attribute_definitions pbad,
8750: pay_balance_attributes pba,
8751: pay_defined_balances pdb,
8752: pay_balance_dimensions pbd
8753: where
8754: pbad.attribute_name = p_bal_list
8755: and pbad.attribute_id = pba.attribute_id
8756: and pba.defined_balance_id = pdb.defined_balance_id

Line 9493: pay_balance_dimensions pbd

9489: pay_run_result_values prrv,
9490: pay_balance_feeds_f pbf,
9491: pay_balance_types pbt,
9492: pay_defined_balances pdb,
9493: pay_balance_dimensions pbd
9494: where pbd.dimension_level = 'ASG'
9495: and pdb.save_run_balance|| decode (pbt.balance_type_id, 0, '', '')= 'Y'
9496: and pdb.balance_dimension_id = pbd.balance_dimension_id
9497: and pdb.balance_type_id = pbt.balance_type_id

Line 9546: pay_balance_dimensions pbd

9542: from
9543: pay_bal_attribute_definitions pbad,
9544: pay_balance_attributes pba,
9545: pay_defined_balances pdb,
9546: pay_balance_dimensions pbd
9547: where
9548: pbad.attribute_name = p_bal_list
9549: and pbad.attribute_id = pba.attribute_id
9550: and pba.defined_balance_id = pdb.defined_balance_id

Line 9576: pay_balance_dimensions pbd

9572: from
9573: pay_bal_attribute_definitions pbad,
9574: pay_balance_attributes pba,
9575: pay_defined_balances pdb,
9576: pay_balance_dimensions pbd
9577: where
9578: pbad.attribute_name = p_bal_list
9579: and pbad.attribute_id = pba.attribute_id
9580: and pba.defined_balance_id = pdb.defined_balance_id

Line 9608: -- pay_balance_dimensions pbd

9604: -- from
9605: -- pay_bal_attribute_definitions pbad,
9606: -- pay_balance_attributes pba,
9607: -- pay_defined_balances pdb,
9608: -- pay_balance_dimensions pbd
9609: -- where
9610: -- pbad.attribute_name = p_bal_list
9611: -- and pbad.attribute_id = pba.attribute_id
9612: -- and pba.defined_balance_id = pdb.defined_balance_id

Line 9660: pay_balance_dimensions pbd,

9656: pay_input_values_f piv,
9657: pay_balance_feeds_f pbf,
9658: pay_defined_balances pdb,
9659: pay_balance_attributes pba,
9660: pay_balance_dimensions pbd,
9661: pay_balance_validation pbv,
9662: pay_run_result_values prrv
9663: where
9664: prr.assignment_action_id = p_asg_act_id

Line 10118: pay_balance_dimensions pbd,

10114: cursor crs_asgact (p_asg_act_id number)
10115: is
10116: select pdb.defined_balance_id
10117: from pay_defined_balances pdb,
10118: pay_balance_dimensions pbd,
10119: pay_assignment_actions paa,
10120: pay_payroll_actions ppa,
10121: per_business_groups_perf pbg
10122: where pbd.dimension_level = 'ASG'

Line 10147: pay_balance_dimensions pbd

10143: pay_payroll_actions ppa,
10144: per_business_groups_perf pbg,
10145: pay_balance_validation pbv,
10146: pay_defined_balances pdb,
10147: pay_balance_dimensions pbd
10148: where pbd.dimension_level = 'ASG'
10149: and pdb.save_run_balance = 'Y'
10150: and pdb.balance_dimension_id = pbd.balance_dimension_id
10151: and paa.assignment_action_id = p_asg_act_id

Line 10583: pay_balance_dimensions pbd,

10579: cursor crs_pact (p_pact_id number)
10580: is
10581: select pdb.defined_balance_id
10582: from pay_defined_balances pdb,
10583: pay_balance_dimensions pbd,
10584: pay_payroll_actions ppa,
10585: per_business_groups_perf pbg
10586: where pbd.dimension_level = 'GRP'
10587: and pdb.save_run_balance = 'Y'

Line 10609: pay_balance_dimensions pbd

10605: from pay_payroll_actions ppa,
10606: per_business_groups_perf pbg,
10607: pay_balance_validation pbv,
10608: pay_defined_balances pdb,
10609: pay_balance_dimensions pbd
10610: where pbd.dimension_level = 'GRP'
10611: and pdb.save_run_balance = 'Y'
10612: and pdb.balance_dimension_id = pbd.balance_dimension_id
10613: and ppa.payroll_action_id = p_pact_id

Line 10762: from pay_balance_dimensions

10758: --
10759: cursor get_dim_level(p_balance_dimension_id in number)
10760: is
10761: select dimension_level
10762: from pay_balance_dimensions
10763: where dimension_type = 'R'
10764: and balance_dimension_id = p_balance_dimension_id;
10765: --
10766: cursor get_leg_code(p_bg_id number)

Line 10808: l_dim_level pay_balance_dimensions.dimension_level%type;

10804: where ppa.action_type = pac.action_type
10805: and pac.classification_name = 'SEQUENCED'
10806: and ppa.business_group_id = p_business_group_id;
10807: --
10808: l_dim_level pay_balance_dimensions.dimension_level%type;
10809: l_leg_code per_business_groups_perf.legislation_code%type;
10810: l_bg_id per_business_groups_perf.business_group_id%type;
10811: l_bal_load_date pay_balance_validation.balance_load_date%type;
10812: l_rr_exists number;

Line 12020: pay_balance_dimensions dim,

12016:
12017: select linked_db.defined_balance_id
12018: into g_ldb_linked_def_bal
12019: from pay_defined_balances db,
12020: pay_balance_dimensions dim,
12021: pay_defined_balances linked_db,
12022: pay_balance_validation bv
12023: where db.defined_balance_id = p_defined_balance_id
12024: and dim.balance_dimension_id = db.balance_dimension_id