APPS.PAY_FR_GENERAL dependencies on HRUSERDT

Line 237: l_base_type := hruserdt.get_table_value(p_bus_group_id => p_business_group_id

233: begin
234: --
235: hr_utility.set_location('Entered '||l_proc,5);
236:
237: l_base_type := hruserdt.get_table_value(p_bus_group_id => p_business_group_id
238: ,p_table_name => 'FR_DEDUCTION_GROUPS'
239: ,p_col_name=> 'Base Balance'
240: ,p_row_value => p_group_code);
241:

Line 273: l_base_type := hruserdt.get_table_value(p_bus_group_id => p_business_group_id

269: hr_utility.set_location('Entered '||l_proc,5);
270: --
271: l_group_code := get_group_code(p_cu_id);
272: --
273: l_base_type := hruserdt.get_table_value(p_bus_group_id => p_business_group_id
274: ,p_table_name => 'FR_DEDUCTION_GROUPS'
275: ,p_col_name=> 'Base Balance'
276: ,p_row_value => l_group_code);
277:

Line 359: l_rate_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id

355: --
356: hr_utility.set_location('Entered '||l_proc,5);
357: hr_utility.set_location('. Rate Type='||p_rate_type,10);
358:
359: l_rate_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id
360: ,p_table_name => 'FR_CONTRIBUTION_RATES'
361: ,p_col_name=> 'Value (EUR)'
362: ,p_row_value => p_rate_type));
363:

Line 1042: l_band_low_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id

1038: begin
1039: hr_utility.set_location('Entered get_contribution_band, band_type= '||p_band_type,0);
1040: hr_utility.set_location('SS_ceiling_YTD: '||p_ytd_ss_ceiling||', ytd_base:'||p_ytd_base||', ytd_band: '||p_ytd_band,1);
1041:
1042: l_band_low_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id
1043: ,p_table_name => 'FR_CONTRIBUTION_BANDS'
1044: ,p_col_name=> 'LOW_VALUE'
1045: ,p_row_value => p_band_type));
1046: hr_utility.set_location('Low value found= '||l_band_low_value,4);

Line 1048: l_band_high_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id

1044: ,p_col_name=> 'LOW_VALUE'
1045: ,p_row_value => p_band_type));
1046: hr_utility.set_location('Low value found= '||l_band_low_value,4);
1047:
1048: l_band_high_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id
1049: ,p_table_name => 'FR_CONTRIBUTION_BANDS'
1050: ,p_col_name=> 'HIGH_VALUE'
1051: ,p_row_value => p_band_type));
1052: hr_utility.set_location('High value found= '||l_band_high_value,6);

Line 1132: l_low_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id

1128: --
1129: hr_utility.set_location('Entered fr_get_salary_tax_band, band_type= '||p_band_type,10);
1130: hr_utility.set_location('Base PTD='||p_ptd_base||', Band PTD='||p_ptd_band,15);
1131:
1132: l_low_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id
1133: ,p_table_name => 'FR_CONTRIBUTION_BANDS'
1134: ,p_col_name=> 'LOW_VALUE'
1135: ,p_row_value => p_band_type));
1136: l_high_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id

Line 1136: l_high_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id

1132: l_low_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id
1133: ,p_table_name => 'FR_CONTRIBUTION_BANDS'
1134: ,p_col_name=> 'LOW_VALUE'
1135: ,p_row_value => p_band_type));
1136: l_high_value := to_number(hruserdt.get_table_value(p_bus_group_id => p_business_group_id
1137: ,p_table_name => 'FR_CONTRIBUTION_BANDS'
1138: ,p_col_name=> 'HIGH_VALUE'
1139: ,p_row_value => p_band_type));
1140: hr_utility.set_location('low band='||l_low_value||', high_band='||l_high_value,20);

Line 1358: and 'Y' = hruserdt.get_table_value(p_business_group_id

1354: and pel2.element_type_id = pet2.element_type_id
1355: and paa.date_start between pet2.effective_start_date and pet2.effective_end_date
1356: and pet2.element_name = 'FR_PENSION'
1357: and pet2.legislation_code = 'FR'
1358: and 'Y' = hruserdt.get_table_value(p_business_group_id
1359: , 'FR_APEC_AGIRC', 'AGIRC'
1360: , pee2.entry_information1, paa.date_start);
1361:
1362: begin