[Home] [Help]
353: --thresholds has a row for the person's age, then return this value
354: BEGIN
355: hr_utility.set_location('Checking for threshold percentage for age : '||p_person_age,20);
356: l_return_value :=
357: hruserdt.get_table_value
358: (
359: p_bus_group_id => p_business_group_id
360: ,p_table_name => 'PQP_NL_PGGM_AGE_DEPENDANT_THRESHOLD'
361: ,p_col_name => 'Percentage Of Maximum Threshold'
394: IF p_person_age > l_max_age THEN
395:
396: BEGIN
397: l_return_value :=
398: hruserdt.get_table_value
399: (
400: p_bus_group_id => p_business_group_id
401: ,p_table_name => 'PQP_NL_PGGM_AGE_DEPENDANT_THRESHOLD'
402: ,p_col_name => 'Percentage Of Maximum Threshold'
1554: -- We found a CAG at the asg level . Now get the Min End Of
1555: -- Year Bonus for this CAG from the UDT.
1556: hr_utility.set_location('CAG attached to the asg : '||l_cag_name,150);
1557: BEGIN
1558: l_min_eoy_bonus_char := hruserdt.get_table_value
1559: (
1560: p_bus_group_id => p_business_group_id
1561: ,p_table_name => 'PQP_NL_MIN_END_OF_YEAR_BONUS'
1562: ,p_col_name => 'PGGM Minimum End Of Year Bonus'
1581:
1582: -- We found a CAG at the asg level . Now get the Min holiday
1583: -- allowance for this CAG from the UDT.
1584: BEGIN
1585: l_min_age_holiday_allow:= hruserdt.get_table_value
1586: (
1587: p_bus_group_id => p_business_group_id
1588: ,p_table_name => 'PQP_NL_MIN_HOLIDAY_ALLOWANCE'
1589: ,p_col_name => 'PGGM Min Age for Holiday Allowance'
1603: p_err_message2 :=p_err_message2|| 'Min. holiday allowance is set to 0 as'
1604: ||'person age is less than min age defined at collective agreement ';
1605: l_ret_val := 2;
1606: ELSE
1607: l_min_holiday_char := hruserdt.get_table_value
1608: (
1609: p_bus_group_id => p_business_group_id
1610: ,p_table_name => 'PQP_NL_MIN_HOLIDAY_ALLOWANCE'
1611: ,p_col_name => 'PGGM Minimum Holiday Allowance'