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.HR_GBNICAR dependencies on FND_NUMBER

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

52: v_running_total number :=0;
53: --
54: --
55: cursor csr1_globals is
56: SELECT fnd_number.canonical_to_number(LIM.global_value)
57: , fnd_number.canonical_to_number(NIR.global_value)
58: FROM ff_globals_f LIM
59: , ff_globals_f NIR
60: WHERE LIM.global_name = 'NI_CAR_MAX_PRICE'

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

53: --
54: --
55: cursor csr1_globals is
56: SELECT fnd_number.canonical_to_number(LIM.global_value)
57: , fnd_number.canonical_to_number(NIR.global_value)
58: FROM ff_globals_f LIM
59: , ff_globals_f NIR
60: WHERE LIM.global_name = 'NI_CAR_MAX_PRICE'
61: AND csr0_session_date between LIM.effective_start_date and LIM.effective_end_date

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

108: -- bug 504994 changed the entry cursor to use a single join on values table
109: -- to improve performance
110: select
111: max(decode(V.input_value_id,csr2_pr,
112: fnd_number.canonical_to_number(V.Screen_entry_value),null) ) csr3_price
113: ,max(decode(V.input_value_id, csr2_mb,
114: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_mileage_band
115: ,max(decode(V.input_value_id,csr2_rd,
116: fnd_date.canonical_to_date(V.Screen_entry_value),null)) csr3_reg_date

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

110: select
111: max(decode(V.input_value_id,csr2_pr,
112: fnd_number.canonical_to_number(V.Screen_entry_value),null) ) csr3_price
113: ,max(decode(V.input_value_id, csr2_mb,
114: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_mileage_band
115: ,max(decode(V.input_value_id,csr2_rd,
116: fnd_date.canonical_to_date(V.Screen_entry_value),null)) csr3_reg_date
117: ,max(decode(V.input_value_id,csr2_ft,
118: V.Screen_entry_value,null)) csr3_fuel_type

Line 120: nvl(fnd_number.canonical_to_number(v.Screen_entry_value),0),null)) csr3_engine_cc

116: fnd_date.canonical_to_date(V.Screen_entry_value),null)) csr3_reg_date
117: ,max(decode(V.input_value_id,csr2_ft,
118: V.Screen_entry_value,null)) csr3_fuel_type
119: ,max(decode(V.input_value_id,csr2_cc,
120: nvl(fnd_number.canonical_to_number(v.Screen_entry_value),0),null)) csr3_engine_cc
121: ,max(decode(V.input_value_id,csr2_fs,
122: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale
123: ,max(decode(V.input_value_id,csr2_ap,
124: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment

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

118: V.Screen_entry_value,null)) csr3_fuel_type
119: ,max(decode(V.input_value_id,csr2_cc,
120: nvl(fnd_number.canonical_to_number(v.Screen_entry_value),0),null)) csr3_engine_cc
121: ,max(decode(V.input_value_id,csr2_fs,
122: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale
123: ,max(decode(V.input_value_id,csr2_ap,
124: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment
125: ,EENT.effective_end_date csr3_end_date
126: ,EENT.effective_start_date csr3_start_date

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

120: nvl(fnd_number.canonical_to_number(v.Screen_entry_value),0),null)) csr3_engine_cc
121: ,max(decode(V.input_value_id,csr2_fs,
122: fnd_number.canonical_to_number(V.Screen_entry_value),null)) csr3_fuel_scale
123: ,max(decode(V.input_value_id,csr2_ap,
124: nvl(fnd_number.canonical_to_number(V.Screen_entry_value),0),null)) csr3_payment
125: ,EENT.effective_end_date csr3_end_date
126: ,EENT.effective_start_date csr3_start_date
127: FROM pay_element_entries_f EENT
128: , pay_element_links_f LINK

Line 233: fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,

229: then
230: v_fuel_scale := 0;
231: else
232: v_fuel_scale :=
233: fnd_number.canonical_to_number(hruserdt.get_table_value(p_business_group_id,
234: 'FUEL_SCALE',
235: csr3_fuel_type,
236: csr3_engine_cc,
237: csr0_session_date));

Line 504: nvl(fnd_number.canonical_to_number(V.screen_entry_value),0),null)) Payment

500: cursor c1_nicar_payment is
501: -- bug 504994 changed the entry cursor to use a single join on values table
502: -- to improve performance
503: SELECT max(decode(I.name,'Payment',
504: nvl(fnd_number.canonical_to_number(V.screen_entry_value),0),null)) Payment
505: , max(decode(I.name,'Price',
506: fnd_number.canonical_to_number(V.screen_entry_value),null)) Price
507: , EENT.effective_end_date
508: , EENT.effective_start_date

Line 506: fnd_number.canonical_to_number(V.screen_entry_value),null)) Price

502: -- to improve performance
503: SELECT max(decode(I.name,'Payment',
504: nvl(fnd_number.canonical_to_number(V.screen_entry_value),0),null)) Payment
505: , max(decode(I.name,'Price',
506: fnd_number.canonical_to_number(V.screen_entry_value),null)) Price
507: , EENT.effective_end_date
508: , EENT.effective_start_date
509: FROM pay_element_entries_f EENT
510: , pay_element_links_f LINK