APPS.PQP_PENSION_FUNCTIONS dependencies on HRUSERDT

Line 248: hruserdt.get_table_value

244: IF l_subcat IS NOT NULL THEN
245:
246: BEGIN
247: p_column_value :=
248: hruserdt.get_table_value
249: (
250: p_bus_group_id => p_business_group_id
251: ,p_table_name => 'PQP_NL_ABP_EE_ANNUAL_SALARY_THRESHOLD'
252: ,p_col_name => l_subcat

Line 334: hruserdt.get_table_value

330: IF l_subcat IS NOT NULL THEN
331:
332: BEGIN
333: p_column_value :=
334: hruserdt.get_table_value
335: (
336: p_bus_group_id => p_business_group_id
337: ,p_table_name => 'PQP_NL_ABP_ER_ANNUAL_SALARY_THRESHOLD'
338: ,p_col_name => l_subcat

Line 2877: l_min_eoy_bonus_char := hruserdt.get_table_value

2873:
2874: -- We found a CAG at the asg level . Now get the Min End Of
2875: -- Year Bonus for this CAG from the UDT.
2876: Begin
2877: l_min_eoy_bonus_char := hruserdt.get_table_value
2878: (
2879: p_bus_group_id => p_business_group_id
2880: ,p_table_name => 'PQP_NL_MIN_END_OF_YEAR_BONUS'
2881: ,p_col_name => 'Minimum End Of Year Bonus'

Line 2960: l_min_holiday_char := hruserdt.get_table_value

2956: -- We found a CAG at the asg level . Now get the Min holiday
2957: -- allowance for this CAG from the UDT.
2958: Begin
2959: IF l_run_year < 2011 THEN --10421413
2960: l_min_holiday_char := hruserdt.get_table_value
2961: (
2962: p_bus_group_id => p_business_group_id
2963: ,p_table_name => 'PQP_NL_MIN_HOLIDAY_ALLOWANCE'
2964: ,p_col_name => 'Minimum Holiday Allowance'

Line 2970: l_min_holiday_char := hruserdt.get_table_value

2966: ,p_effective_date => l_effective_date
2967: );
2968: --10421413
2969: ELSE
2970: l_min_holiday_char := hruserdt.get_table_value
2971: (
2972: p_bus_group_id => p_business_group_id
2973: ,p_table_name => 'PQP_NL_AGE_MIN_HOLIDAY_ALLOWANCE'
2974: ,p_col_name => l_cag_name