APPS.PAY_NL_GENERAL dependencies on FND_NUMBER

Line 212: l_result_value := to_char(fnd_number.canonical_to_number(l_result_value));

208:
209: OPEN csr_get_run_result_value(p_assignment_action_id,p_element_type_id,p_input_value_id,p_run_result_id);
210: FETCH csr_get_run_result_value into l_result_value;
211: IF p_UOM = 'M' OR p_UOM = 'N' THEN
212: l_result_value := to_char(fnd_number.canonical_to_number(l_result_value));
213: END IF;
214: CLOSE csr_get_run_Result_value;
215:
216: return l_result_value;

Line 241: select fnd_number.canonical_to_number(prrv.result_value) from pay_run_result_values prrv,pay_run_results prr

237:
238: cursor csr_get_run_result_value(p_assignment_action_id number,
239: p_element_type_id number,
240: p_input_value_id number)is
241: select fnd_number.canonical_to_number(prrv.result_value) from pay_run_result_values prrv,pay_run_results prr
242: where prr.assignment_action_id=p_assignment_action_id
243: and prr.element_type_id=p_element_type_id
244: and prrv.run_result_id=prr.run_result_id
245: and prrv.input_value_id=p_input_value_id;

Line 1363: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value

1359: p_pri_class_name IN VARCHAR2,
1360: p_assact_id IN NUMBER)
1361: RETURN NUMBER IS
1362: cursor csr_get_retro_bal_val IS
1363: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1364: from
1365: pay_payroll_actions ppa,
1366: pay_assignment_actions paa,
1367: pay_run_results prr,

Line 1408: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value

1404: p_sec_class_name IN VARCHAR2,
1405: p_assact_id IN NUMBER)
1406: RETURN NUMBER IS
1407: CURSOR csr_retro_bal_val IS
1408: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1409: from
1410: pay_payroll_actions ppa,
1411: pay_assignment_actions paa,
1412: pay_run_results prr,

Line 1464: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value

1460: p_end_of_year IN VARCHAR2,
1461: p_assact_id IN NUMBER)
1462: RETURN NUMBER IS
1463: CURSOR csr_retro_element_context IS
1464: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1465: from
1466: pay_payroll_actions ppa,
1467: pay_assignment_actions paa,
1468: pay_run_results prr,

Line 1496: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value

1492: and ppa.effective_date between piv.effective_Start_Date and piv.effective_end_date
1493: and paa.assignment_action_id=p_assact_id;
1494:
1495: CURSOR csr_retro_element IS
1496: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1497: from
1498: pay_payroll_actions ppa,
1499: pay_assignment_actions paa,
1500: pay_run_results prr,

Line 1545: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value

1541: p_pri_class_name IN VARCHAR2,
1542: p_assact_id IN NUMBER)
1543: RETURN NUMBER IS
1544: cursor csr_get_elmt_bal_val IS
1545: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1546: from
1547: pay_payroll_actions ppa,
1548: pay_assignment_actions paa,
1549: pay_run_results prr,

Line 1700: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value

1696: p_sec_class_name IN VARCHAR2,
1697: p_assact_id IN NUMBER)
1698: RETURN NUMBER AS
1699: cursor csr_get_elmt_bal_val is
1700: select sum(nvl(fnd_number.canonical_to_number(prv.result_value),0)) value
1701: from
1702: pay_payroll_actions ppa,
1703: pay_assignment_actions paa,
1704: pay_run_results prr,