APPS.PER_FR_D2_PKG dependencies on HRUSERDT

Line 131: fnd_number.canonical_to_number(hruserdt.get_table_value

127: from hr_all_organization_units
128: where organization_id = p_establishment_id;
129: --
130: percent_disabled_obligation :=
131: fnd_number.canonical_to_number(hruserdt.get_table_value
132: (l_business_group_id,
133: 'FR_D2_RATES',
134: 'VALUE',
135: 'PERCENT_OBLIGATION'

Line 296: l_emp_cat := hruserdt.get_table_value (p_business_group_id,

292: else
293: begin -- first get employment category for this assignment
294: --Bug #4183533
295: if p_block.asg_type = 'C' then
296: l_emp_cat := hruserdt.get_table_value (p_business_group_id,
297: 'CWK_ASG_CATEGORY', 'FR_D2_CATEGORY',
298: p_block.asg_employment_category, p_block.block_start_date);
299: else
300: l_emp_cat := hruserdt.get_table_value (p_business_group_id,

Line 300: l_emp_cat := hruserdt.get_table_value (p_business_group_id,

296: l_emp_cat := hruserdt.get_table_value (p_business_group_id,
297: 'CWK_ASG_CATEGORY', 'FR_D2_CATEGORY',
298: p_block.asg_employment_category, p_block.block_start_date);
299: else
300: l_emp_cat := hruserdt.get_table_value (p_business_group_id,
301: 'EMP_CAT', 'FR_D2_CATEGORY',
302: p_block.asg_employment_category, p_block.block_start_date);
303: end if;
304: -- Bug #4183533

Line 312: l_daily_hours := hruserdt.get_table_value(p_business_group_id,

308: end;
309: end if;
310: --
311: begin -- now get legal values
312: l_daily_hours := hruserdt.get_table_value(p_business_group_id,
313: 'FR_LEGISLATIVE_RATES','VALUE','DAILY_HOURS',
314: p_block.block_start_date);
315: l_weekly_hours := hruserdt.get_table_value(p_business_group_id,
316: 'FR_LEGISLATIVE_RATES','VALUE','WEEKLY_HOURS',

Line 315: l_weekly_hours := hruserdt.get_table_value(p_business_group_id,

311: begin -- now get legal values
312: l_daily_hours := hruserdt.get_table_value(p_business_group_id,
313: 'FR_LEGISLATIVE_RATES','VALUE','DAILY_HOURS',
314: p_block.block_start_date);
315: l_weekly_hours := hruserdt.get_table_value(p_business_group_id,
316: 'FR_LEGISLATIVE_RATES','VALUE','WEEKLY_HOURS',
317: p_block.block_start_date);
318: l_monthly_hours := hruserdt.get_table_value(p_business_group_id,
319: 'FR_LEGISLATIVE_RATES','VALUE','MONTHLY_HOURS',

Line 318: l_monthly_hours := hruserdt.get_table_value(p_business_group_id,

314: p_block.block_start_date);
315: l_weekly_hours := hruserdt.get_table_value(p_business_group_id,
316: 'FR_LEGISLATIVE_RATES','VALUE','WEEKLY_HOURS',
317: p_block.block_start_date);
318: l_monthly_hours := hruserdt.get_table_value(p_business_group_id,
319: 'FR_LEGISLATIVE_RATES','VALUE','MONTHLY_HOURS',
320: p_block.block_start_date);
321: exception
322: when others then

Line 730: l_pcs_particular := hruserdt.get_table_value (p_business_group_id,

726: hr_utility.set_location('update_particular pcs_code='||l_pcs_code_text,10);
727: --
728: --
729: Begin
730: l_pcs_particular := hruserdt.get_table_value (p_business_group_id,
731: 'FR_PCS_CODE', 'FR_D2_PARTICULAR', l_pcs_code_text, p_31dec);
732: exception
733: when no_data_found then
734: l_pcs_particular := 'N';

Line 739: l_pcs_particular := hruserdt.get_table_value (p_business_group_id,

735: end;
736:
737: Begin
738: IF l_pcs_particular = 'N' THEN
739: l_pcs_particular := hruserdt.get_table_value (p_business_group_id,
740: 'FR_NEW_PCS_CODE', 'FR_D2_PARTICULAR', l_pcs_code_text, p_31dec);
741: END IF;
742: Exception
743: When no_data_found then

Line 972: if hruserdt.get_table_value(p_business_group_id

968: while l_start_pos <= length(p_user_person_types) loop
969: l_end_pos := instr(p_user_person_types||l_ptu_delim,
970: l_ptu_delim,l_start_pos);
971: begin
972: if hruserdt.get_table_value(p_business_group_id
973: ,'FR_USER_PERSON_TYPE', 'INCLUDE_D2'
974: ,substr(p_user_person_types,l_start_pos,
975: l_end_pos-l_start_pos)
976: ,p_effective_date) = 'Y'