APPS.PAY_SG_DEDUCTIONS dependencies on HRUSERDT

Line 230: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id

226: return(-66);
227: end if;
228: close c_check_permit_type;
229:
230: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
231: ,p_table_name => 'FWL_RATES'
232: ,p_col_name => 'Monthly Rate'
233: ,p_row_value => l_category
234: ,p_effective_date => p_date_earned ));

Line 315: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id

311: end if;
312:
313: else
314:
315: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
316: ,p_table_name => 'FWL_RATES'
317: ,p_col_name => 'Monthly Rate'
318: ,p_row_value => l_permit(i).permit_category
319: ,p_effective_date => p_date_earned ));

Line 464: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id

460: return(-66);
461: end if;
462: close c_check_permit_type;
463:
464: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
465: ,p_table_name => 'FWL_RATES'
466: ,p_col_name => 'Monthly Rate'
467: ,p_row_value => l_category
468: ,p_effective_date => p_date_earned ));

Line 549: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id

545: end if;
546:
547: else
548:
549: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
550: ,p_table_name => 'FWL_RATES'
551: ,p_col_name => 'Monthly Rate'
552: ,p_row_value => l_permit(i).permit_category
553: ,p_effective_date => p_date_earned ));