APPS.PAY_SG_DEDUCTIONS dependencies on HRUSERDT

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

208: return(-66);
209: end if;
210: close c_check_permit_type;
211:
212: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
213: ,p_table_name => 'FWL_RATES'
214: ,p_col_name => 'Monthly Rate'
215: ,p_row_value => l_category
216: ,p_effective_date => p_date_earned ));

Line 218: l_dly_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id

214: ,p_col_name => 'Monthly Rate'
215: ,p_row_value => l_category
216: ,p_effective_date => p_date_earned ));
217:
218: l_dly_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
219: ,p_table_name => 'FWL_RATES'
220: ,p_col_name => 'Daily Rate'
221: ,p_row_value => l_category
222: ,p_effective_date => p_date_earned ));

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

291: end if;
292:
293: else
294:
295: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
296: ,p_table_name => 'FWL_RATES'
297: ,p_col_name => 'Monthly Rate'
298: ,p_row_value => l_permit(i).permit_category
299: ,p_effective_date => p_date_earned ));

Line 301: l_dly_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id

297: ,p_col_name => 'Monthly Rate'
298: ,p_row_value => l_permit(i).permit_category
299: ,p_effective_date => p_date_earned ));
300:
301: l_dly_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
302: ,p_table_name => 'FWL_RATES'
303: ,p_col_name => 'Daily Rate'
304: ,p_row_value => l_permit(i).permit_category
305: ,p_effective_date => p_date_earned ));

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

408: l_max_days := least (nvl(l_permit(l_permit.last).date_end, l_eot), nvl(l_permit(l_permit.last).date_cancel, l_eot)) - p_start_date + 1;
409: l_category := 'SP';
410: if l_category is not null then
411:
412: l_mth_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
413: ,p_table_name => 'FWL_RATES'
414: ,p_col_name => 'Monthly Rate'
415: ,p_row_value => l_category
416: ,p_effective_date => p_date_earned ));

Line 418: l_dly_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id

414: ,p_col_name => 'Monthly Rate'
415: ,p_row_value => l_category
416: ,p_effective_date => p_date_earned ));
417:
418: l_dly_amt := to_number(hruserdt.get_table_value (p_bus_group_id => p_business_group_id
419: ,p_table_name => 'FWL_RATES'
420: ,p_col_name => 'Daily Rate'
421: ,p_row_value => l_category
422: ,p_effective_date => p_date_earned ));