eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_NICAR_06042002 dependencies on FND_NUMBER

Line 739: l_fuel_scale := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,

735:
736:
737: hr_utility.trace('Engine size: '||p_engine_size);
738: hr_utility.trace('Session date: '||p_session_date);
739: l_fuel_scale := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,
740: 'FUEL_SCALE',
741: l_fuel_type,
742: p_engine_size,
743: p_session_date));

Line 1084: l_fuel_scale := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,

1080:
1081:
1082: hr_utility.trace('Engine size: '||p_engine_size);
1083: hr_utility.trace('Session date: '||p_session_date);
1084: l_fuel_scale := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,
1085: 'FUEL_SCALE',
1086: l_fuel_type,
1087: p_engine_size,
1088: p_session_date));

Line 1225: l_percentage := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,

1221:
1222: l_co2_emissions := p_co2_emissions;
1223:
1224: /* Get table value */
1225: l_percentage := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,
1226: 'GB_CO2_EMISSIONS',
1227: 'PERCENTAGE_CHARGE',
1228: l_co2_emissions,
1229: p_session_date));

Line 1297: l_percentage := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,

1293: end if;
1294:
1295: hr_utility.set_location(g_package_name||'.'||l_function_name,2);
1296:
1297: l_percentage := fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,
1298: 'GB_CC_SCALE',
1299: l_column_name,
1300: p_engine_size,
1301: p_session_date));

Line 1527: SELECT fnd_number.canonical_to_number(LIM.global_value)

1523:
1524: --
1525: --
1526: cursor csr1_globals is
1527: SELECT fnd_number.canonical_to_number(LIM.global_value)
1528: , fnd_number.canonical_to_number(NIR.global_value)
1529: FROM ff_globals_f LIM
1530: , ff_globals_f NIR
1531: WHERE LIM.global_name = 'NI_CAR_MAX_PRICE'

Line 1528: , fnd_number.canonical_to_number(NIR.global_value)

1524: --
1525: --
1526: cursor csr1_globals is
1527: SELECT fnd_number.canonical_to_number(LIM.global_value)
1528: , fnd_number.canonical_to_number(NIR.global_value)
1529: FROM ff_globals_f LIM
1530: , ff_globals_f NIR
1531: WHERE LIM.global_name = 'NI_CAR_MAX_PRICE'
1532: AND csr0_session_date between LIM.effective_start_date and LIM.effective_end_date

Line 1587: fnd_number.canonical_to_number(V.Screen_entry_value),null) ) csr3_price

1583: -- bug 504994 changed the entry cursor to use a single join on values table
1584: -- to improve performance
1585: select
1586: max(decode(V.input_value_id,csr2_pr,
1587: fnd_number.canonical_to_number(V.Screen_entry_value),null) ) csr3_price
1588: ,max(decode(V.input_value_id, csr2_mb,
1589: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_mileage_band
1590: ,max(decode(V.input_value_id,csr2_rd,
1591: fnd_date.canonical_to_date(V.Screen_entry_value),null)) csr3_reg_date

Line 1589: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_mileage_band

1585: select
1586: max(decode(V.input_value_id,csr2_pr,
1587: fnd_number.canonical_to_number(V.Screen_entry_value),null) ) csr3_price
1588: ,max(decode(V.input_value_id, csr2_mb,
1589: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_mileage_band
1590: ,max(decode(V.input_value_id,csr2_rd,
1591: fnd_date.canonical_to_date(V.Screen_entry_value),null)) csr3_reg_date
1592: ,max(decode(V.input_value_id,csr2_ft,
1593: V.Screen_entry_value,null)) csr3_fuel_type

Line 1595: fnd_number.canonical_to_number(v.Screen_entry_value),null)) csr3_engine_cc

1591: fnd_date.canonical_to_date(V.Screen_entry_value),null)) csr3_reg_date
1592: ,max(decode(V.input_value_id,csr2_ft,
1593: V.Screen_entry_value,null)) csr3_fuel_type
1594: ,max(decode(V.input_value_id,csr2_cc,
1595: fnd_number.canonical_to_number(v.Screen_entry_value),null)) csr3_engine_cc
1596: ,max(decode(V.input_value_id,csr2_fs,
1597: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale
1598: ,max(decode(V.input_value_id,csr2_ap,
1599: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment

Line 1597: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale

1593: V.Screen_entry_value,null)) csr3_fuel_type
1594: ,max(decode(V.input_value_id,csr2_cc,
1595: fnd_number.canonical_to_number(v.Screen_entry_value),null)) csr3_engine_cc
1596: ,max(decode(V.input_value_id,csr2_fs,
1597: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale
1598: ,max(decode(V.input_value_id,csr2_ap,
1599: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment
1600: ,max(decode(V.input_value_id,csr2_co2,
1601: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_co2

Line 1599: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment

1595: fnd_number.canonical_to_number(v.Screen_entry_value),null)) csr3_engine_cc
1596: ,max(decode(V.input_value_id,csr2_fs,
1597: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale
1598: ,max(decode(V.input_value_id,csr2_ap,
1599: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment
1600: ,max(decode(V.input_value_id,csr2_co2,
1601: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_co2
1602: ,EENT.effective_end_date csr3_end_date
1603: ,EENT.effective_start_date csr3_start_date

Line 1601: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_co2

1597: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale
1598: ,max(decode(V.input_value_id,csr2_ap,
1599: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment
1600: ,max(decode(V.input_value_id,csr2_co2,
1601: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_co2
1602: ,EENT.effective_end_date csr3_end_date
1603: ,EENT.effective_start_date csr3_start_date
1604:
1605: FROM pay_element_entries_f EENT