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 119: pay_balance_dimensions pbd

115: pbd.dimension_level
116: from pay_payroll_actions ppa,
117: per_business_groups pbg,
118: pay_defined_balances pdb,
119: pay_balance_dimensions pbd
120: where ppa.payroll_action_id = p_pact_id
121: and ppa.business_group_id = pbg.business_group_id
122: and ((pdb.business_group_id = pbg.business_group_id
123: and pdb.legislation_code is null)

Line 163: and not exists ( select 'run balance candidate' from pay_balance_dimensions bd,

159: update pay_balance_validation bv
160: set RUN_BALANCE_STATUS = 'I'
161: where RUN_BALANCE_STATUS <> 'I'
162: and bv.business_group_id = l_bus_grp
163: and not exists ( select 'run balance candidate' from pay_balance_dimensions bd,
164: pay_defined_balances db
165: where db.defined_balance_id = bv.defined_balance_id
166: and bd.balance_dimension_id = db.balance_dimension_id
167: and bd.dimension_type = 'R'

Line 367: pay_balance_dimensions pbd

363: --
364: select nvl(pbd.dimension_level, 'ASG')
365: into g_bal_lvl
366: from pay_defined_balances pdb,
367: pay_balance_dimensions pbd
368: where pdb.defined_balance_id = g_def_bal_id
369: and pdb.balance_dimension_id = pbd.balance_dimension_id;
370: --
371: g_proc_mode := 'SINGLE';

Line 1388: pay_balance_dimensions pbd

1384: pdb.defined_balance_id
1385: from
1386: pay_balance_types pbt,
1387: pay_defined_balances pdb,
1388: pay_balance_dimensions pbd
1389: where pbd.dimension_level = 'GRP'
1390: and pdb.save_run_balance = 'Y'
1391: and pbd.dimension_type = 'R'
1392: and pdb.balance_dimension_id = pbd.balance_dimension_id

Line 1426: pay_balance_dimensions pbd

1422: pdb.defined_balance_id
1423: from
1424: pay_balance_types pbt,
1425: pay_defined_balances pdb,
1426: pay_balance_dimensions pbd
1427: where pbd.dimension_level = 'ASG'
1428: and pdb.save_run_balance = 'Y'
1429: and pbd.dimension_type = 'R'
1430: and pdb.balance_dimension_id = pbd.balance_dimension_id