DBA Data[Home] [Help]

APPS.HRASSACT dependencies on PAY_RUN_BALANCES

Line 232: pay_run_balances was not being

228: them after setting contexts.
229: 03-SEP-2003 nbristow 115.76 RETRO_DELETE is now a
230: legislation rule.
231: 29-AUG-2003 nbristow 115.75 Action sequence on
232: pay_run_balances was not being
233: updated correctly.
234: 53-JUN-2003 alogue 115.74 2960902 New trash_latest_balances
235: only passed balance_type_id
236: and trash_date. Overloads

Line 315: 30-APR-2002 RThirlby 115.48 Support for pay_run_balances -

311: to reverse to remove apparent
312: cartesian join.
313: 21-JUN-2002 alogue 115.49 Fix CA TAX_GROUP value fetch
314: in udca.
315: 30-APR-2002 RThirlby 115.48 Support for pay_run_balances -
316: balance reporting architecture,
317: for reversals and balance
318: adjustments.
319: 26-APR-2002 alogue 115.47 2346351 Support of payroll_id in udca

Line 3163: update pay_run_balances

3159: update pay_assignment_actions
3160: set action_sequence = newseq
3161: where assignment_action_id = p_assact;
3162: --
3163: update pay_run_balances
3164: set action_sequence = newseq
3165: where assignment_action_id = p_assact;
3166: --
3167: end update_action_sequence;

Line 3473: update pay_run_balances

3469: update pay_assignment_actions act
3470: set act.action_sequence = pay_assignment_actions_s.nextval
3471: where act.rowid = my_rowid;
3472: --
3473: update pay_run_balances
3474: set action_sequence = pay_assignment_actions_s.currval
3475: where assignment_action_id = upd_aa_id;
3476: --
3477: end loop;

Line 3732: update pay_run_balances

3728: update pay_assignment_actions act
3729: set act.action_sequence = pay_assignment_actions_s.nextval
3730: where act.rowid = my_rowid;
3731: --
3732: update pay_run_balances
3733: set action_sequence = pay_assignment_actions_s.currval
3734: where assignment_action_id = upd_aa_id;
3735: --
3736: /* If it's an assignment action thats created due to a

Line 4584: update pay_run_balances

4580: update pay_assignment_actions act
4581: set act.action_sequence = pay_assignment_actions_s.nextval
4582: where act.rowid = my_rowid;
4583: --
4584: update pay_run_balances
4585: set action_sequence = pay_assignment_actions_s.currval
4586: where assignment_action_id = upd_aa_id;
4587: end loop;
4588: --

Line 5368: -- cursor and variables used in reversal of pay_run_balances

5364: where paa.assignment_action_id = revassactid
5365: and ppa.payroll_action_id = paa.payroll_action_id
5366: and paa.assignment_action_id = prr.assignment_action_id;
5367: --
5368: -- cursor and variables used in reversal of pay_run_balances
5369: --
5370: rev_asgact_id pay_assignment_actions.assignment_action_id%type;
5371: rev_act_seq pay_assignment_actions.action_sequence%type;
5372: rev_eff_date pay_payroll_actions.effective_date%type;

Line 5804: -- Now do the reversal for pay_run_balances. 1st the asg level balances

5800: where pac.payroll_action_id = pactid;
5801: end;
5802: --
5803: --
5804: -- Now do the reversal for pay_run_balances. 1st the asg level balances
5805: --
5806: if g_debug then
5807: hr_utility.set_location('hrassact.reversal',45);
5808: end if;

Line 6943: -- Perform balance adjustment for pay_run_balances, 1st for asg level

6939:
6940: end if;
6941:
6942: --
6943: -- Perform balance adjustment for pay_run_balances, 1st for asg level
6944: -- run balances, then group run balances.
6945: --
6946: pay_balance_pkg.create_all_asg_balances(p_asgact_id => assactid);
6947: --