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: /* 10092419 start */

Line 38: SELECT org_information10, fnd_number.canonical_to_number(org_information12),fnd_number.canonical_to_number(org_information13)

34: p_def_6day_days OUT NOCOPY NUMBER
35: ) RETURN NUMBER is
36:
37: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
38: SELECT org_information10, fnd_number.canonical_to_number(org_information12),fnd_number.canonical_to_number(org_information13)
39: FROM hr_organization_information
40: WHERE organization_id = p_org_id
41: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
42:

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

106: p_work_pattern OUT NOCOPY VARCHAR2,
107: p_hol_all_reduction OUT NOCOPY VARCHAR2) RETURN NUMBER is
108:
109: /* Bug fix 4950983 added org_information1 in select clause */
110: /* Change the to_number to fnd_number.canonical_to_number */
111: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
112: SELECT fnd_number.canonical_to_number(org_information4), fnd_number.canonical_to_number(org_information3), org_information5, org_information1, org_information8 --9559824 abraghun - swapped first two columns.
113: FROM hr_organization_information
114: WHERE organization_id = p_org_id

Line 112: SELECT fnd_number.canonical_to_number(org_information4), fnd_number.canonical_to_number(org_information3), org_information5, org_information1, org_information8 --9559824 abraghun - swapped first two columns.

108:
109: /* Bug fix 4950983 added org_information1 in select clause */
110: /* Change the to_number to fnd_number.canonical_to_number */
111: CURSOR csr_get_hol_rates(p_org_id NUMBER) is
112: SELECT fnd_number.canonical_to_number(org_information4), fnd_number.canonical_to_number(org_information3), org_information5, org_information1, org_information8 --9559824 abraghun - swapped first two columns.
113: FROM hr_organization_information
114: WHERE organization_id = p_org_id
115: and org_information_context = 'DK_HOLIDAY_ENTITLEMENT_INFO';
116: