3:
4:
5: /* changes start here */
6: g_debug boolean;
7: p_balance_value_tab_run pay_balance_pkg.t_balance_value_tab;
8: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
9: p_balance_value_tab_le_ytd pay_balance_pkg.t_balance_value_tab; /* Bug 4169557 */
10: p_context_table_run pay_balance_pkg.t_context_tab;
11: p_result_table_run pay_balance_pkg.t_detailed_bal_out_tab;
4:
5: /* changes start here */
6: g_debug boolean;
7: p_balance_value_tab_run pay_balance_pkg.t_balance_value_tab;
8: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
9: p_balance_value_tab_le_ytd pay_balance_pkg.t_balance_value_tab; /* Bug 4169557 */
10: p_context_table_run pay_balance_pkg.t_context_tab;
11: p_result_table_run pay_balance_pkg.t_detailed_bal_out_tab;
12:
5: /* changes start here */
6: g_debug boolean;
7: p_balance_value_tab_run pay_balance_pkg.t_balance_value_tab;
8: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
9: p_balance_value_tab_le_ytd pay_balance_pkg.t_balance_value_tab; /* Bug 4169557 */
10: p_context_table_run pay_balance_pkg.t_context_tab;
11: p_result_table_run pay_balance_pkg.t_detailed_bal_out_tab;
12:
13:
6: g_debug boolean;
7: p_balance_value_tab_run pay_balance_pkg.t_balance_value_tab;
8: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
9: p_balance_value_tab_le_ytd pay_balance_pkg.t_balance_value_tab; /* Bug 4169557 */
10: p_context_table_run pay_balance_pkg.t_context_tab;
11: p_result_table_run pay_balance_pkg.t_detailed_bal_out_tab;
12:
13:
14:
7: p_balance_value_tab_run pay_balance_pkg.t_balance_value_tab;
8: p_balance_value_tab_ytd pay_balance_pkg.t_balance_value_tab;
9: p_balance_value_tab_le_ytd pay_balance_pkg.t_balance_value_tab; /* Bug 4169557 */
10: p_context_table_run pay_balance_pkg.t_context_tab;
11: p_result_table_run pay_balance_pkg.t_detailed_bal_out_tab;
12:
13:
14:
15: ------------------------------------------------------------------------
393: */
394:
395: /* get the balances using BBR */
396:
397: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
398: p_defined_balance_lst=>p_balance_value_tab_run,
399: p_context_lst =>p_context_table_run,
400: p_output_table=>p_result_table_run);
401:
450: END IF
451: */
452: IF ( p_get_le_level_bal ='Y')
453: THEN
454: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
455: p_defined_balance_lst=> p_balance_value_tab_le_ytd,
456: p_context_lst =>p_context_table_run,
457: p_output_table=>p_result_table_run);
458:
464: p_balance_value_tab_ytd(csr_rec.sort_index).defined_balance_id := csr_rec.defined_balance_id;
465: END LOOP;
466:
467: /* fetch the ytd balances */
468: pay_balance_pkg.get_value(p_assignment_action_id => p_assignment_action_id,
469: p_defined_balance_lst=>p_balance_value_tab_ytd,
470: p_context_lst =>p_context_table_run,
471: p_output_table=>p_result_table_run);
472: