DBA Data[Home] [Help]

APPS.PQP_PENSION_FUNCTIONS dependencies on HRUSERDT

Line 206: hruserdt.get_table_value

202: IF l_subcat IS NOT NULL THEN
203:
204: BEGIN
205: p_column_value :=
206: hruserdt.get_table_value
207: (
208: p_bus_group_id => p_business_group_id
209: ,p_table_name => 'PQP_NL_ABP_EE_ANNUAL_SALARY_THRESHOLD'
210: ,p_col_name => l_subcat

Line 292: hruserdt.get_table_value

288: IF l_subcat IS NOT NULL THEN
289:
290: BEGIN
291: p_column_value :=
292: hruserdt.get_table_value
293: (
294: p_bus_group_id => p_business_group_id
295: ,p_table_name => 'PQP_NL_ABP_ER_ANNUAL_SALARY_THRESHOLD'
296: ,p_col_name => l_subcat

Line 2802: l_min_eoy_bonus_char := hruserdt.get_table_value

2798:
2799: -- We found a CAG at the asg level . Now get the Min End Of
2800: -- Year Bonus for this CAG from the UDT.
2801: Begin
2802: l_min_eoy_bonus_char := hruserdt.get_table_value
2803: (
2804: p_bus_group_id => p_business_group_id
2805: ,p_table_name => 'PQP_NL_MIN_END_OF_YEAR_BONUS'
2806: ,p_col_name => 'Minimum End Of Year Bonus'

Line 2875: l_min_holiday_char := hruserdt.get_table_value

2871:
2872: -- We found a CAG at the asg level . Now get the Min holiday
2873: -- allowance for this CAG from the UDT.
2874: Begin
2875: l_min_holiday_char := hruserdt.get_table_value
2876: (
2877: p_bus_group_id => p_business_group_id
2878: ,p_table_name => 'PQP_NL_MIN_HOLIDAY_ALLOWANCE'
2879: ,p_col_name => 'Minimum Holiday Allowance'