APPS.PER_ACCRUAL_CALC_FUNCTIONS dependencies on FND_NUMBER

Line 77: -- fnd_number.canonical_to_number function

73: p_outputs => l_outputs);
74:
75: -- Bug fix 4004565
76: -- Fast formula output p_total_accrued_pto converted to number using
77: -- fnd_number.canonical_to_number function
78:
79: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);
80: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);
81: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);

Line 79: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);

75: -- Bug fix 4004565
76: -- Fast formula output p_total_accrued_pto converted to number using
77: -- fnd_number.canonical_to_number function
78:
79: p_total_accrued_pto := fnd_number.canonical_to_number(l_outputs(1).value);
80: p_effective_start_date := fnd_date.canonical_to_date(l_outputs(2).value);
81: p_effective_end_date := fnd_date.canonical_to_date(l_outputs(3).value);
82: p_accrual_end_date := fnd_date.canonical_to_date(l_outputs(4).value);
83: --

Line 340: -- fnd_number.canonical_to_number function

336: else
337: --
338: -- Bug fix 4004565
339: -- Fast formula output converted to number using
340: -- fnd_number.canonical_to_number function
341:
342: p_max_carry_over := fnd_number.canonical_to_number(l_outputs(1).value);
343: --
344: end if;

Line 342: p_max_carry_over := fnd_number.canonical_to_number(l_outputs(1).value);

338: -- Bug fix 4004565
339: -- Fast formula output converted to number using
340: -- fnd_number.canonical_to_number function
341:
342: p_max_carry_over := fnd_number.canonical_to_number(l_outputs(1).value);
343: --
344: end if;
345:
346: p_effective_date := fnd_date.canonical_to_date(l_outputs(2).value);

Line 477: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53,iv PAY_INPUT_VALUES_F_N50 )*/ fnd_number.canonical_to_number(pev.screen_entry_value) amount,

473: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
474: -- index PAY_ELEMENT_ENTRIES_F_N53 is now used in hint to resolve bug 5677610
475: -- index PAY_INPUT_VALUES_F_N50 is now used in hint to resolve bug 6621800
476:
477: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53,iv PAY_INPUT_VALUES_F_N50 )*/ fnd_number.canonical_to_number(pev.screen_entry_value) amount,
478: -- Bug 4551666, bug6621800
479: ncr.add_or_subtract add_or_subtract
480: from pay_accrual_plans pap,
481: pay_net_calculation_rules ncr,

Line 610: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53)*/ fnd_number.canonical_to_number(nvl(pev.screen_entry_value, 0)) carryover,

606: g_expiry_date1 g_effective_date;
607: --
608: cursor c_get_carryover is
609: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
610: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53)*/ fnd_number.canonical_to_number(nvl(pev.screen_entry_value, 0)) carryover,
611: fnd_date.canonical_to_date(nvl(pev1.screen_entry_value,
612: p_calculation_date)) expiry_date
613: from pay_accrual_plans pap,
614: pay_element_entry_values_f pev,