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 3842: from pay_person_latest_balances PERBAL

3838: PERBAL.expired_assignment_action_id,
3839: PERBAL.expired_value,
3840: PERBAL.prev_assignment_action_id,
3841: PERBAL.prev_balance_value
3842: from pay_person_latest_balances PERBAL
3843: , per_all_assignments_f ASSIGN
3844: , pay_assignment_actions ACT
3845: , pay_payroll_actions PACT
3846: , pay_assignment_actions OWN_ACT

Line 3872: l_balance_value pay_person_latest_balances.value%type;

3868: where latest_balance_id = p_latest_balance_id
3869: and CON.context_id = CONVAL.context_id
3870: order by 1;
3871: --
3872: l_balance_value pay_person_latest_balances.value%type;
3873: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3874: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3876: l_bal_expired_action

Line 3873: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;

3869: and CON.context_id = CONVAL.context_id
3870: order by 1;
3871: --
3872: l_balance_value pay_person_latest_balances.value%type;
3873: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3874: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3876: l_bal_expired_action
3877: pay_person_latest_balances.expired_assignment_action_id%type;

Line 3877: pay_person_latest_balances.expired_assignment_action_id%type;

3873: l_bal_owner_asg_action pay_person_latest_balances.assignment_action_id%type;
3874: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3876: l_bal_expired_action
3877: pay_person_latest_balances.expired_assignment_action_id%type;
3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3879: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3880: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3881: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;

Line 3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;

3874: l_bal_owner_act_seq pay_assignment_actions.action_sequence%type;
3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3876: l_bal_expired_action
3877: pay_person_latest_balances.expired_assignment_action_id%type;
3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3879: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3880: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3881: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3882: --

Line 3879: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;

3875: l_bal_asg_act_seq pay_assignment_actions.action_sequence%type;
3876: l_bal_expired_action
3877: pay_person_latest_balances.expired_assignment_action_id%type;
3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3879: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3880: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3881: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3882: --
3883: l_num_of_runs number;

Line 3880: l_prev_value pay_person_latest_balances.prev_balance_value%type;

3876: l_bal_expired_action
3877: pay_person_latest_balances.expired_assignment_action_id%type;
3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3879: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3880: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3881: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3882: --
3883: l_num_of_runs number;
3884: l_bal_con_str varchar2(500); -- Balance context string

Line 3881: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;

3877: pay_person_latest_balances.expired_assignment_action_id%type;
3878: l_bal_expired_value pay_person_latest_balances.expired_value%type;
3879: l_prev_action pay_person_latest_balances.prev_assignment_action_id%type;
3880: l_prev_value pay_person_latest_balances.prev_balance_value%type;
3881: l_latest_balance_id pay_person_latest_balances.latest_balance_id%type;
3882: --
3883: l_num_of_runs number;
3884: l_bal_con_str varchar2(500); -- Balance context string
3885: l_balance_found boolean;

Line 5685: l_balance_value pay_person_latest_balances.value%type;

5681: , p_get_rr_route in boolean
5682: , p_get_rb_route in boolean
5683: ) return number is p_balance_result number;
5684: --
5685: l_balance_value pay_person_latest_balances.value%type;
5686: l_found boolean;
5687: l_defbal_rec t_def_bal_rec;
5688: --
5689: ------------------------- get_value (action mode) -------------------------