[Home] [Help]
1735:
1736: begin
1737: --
1738: -- The NI Total for each category has already been established, so the NI Total for
1739: -- all categories is the sum of the NI Total for each individual category
1740: --
1741: l_employer_balance := g_ni_a_total_value + g_ni_b_total_value + g_ni_d_total_value
1742: + g_ni_e_total_value + g_ni_f_total_value + g_ni_g_total_value
1743: + g_ni_j_total_value + g_ni_l_total_value + g_ni_s_total_value;
1976: g_ni_s_total_value := 0;
1977:
1978: --
1979: -- establish the total NI balance for each category. This is done now to
1980: -- cut down on processing when individual NI balances are retrieved later.
1981: --
1982: IF HR_GBBAL.NI_CATEGORY_EXISTS_IN_YEAR(p_assignment_action_id,'A') = 1 THEN
1983: g_ni_a_total_value := report_balance_items
1984: (p_balance_name => g_ni_a_total_type,
2321: p_run_assignment_action_id in out nocopy number,
2322: p_assignment_id in number,
2323: p_payroll_action_id in out nocopy number,
2324: p_date_earned in out nocopy varchar2) is
2325: -- select the latest prepayments action for this individual and get the
2326: -- details of the last run that that action locked
2327: cursor csr_formula is
2328: select /*+ ORDERED USE_NL(paa,ppa,rpaa,rppa) */
2329: to_char(nvl(rppa.date_earned,rppa.effective_date),'YYYY/MM/DD'),
2683: fetch c_find_table_id into l_user_table_id;
2684: close c_find_table_id;
2685:
2686: select pay_user_rows_s.nextval into l_user_row_id
2687: from dual;
2688:
2689: if p_business_group_id is null
2690: then
2691: l_legislation_code := 'GB';