[Home] [Help]
329: and pbd.legislation_code ='KR'
330: and pbt.balance_type_id =pdb.balance_type_id
331: and pbd.balance_dimension_id =pdb.balance_dimension_id ;
332:
333: /* Bug 4199014: Performance update - Removed check for balance value (call to PAY_BALANCE_PKG.GET_VALUE)
334: from the WHERE clause. Changed the SELECT clause, added extra WHERE predicate
335: (PAA.ACTION_STATUS).
336: */
337: cursor csr_hi_no_of_mths_prem_paid(p_assact_id pay_assignment_actions.assignment_action_id%type ,
477: exit when l_each_row is null ;
478: if l_ppa_mth_tbl(l_each_row) = l_last_month_found then
479: -- This month has already been included in l_no_mths_prem_paid; do nothing
480: null ;
481: elsif pay_balance_pkg.get_value(g_dbl_id_hi_prem, l_assact_tbl(l_each_row) ) > 0 then
482: l_last_month_found := l_ppa_mth_tbl(l_each_row) ; -- Now this is the latest month accounted for
483: l_no_mths_prem_paid := l_no_mths_prem_paid + 1 ;
484: end if ;
485: l_each_row := l_assact_tbl.next(l_each_row) ;
497: raise no_data_found;
498: end if;
499: close csr_get_dbl_id;
500:
501: l_arch_tab(8).value := pay_balance_pkg.get_value(l_defined_balance_id, l_last_year_assignment_action);
502: --
503: open csr_get_dbl_id('EARNINGS_SUBJ_HI', '_ASG_YTD');
504: fetch csr_get_dbl_id into l_defined_balance_id;
505: if csr_get_dbl_id%notfound then
506: raise no_data_found;
507: end if;
508: close csr_get_dbl_id;
509:
510: l_arch_tab(9).value := pay_balance_pkg.get_value(l_defined_balance_id, l_last_year_assignment_action);
511: --
512: l_arch_tab(10).value := pay_balance_pkg.run_db_item('HI_WORKING_MONTHS', null, 'KR');
513: --
514: --End of changes for Bug 3438946
508: close csr_get_dbl_id;
509:
510: l_arch_tab(9).value := pay_balance_pkg.get_value(l_defined_balance_id, l_last_year_assignment_action);
511: --
512: l_arch_tab(10).value := pay_balance_pkg.run_db_item('HI_WORKING_MONTHS', null, 'KR');
513: --
514: --End of changes for Bug 3438946
515: --------------------------------------------------------------
516: if g_debug then