APPS.HR_CA_FF_UDFS dependencies on FND_NUMBER

Line 312: v_ws_id := fnd_number.canonical_to_number(p_wsched);

308: hr_utility.set_location('Prorate_Earnings', 17);
309:
310: -- Get work schedule name:
311: -- v_ws_id := to_number(p_wsched);
312: v_ws_id := fnd_number.canonical_to_number(p_wsched);
313:
314: SELECT user_column_name
315: INTO v_ws_name
316: FROM pay_user_columns

Line 901: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);

897: -- Find hours worked between period start and end dates.
898: --
899:
900: -- v_ws_id := to_number(p_work_schedule);
901: v_ws_id := fnd_number.canonical_to_number(p_work_schedule);
902:
903: --
904: SELECT user_column_name
905: INTO v_work_sched_name

Line 2132: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);

2128: -- Hourly employee using work schedule.
2129: -- Get work schedule name
2130:
2131: -- v_ws_id := to_number(p_asg_work_sched);
2132: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2133:
2134: SELECT user_column_name
2135: INTO v_work_sched_name
2136: FROM pay_user_columns

Line 2321: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);

2317: -- Hourly emp using work schedule.
2318: -- Get work schedule name:
2319:
2320: -- v_ws_id := to_number(p_asg_work_sched);
2321: v_ws_id := fnd_number.canonical_to_number(p_asg_work_sched);
2322:
2323: SELECT user_column_name
2324: INTO v_work_sched_name
2325: FROM pay_user_columns

Line 2594: fnd_number.canonical_to_number(hruserdt.get_table_value(p_bg_id,

2590:
2591: --
2592: hr_utility.set_location('work_schedule_total_hours.gettabval', 25);
2593: v_total_hours := v_total_hours +
2594: fnd_number.canonical_to_number(hruserdt.get_table_value(p_bg_id,
2595: c_ws_tab_name,
2596: v_ws_name,
2597: v_curr_day));
2598: v_curr_date := v_curr_date + 1;

Line 3177: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),

3173: --
3174: -- local cursors
3175: --
3176: CURSOR get_tew_rate IS
3177: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3178: EEV.element_entry_id
3179: FROM pay_element_entry_values_f EEV,
3180: pay_element_entries_f ELE,
3181: pay_input_values_f IPV

Line 3229: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

3225: /* Cursors get_flat_amounts, get_rates and get_percentage have been changed
3226: to improve performance.
3227: */
3228: CURSOR get_flat_amounts IS
3229: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3230: FROM pay_element_links_f pel,
3231: pay_element_entries_f ele,
3232: pay_element_entry_values_f eev,
3233: pay_input_values_f ipv

Line 3247: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),

3243: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3244: AND IPV.name = 'Amount';
3245: --
3246: CURSOR get_rates IS
3247: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value),
3248: EEV.element_entry_id
3249: FROM pay_element_links_f pel,
3250: pay_element_entries_f ele,
3251: pay_element_entry_values_f eev,

Line 3266: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)

3262: AND IPV.element_type_id = pel.element_type_id --v_eletype_id
3263: AND IPV.name = 'Rate';
3264: --
3265: CURSOR get_percentages IS
3266: SELECT fnd_number.canonical_to_number(EEV.screen_entry_value)
3267: FROM pay_element_links_f pel,
3268: pay_element_entries_f ele,
3269: pay_element_entry_values_f eev,
3270: pay_input_values_f ipv

Line 3342: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(

3338: FETCH cur_element_type_id
3339: INTO l_time_entry_ele_id;
3340: CLOSE cur_element_type_id;
3341:
3342: v_pay_basis_rate := fnd_number.canonical_to_number(hr_ca_ff_udfs.convert_period_type(
3343: p_bus_grp_id => p_bg_id,
3344: p_payroll_id => p_pay_id,
3345: p_assignment_action_id => p_ass_action_id,
3346: p_assignment_id => p_ass_id ,

Line 3395: fnd_number.canonical_to_number(hruserdt.get_table_value(

3391: ELSE
3392: -- Find rate from rate table.
3393: hr_utility.set_location('OT_Base_Rate', 17);
3394: v_tew_total_rate := v_tew_total_rate +
3395: fnd_number.canonical_to_number(hruserdt.get_table_value(
3396: p_bg_id,
3397: c_rate_table_name,
3398: c_rate_table_column,
3399: v_tew_rcode));

Line 3426: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),

3422: AND UPPER(IPV.name) = 'RATE';
3423: --
3424: IF v_use_regwage <> 0 THEN
3425: hr_utility.set_location('OT_Base_Rate', 30);
3426: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0),
3427: EEV.element_entry_id
3428: INTO v_regwage_rate,
3429: v_entry_id
3430: FROM pay_element_entry_values_f EEV,

Line 3462: v_regwage_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

3458: AND ELT.element_type_id = IPV.element_type_id
3459: AND UPPER(IPV.name) = 'RATE CODE';
3460: --
3461: hr_utility.set_location('OT_Base_Rate', 41);
3462: v_regwage_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
3463: p_bus_group_id => p_bg_id,
3464: p_table_name => c_rate_table_name,
3465: p_col_name => c_rate_table_column,
3466: p_row_value => v_regwage_rcode));

Line 3488: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)

3484: AND UPPER(IPV.name) = 'MONTHLY SALARY';
3485: --
3486: IF v_use_regsal <> 0 THEN
3487: hr_utility.set_location('OT_Base_Rate', 51);
3488: SELECT NVL(fnd_number.canonical_to_number(EEV.screen_entry_value), 0)
3489: INTO v_regsal_mosal
3490: FROM pay_element_entry_values_f EEV,
3491: pay_element_entries_f ELE,
3492: pay_input_values_f IPV

Line 3629: v_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(

3625: AND UPPER(IPV.name) = 'RATE CODE';
3626: --
3627: IF v_rate_rcode <> 'NOT ENTERED' THEN
3628: hr_utility.set_location('OT_Base_Rate', 130);
3629: v_rate := fnd_number.canonical_to_number(hruserdt.get_table_value(
3630: p_bg_id,
3631: c_rate_table_name,
3632: c_rate_table_column,
3633: v_rate_rcode));