eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_BALANCE_PKG dependencies on PAY_PERSON_LATEST_BALANCES

Line 3544: from pay_person_latest_balances PERBAL

3540: PERBAL.expired_assignment_action_id,
3541: PERBAL.expired_value,
3542: PERBAL.prev_assignment_action_id,
3543: PERBAL.prev_balance_value
3544: from pay_person_latest_balances PERBAL
3545: , per_all_assignments_f ASSIGN
3546: , pay_assignment_actions ACT
3547: , pay_payroll_actions PACT
3548: , pay_assignment_actions OWN_ACT

Line 3574: l_balance_value pay_person_latest_balances.value%type;

3570: where latest_balance_id = p_latest_balance_id
3571: and CON.context_id = CONVAL.context_id
3572: order by 1;
3573: --
3574: l_balance_value pay_person_latest_balances.value%type;
3575: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3576: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3578: l_bal_expired_action

Line 3575: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;

3571: and CON.context_id = CONVAL.context_id
3572: order by 1;
3573: --
3574: l_balance_value pay_person_latest_balances.value%type;
3575: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3576: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3578: l_bal_expired_action
3579: pay_person_latest_balances.expired_assignment_action_id%type;

Line 3579: pay_person_latest_balances.expired_assignment_action_id%type;

3575: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3576: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3578: l_bal_expired_action
3579: pay_person_latest_balances.expired_assignment_action_id%type;
3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3581: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3582: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3583: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;

Line 3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;

3576: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3578: l_bal_expired_action
3579: pay_person_latest_balances.expired_assignment_action_id%type;
3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3581: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3582: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3583: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3584: --

Line 3581: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;

3577: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3578: l_bal_expired_action
3579: pay_person_latest_balances.expired_assignment_action_id%type;
3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3581: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3582: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3583: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3584: --
3585: l_num_of_runs number;

Line 3582: l_prev_value pay_person_latest_balances.prev_balance_value%type;

3578: l_bal_expired_action
3579: pay_person_latest_balances.expired_assignment_action_id%type;
3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3581: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3582: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3583: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3584: --
3585: l_num_of_runs number;
3586: l_bal_con_str varchar2(500); -- Balance context string

Line 3583: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;

3579: pay_person_latest_balances.expired_assignment_action_id%type;
3580: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3581: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3582: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3583: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3584: --
3585: l_num_of_runs number;
3586: l_bal_con_str varchar2(500); -- Balance context string
3587: l_balance_found boolean;

Line 5383: l_balance_value pay_person_latest_balances.value%type;

5379: , p_get_rr_route in boolean
5380: , p_get_rb_route in boolean
5381: ) return number is p_balance_result number;
5382: --
5383: l_balance_value pay_person_latest_balances.value%type;
5384: l_found boolean;
5385: l_defbal_rec t_def_bal_rec;
5386: --
5387: ------------------------- get_value (action mode) -------------------------