DBA Data[Home] [Help]

APPS.HRASSACT dependencies on PAY_RUN_BALANCES

Line 200: pay_run_balances was not being

196: them after setting contexts.
197: 03-SEP-2003 nbristow 115.76 RETRO_DELETE is now a
198: legislation rule.
199: 29-AUG-2003 nbristow 115.75 Action sequence on
200: pay_run_balances was not being
201: updated correctly.
202: 53-JUN-2003 alogue 115.74 2960902 New trash_latest_balances
203: only passed balance_type_id
204: and trash_date. Overloads

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

279: to reverse to remove apparent
280: cartesian join.
281: 21-JUN-2002 alogue 115.49 Fix CA TAX_GROUP value fetch
282: in udca.
283: 30-APR-2002 RThirlby 115.48 Support for pay_run_balances -
284: balance reporting architecture,
285: for reversals and balance
286: adjustments.
287: 26-APR-2002 alogue 115.47 2346351 Support of payroll_id in udca

Line 3146: update pay_run_balances

3142: update pay_assignment_actions
3143: set action_sequence = newseq
3144: where assignment_action_id = p_assact;
3145: --
3146: update pay_run_balances
3147: set action_sequence = newseq
3148: where assignment_action_id = p_assact;
3149: --
3150: end update_action_sequence;

Line 3453: update pay_run_balances

3449: update pay_assignment_actions act
3450: set act.action_sequence = pay_assignment_actions_s.nextval
3451: where act.rowid = my_rowid;
3452: --
3453: update pay_run_balances
3454: set action_sequence = pay_assignment_actions_s.currval
3455: where assignment_action_id = upd_aa_id;
3456: --
3457: end loop;

Line 3712: update pay_run_balances

3708: update pay_assignment_actions act
3709: set act.action_sequence = pay_assignment_actions_s.nextval
3710: where act.rowid = my_rowid;
3711: --
3712: update pay_run_balances
3713: set action_sequence = pay_assignment_actions_s.currval
3714: where assignment_action_id = upd_aa_id;
3715: --
3716: /* If it's an assignment action thats created due to a

Line 4564: update pay_run_balances

4560: update pay_assignment_actions act
4561: set act.action_sequence = pay_assignment_actions_s.nextval
4562: where act.rowid = my_rowid;
4563: --
4564: update pay_run_balances
4565: set action_sequence = pay_assignment_actions_s.currval
4566: where assignment_action_id = upd_aa_id;
4567: end loop;
4568: --

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

5132: where paa.assignment_action_id = revassactid
5133: and ppa.payroll_action_id = paa.payroll_action_id
5134: and paa.assignment_action_id = prr.assignment_action_id;
5135: --
5136: -- cursor and variables used in reversal of pay_run_balances
5137: --
5138: rev_asgact_id pay_assignment_actions.assignment_action_id%type;
5139: rev_act_seq pay_assignment_actions.action_sequence%type;
5140: rev_eff_date pay_payroll_actions.effective_date%type;

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

5564: where pac.payroll_action_id = pactid;
5565: end;
5566: --
5567: --
5568: -- Now do the reversal for pay_run_balances. 1st the asg level balances
5569: --
5570: if g_debug then
5571: hr_utility.set_location('hrassact.reversal',45);
5572: end if;

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

6675:
6676: end if;
6677:
6678: --
6679: -- Perform balance adjustment for pay_run_balances, 1st for asg level
6680: -- run balances, then group run balances.
6681: --
6682: pay_balance_pkg.create_all_asg_balances(p_asgact_id => assactid);
6683: --