584: p_lcld_limit IN OUT NOCOPY NUMBER,
585: p_error_msg IN OUT NOCOPY VARCHAR2)
586: RETURN NUMBER IS
587:
588: l_current_year number := fnd_number.canonical_to_number(to_char(p_date_earned,'YYYY'));
589: l_num_saved_yrs number := p_num_saved_yrs;
590: l_lcld_limit number := 0;
591: l_gbl_value number := 0;
592: l_gbl_value_temp ff_globals_f.GLOBAL_VALUE%TYPE;
610: Cursor c_gbl_value(p_year number) is
611: select GLOBAL_VALUE from ff_globals_f
612: where global_name = 'PAY_NL_MAX_LCLD_PER_YEAR'
613: and legislation_code = 'NL'
614: and p_year between fnd_number.canonical_to_number(to_char(EFFECTIVE_START_DATE,'YYYY'))
615: and fnd_number.canonical_to_number(to_char(EFFECTIVE_END_DATE,'YYYY'));
616:
617: CURSOR csr_get_def_bal_type_id
618: (c_balance_name VARCHAR2
611: select GLOBAL_VALUE from ff_globals_f
612: where global_name = 'PAY_NL_MAX_LCLD_PER_YEAR'
613: and legislation_code = 'NL'
614: and p_year between fnd_number.canonical_to_number(to_char(EFFECTIVE_START_DATE,'YYYY'))
615: and fnd_number.canonical_to_number(to_char(EFFECTIVE_END_DATE,'YYYY'));
616:
617: CURSOR csr_get_def_bal_type_id
618: (c_balance_name VARCHAR2
619: ,c_dimension_name VARCHAR2) IS
644: close c_gbl_value;
645:
646: hr_utility.set_location('l_gbl_value_temp: '||l_gbl_value_temp, 1200);
647:
648: l_gbl_value := fnd_number.canonical_to_number(l_gbl_value_temp);
649:
650: hr_utility.set_location('l_gbl_value: '||l_gbl_value, 800);
651:
652: l_lcld_limit := p_num_saved_yrs * l_gbl_value;