APPS.PQP_RATES_HISTORY_CALC dependencies on HRUSERDT

Line 820: hruserdt.get_table_value

816:
817: -- Get the factor value from the contracts table
818: BEGIN
819: l_contract_factor := fnd_number.canonical_to_number(
820: hruserdt.get_table_value
821: (p_bus_group_id => p_business_group_id
822: ,p_table_name => c_contract_table_name
823: ,p_col_name => l_column_name
824: ,p_row_value => p_contract_type

Line 1099: fnd_number.canonical_to_number( hruserdt.get_table_value

1095: -- BUG 3454641
1096: BEGIN
1097:
1098: l_annual_term_time_hours :=
1099: fnd_number.canonical_to_number( hruserdt.get_table_value
1100: (p_bus_group_id => l_business_group_id
1101: ,p_table_name => c_contract_table_name
1102: ,p_col_name => 'ANNUAL TERM TIME HOURS'
1103: ,p_row_value => l_contract_type

Line 1129: fnd_number.canonical_to_number( hruserdt.get_table_value

1125: -- BUG 3454641
1126:
1127: BEGIN
1128: l_annual_hours :=
1129: fnd_number.canonical_to_number( hruserdt.get_table_value
1130: (p_bus_group_id => l_business_group_id
1131: ,p_table_name => c_contract_table_name
1132: ,p_col_name => 'ANNUAL HOURS'
1133: ,p_row_value => l_contract_type

Line 1551: BEGIN -- wrapping the hruserdt.get_table_value call

1547: debug('p_row_value:'||p_row_value);
1548: debug('p_effective_date:'||fnd_date.date_to_canonical(p_effective_date));
1549: END IF;
1550:
1551: BEGIN -- wrapping the hruserdt.get_table_value call
1552:
1553: l_value :=
1554: TO_NUMBER
1555: (hruserdt.get_table_value

Line 1555: (hruserdt.get_table_value

1551: BEGIN -- wrapping the hruserdt.get_table_value call
1552:
1553: l_value :=
1554: TO_NUMBER
1555: (hruserdt.get_table_value
1556: (p_bus_group_id => p_business_group_id
1557: ,p_table_name => p_table_name
1558: ,p_col_name => p_column_name
1559: ,p_row_value => p_row_value