DBA Data[Home] [Help]

APPS.PQP_GB_PSI_SCH dependencies on HRUSERDT

Line 458: l_old_percentage := hruserdt.get_table_value (p_bus_group_id =>g_business_group_id, p_table_name => p_user_table_name,

454: BEGIN
455: debug('start of get_cont_percentage_change');
456: debug('p_user_table_name:'||p_user_table_name);
457: debug('p_user_table_column:'||p_user_table_column);
458: l_old_percentage := hruserdt.get_table_value (p_bus_group_id =>g_business_group_id, p_table_name => p_user_table_name,
459: p_col_name => p_user_table_column, p_row_value => p_old_value, p_effective_date => l_effective_start_date);
460: l_new_percentage := hruserdt.get_table_value (p_bus_group_id =>g_business_group_id, p_table_name =>p_user_table_name,
461: p_col_name =>p_user_table_column, p_row_value =>p_new_value, p_effective_date =>l_effective_start_date);
462: debug('old percentage is:'||l_old_percentage);

Line 460: l_new_percentage := hruserdt.get_table_value (p_bus_group_id =>g_business_group_id, p_table_name =>p_user_table_name,

456: debug('p_user_table_name:'||p_user_table_name);
457: debug('p_user_table_column:'||p_user_table_column);
458: l_old_percentage := hruserdt.get_table_value (p_bus_group_id =>g_business_group_id, p_table_name => p_user_table_name,
459: p_col_name => p_user_table_column, p_row_value => p_old_value, p_effective_date => l_effective_start_date);
460: l_new_percentage := hruserdt.get_table_value (p_bus_group_id =>g_business_group_id, p_table_name =>p_user_table_name,
461: p_col_name =>p_user_table_column, p_row_value =>p_new_value, p_effective_date =>l_effective_start_date);
462: debug('old percentage is:'||l_old_percentage);
463: debug('new percentage is:'||l_new_percentage);
464: debug('p_per_change:'||p_per_change);