APPS.PQP_NL_PGGM_FUNCTIONS dependencies on HRUSERDT

Line 385: hruserdt.get_table_value

381: --thresholds has a row for the person's age, then return this value
382: BEGIN
383: hr_utility.set_location('Checking for threshold percentage for age : '||p_person_age,200);
384: l_return_value :=
385: hruserdt.get_table_value
386: (
387: p_bus_group_id => p_business_group_id
388: ,p_table_name => 'PQP_NL_PGGM_AGE_DEPENDANT_THRESHOLD_CUSTOM'
389: ,p_col_name => 'Percentage Of Maximum Threshold'

Line 426: hruserdt.get_table_value

422: IF p_person_age > l_max_age THEN
423:
424: BEGIN
425: l_return_value :=
426: hruserdt.get_table_value
427: (
428: p_bus_group_id => p_business_group_id
429: ,p_table_name => 'PQP_NL_PGGM_AGE_DEPENDANT_THRESHOLD_CUSTOM'
430: ,p_col_name => 'Percentage Of Maximum Threshold'

Line 471: hruserdt.get_table_value

467: --thresholds has a row for the person's age, then return this value
468: BEGIN
469: hr_utility.set_location('Checking for threshold percentage for age : '||p_person_age,20);
470: l_return_value :=
471: hruserdt.get_table_value
472: (
473: p_bus_group_id => p_business_group_id
474: ,p_table_name => 'PQP_NL_PGGM_AGE_DEPENDANT_THRESHOLD'
475: ,p_col_name => 'Percentage Of Maximum Threshold'

Line 512: hruserdt.get_table_value

508: IF p_person_age > l_max_age THEN
509:
510: BEGIN
511: l_return_value :=
512: hruserdt.get_table_value
513: (
514: p_bus_group_id => p_business_group_id
515: ,p_table_name => 'PQP_NL_PGGM_AGE_DEPENDANT_THRESHOLD'
516: ,p_col_name => 'Percentage Of Maximum Threshold'

Line 1712: l_min_eoy_bonus_char := hruserdt.get_table_value

1708: -- We found a CAG at the asg level . Now get the Min End Of
1709: -- Year Bonus for this CAG from the UDT.
1710: hr_utility.set_location('CAG attached to the asg : '||l_cag_name,150);
1711: BEGIN
1712: l_min_eoy_bonus_char := hruserdt.get_table_value
1713: (
1714: p_bus_group_id => p_business_group_id
1715: ,p_table_name => 'PQP_NL_MIN_END_OF_YEAR_BONUS'
1716: ,p_col_name => 'PGGM Minimum End Of Year Bonus'

Line 1739: l_min_age_holiday_allow:= hruserdt.get_table_value

1735:
1736: -- We found a CAG at the asg level . Now get the Min holiday
1737: -- allowance for this CAG from the UDT.
1738: BEGIN
1739: l_min_age_holiday_allow:= hruserdt.get_table_value
1740: (
1741: p_bus_group_id => p_business_group_id
1742: ,p_table_name => 'PQP_NL_MIN_HOLIDAY_ALLOWANCE'
1743: ,p_col_name => 'PGGM Min Age for Holiday Allowance'

Line 1761: l_min_holiday_char := hruserdt.get_table_value

1757: p_err_message2 :=p_err_message2|| 'Min. holiday allowance is set to 0 as'
1758: ||'person age is less than min age defined at collective agreement ';
1759: l_ret_val := 2;
1760: ELSE
1761: l_min_holiday_char := hruserdt.get_table_value
1762: (
1763: p_bus_group_id => p_business_group_id
1764: ,p_table_name => 'PQP_NL_MIN_HOLIDAY_ALLOWANCE'
1765: ,p_col_name => 'PGGM Minimum Holiday Allowance'