APPS.PAY_RUN_BALANCE_BUILD dependencies on PAY_DEFINED_BALANCES

Line 8: g_def_bal_id pay_defined_balances.defined_balance_id%type;

4: --
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;

Line 100: pay_defined_balances pdb,

96: 'BOTH') balance_level,
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

Line 148: from pay_defined_balances pdb,

144: if (g_load_type <> 'DELTA') then
145: --
146: select nvl(pbv.run_balance_status, 'I')
147: into l_run_bal_stat
148: from pay_defined_balances pdb,
149: pay_balance_validation pbv
150: where pdb.defined_balance_id = dbrec.defined_balance_id
151: and pbv.defined_balance_id (+) = pdb.defined_balance_id
152: and pbv.business_group_id (+) = dbrec.business_group_id;

Line 196: from pay_defined_balances pdb,

192: if (g_load_type <> 'DELTA') then
193: --
194: select nvl(pbv.run_balance_status, 'I')
195: into l_run_bal_stat
196: from pay_defined_balances pdb,
197: pay_balance_validation pbv
198: where pdb.defined_balance_id = g_def_bal_id
199: and pbv.defined_balance_id (+) = pdb.defined_balance_id
200: and pbv.business_group_id (+) = l_bus_grp;

Line 293: from pay_defined_balances pdb,

289: -- Override the balance level for a single balance load
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: --

Line 318: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type

314: p_bal_load_date in date
315: )
316: is
317: --
318: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type
319: index by binary_integer;
320: --
321: l_delete_bals boolean;
322: l_def_bal_list pay_balance_pkg.t_balance_value_tab;

Line 675: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type

671: p_bal_load_date in date
672: )
673: is
674: --
675: type t_def_bal_id is table of pay_defined_balances.defined_balance_id%type
676: index by binary_integer;
677: --
678: l_delete_bals boolean;
679: l_def_bal_list pay_balance_pkg.t_balance_value_tab;

Line 1142: pay_defined_balances pdb,

1138: select
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

Line 1179: pay_defined_balances pdb,

1175: select
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