[Home] [Help]
1756:
1757: begin
1758: --
1759: -- The NI Total for each category has already been established, so the NI Total for
1760: -- all categories is the sum of the NI Total for each individual category
1761: --
1762: l_employer_balance := g_ni_a_total_value + g_ni_b_total_value + g_ni_d_total_value
1763: + g_ni_e_total_value + g_ni_f_total_value + g_ni_g_total_value
1764: + g_ni_j_total_value + g_ni_l_total_value + g_ni_s_total_value;
2001: g_ni_s_total_value := 0;
2002:
2003: --
2004: -- establish the total NI balance for each category. This is done now to
2005: -- cut down on processing when individual NI balances are retrieved later.
2006: --
2007: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
2008: g_ni_a_total_value := report_balance_items
2009: (p_balance_name => g_ni_a_total_type,
2435: g_ni_s_total_value := 0;
2436:
2437: --
2438: -- establish the total NI balance for each category. This is done now to
2439: -- cut down on processing when individual NI balances are retrieved later.
2440: --
2441: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
2442: g_ni_a_total_value := report_balance_items
2443: (p_balance_name => g_ni_a_total_type,
2722: p_run_assignment_action_id in out nocopy number,
2723: p_assignment_id in number,
2724: p_payroll_action_id in out nocopy number,
2725: p_date_earned in out nocopy varchar2) is
2726: -- select the latest prepayments action for this individual and get the
2727: -- details of the last run that that action locked
2728: cursor csr_formula is
2729: select /*+ ORDERED USE_NL(paa,ppa,rpaa,rppa) */
2730: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
3084: fetch c_find_table_id into l_user_table_id;
3085: close c_find_table_id;
3086:
3087: select pay_user_rows_s.nextval into l_user_row_id
3088: from dual;
3089:
3090: if p_business_group_id is null
3091: then
3092: l_legislation_code := 'GB';