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 341: -- fnd_number.canonical_to_number function

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

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

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

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

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

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

612:
613: --
614: cursor c_get_carryover is
615: -- index hint applied for bug 4737028 to avoid bitmap conversion and usage of proper index
616: select /*+ index(pee PAY_ELEMENT_ENTRIES_F_N53)*/ fnd_number.canonical_to_number(nvl(pev.screen_entry_value, 0)) carryover,
617: fnd_date.canonical_to_date(nvl(pev1.screen_entry_value,
618: p_calculation_date)) expiry_date
619: from pay_accrual_plans pap,
620: pay_element_entry_values_f pev,