APPS.PAY_IP_RUN_BALANCE_UPGRADE dependencies on PAY_DEFINED_BALANCES

Line 127: from pay_defined_balances pdb,

123: cursor c_def_bal_id(cp_bal_type_id in number
124: ,cp_legislation_code in varchar2
125: ,cp_bal_dim in varchar2) is
126: select pdb.defined_balance_id
127: from pay_defined_balances pdb,
128: pay_balance_types pbt,
129: pay_balance_dimensions pbd
130: where pbt.balance_type_id = cp_bal_type_id
131: and pbd.database_item_suffix = cp_bal_dim

Line 238: pay_defined_balances_pkg.insert_row

234: close c_get_bal_dim_id;
235: hr_utility.trace('ln_bal_dim_id = '|| ln_bal_dim_id);
236:
237: /* Insert defined balance for _ASG_TU_RUN */
238: pay_defined_balances_pkg.insert_row
239: (x_rowid => lv_rowid
240: ,x_defined_balance_id => ln_def_balance_id
241: ,x_business_group_id => ln_business_grp_id
242: ,x_legislation_code => null

Line 251: update pay_defined_balances

247:
248: hr_utility.trace('Inserted defined balance for _ASG_TU_RUN ' || ln_def_balance_id);
249:
250: else
251: update pay_defined_balances
252: set save_run_balance = 'Y'
253: where defined_balance_id = ln_def_balance_id ;
254:
255: hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);

Line 267: update pay_defined_balances

263: ,'_ASG_RUN');
264: fetch c_def_bal_id into ln_def_balance_id;
265: close c_def_bal_id;
266:
267: update pay_defined_balances
268: set save_run_balance = 'Y'
269: where defined_balance_id = ln_def_balance_id ;
270:
271: hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);