224: --
225: l_assignment_id per_all_assignments_f.assignment_id%type;
226: l_payroll_id pay_payroll_actions.payroll_action_id%type ;
227: --------------------------
228: -- Tables for pay_balance_pkg
229: --------------------------
230: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
231: g_context_tab pay_balance_pkg.t_context_tab;
232: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
226: l_payroll_id pay_payroll_actions.payroll_action_id%type ;
227: --------------------------
228: -- Tables for pay_balance_pkg
229: --------------------------
230: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
231: g_context_tab pay_balance_pkg.t_context_tab;
232: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
233: --
234: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
227: --------------------------
228: -- Tables for pay_balance_pkg
229: --------------------------
230: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
231: g_context_tab pay_balance_pkg.t_context_tab;
232: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
233: --
234: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
235: l_action_info_id pay_action_information.action_information_id%type;
228: -- Tables for pay_balance_pkg
229: --------------------------
230: g_balance_value_tab pay_balance_pkg.t_balance_value_tab;
231: g_context_tab pay_balance_pkg.t_context_tab;
232: g_detailed_bal_out_tab pay_balance_pkg.t_detailed_bal_out_tab;
233: --
234: l_asg_act_id pay_assignment_actions.assignment_action_id%type;
235: l_action_info_id pay_action_information.action_information_id%type;
236: l_ovn pay_action_information.object_version_number%type;
367: end loop;
368: -----------------------------------------
369: -- Batch Balance Retrival
370: -----------------------------------------
371: pay_balance_pkg.get_value( l_asg_act_id ,
372: g_balance_value_tab,
373: g_context_tab,
374: false,
375: false,