APPS.PAY_DK_HOLIDAY_PAY_PKG dependencies on FND_NUMBER

Line 23: /* Change the to_number to fnd_number.canonical_to_number */

19: BEGIN
20: OPEN get_perc_from_ddf(p_payroll_id, p_date_earned);
21: FETCH get_perc_from_ddf INTO l_value;
22: CLOSE get_perc_from_ddf;
23: /* Change the to_number to fnd_number.canonical_to_number */
24: RETURN fnd_number.canonical_to_number(l_value);
25:
26: END get_allowance_perc;
27:

Line 24: RETURN fnd_number.canonical_to_number(l_value);

20: OPEN get_perc_from_ddf(p_payroll_id, p_date_earned);
21: FETCH get_perc_from_ddf INTO l_value;
22: CLOSE get_perc_from_ddf;
23: /* Change the to_number to fnd_number.canonical_to_number */
24: RETURN fnd_number.canonical_to_number(l_value);
25:
26: END get_allowance_perc;
27:
28:

Line 73: /* Change the to_number to fnd_number.canonical_to_number */

69: p_use_holiday_card OUT NOCOPY VARCHAR2,
70: p_work_pattern OUT NOCOPY VARCHAR2) RETURN NUMBER is
71:
72: /* Bug fix 4950983 added org_information1 in select clause */
73: /* Change the to_number to fnd_number.canonical_to_number */
74: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
75: SELECT fnd_number.canonical_to_number(org_information3), fnd_number.canonical_to_number(org_information4), org_information5, org_information1
76: FROM hr_organization_information
77: WHERE organization_id = p_org_id

Line 75: SELECT fnd_number.canonical_to_number(org_information3), fnd_number.canonical_to_number(org_information4), org_information5, org_information1

71:
72: /* Bug fix 4950983 added org_information1 in select clause */
73: /* Change the to_number to fnd_number.canonical_to_number */
74: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
75: SELECT fnd_number.canonical_to_number(org_information3), fnd_number.canonical_to_number(org_information4), org_information5, org_information1
76: FROM hr_organization_information
77: WHERE organization_id = p_org_id
78: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
79: