APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_BALANCE_DIMENSIONS

Line 9: g_bal_lvl pay_balance_dimensions.dimension_level%type;

5: /* Setup Glabals */
6: --
7: g_timeout date;
8: g_def_bal_id pay_defined_balances.defined_balance_id%type;
9: g_bal_lvl pay_balance_dimensions.dimension_level%type;
10: g_proc_mode varchar2(30);
11: g_load_type varchar2(30);
12: g_save_run_bals pay_legislation_rules.rule_mode%type;
13: g_save_asg_run_bals pay_legislation_rules.rule_mode%type;

Line 101: pay_balance_dimensions pbd

97: pbd.dimension_level
98: from pay_payroll_actions ppa,
99: per_business_groups pbg,
100: pay_defined_balances pdb,
101: pay_balance_dimensions pbd
102: where ppa.payroll_action_id = p_pact_id
103: and ppa.business_group_id = pbg.business_group_id
104: and ((pdb.business_group_id = pbg.business_group_id
105: and pdb.legislation_code is null)

Line 294: pay_balance_dimensions pbd

290: --
291: select nvl(pbd.dimension_level, 'ASG')
292: into g_bal_lvl
293: from pay_defined_balances pdb,
294: pay_balance_dimensions pbd
295: where pdb.defined_balance_id = g_def_bal_id
296: and pdb.balance_dimension_id = pbd.balance_dimension_id;
297: --
298: g_proc_mode := 'SINGLE';

Line 1143: pay_balance_dimensions pbd

1139: pdb.defined_balance_id
1140: from
1141: pay_balance_types pbt,
1142: pay_defined_balances pdb,
1143: pay_balance_dimensions pbd
1144: where pbd.dimension_level = 'GRP'
1145: and pdb.save_run_balance = 'Y'
1146: and pdb.balance_dimension_id = pbd.balance_dimension_id
1147: and pdb.balance_type_id = pbt.balance_type_id

Line 1180: pay_balance_dimensions pbd

1176: pdb.defined_balance_id
1177: from
1178: pay_balance_types pbt,
1179: pay_defined_balances pdb,
1180: pay_balance_dimensions pbd
1181: where pbd.dimension_level = 'ASG'
1182: and pdb.save_run_balance = 'Y'
1183: and pdb.balance_dimension_id = pbd.balance_dimension_id
1184: and pdb.balance_type_id = pbt.balance_type_id