APPS.PAY_IN_24Q_ER_RETURNS dependencies on FND_NUMBER

Line 268: l_value_temp := trunc(fnd_number.canonical_to_number(p_value), 2);

264: IF g_debug THEN
265: pay_in_utils.trace('p_value',p_value);
266: END IF;
267:
268: l_value_temp := trunc(fnd_number.canonical_to_number(p_value), 2);
269:
270: IF(NVL(l_value_temp,0)=0) THEN
271: RETURN '0.00';
272: END IF;

Line 622: SELECT round(NVL(fnd_number.canonical_to_number(action_information2),0),2)

618: RETURN VARCHAR2 IS
619:
620: -- Bug 10365553: Added round() to fetch values upto 2 decimal places
621: CURSOR c_form24Q_values IS
622: SELECT round(NVL(fnd_number.canonical_to_number(action_information2),0),2)
623: ,round(NVL(fnd_number.canonical_to_number(action_information3),0),2)
624: FROM pay_action_information
625: WHERE action_information_category = p_category
626: AND action_information1 = p_component_name

Line 623: ,round(NVL(fnd_number.canonical_to_number(action_information3),0),2)

619:
620: -- Bug 10365553: Added round() to fetch values upto 2 decimal places
621: CURSOR c_form24Q_values IS
622: SELECT round(NVL(fnd_number.canonical_to_number(action_information2),0),2)
623: ,round(NVL(fnd_number.canonical_to_number(action_information3),0),2)
624: FROM pay_action_information
625: WHERE action_information_category = p_category
626: AND action_information1 = p_component_name
627: AND action_context_id = p_context_id

Line 746: SELECT NVL(SUM(fnd_number.canonical_to_number(action_information2)),0)

742: RETURN VARCHAR2 IS
743:
744: CURSOR csr_income_details(p_balance VARCHAR2,p_action_context_id NUMBER,p_source_id IN NUMBER)
745: IS
746: SELECT NVL(SUM(fnd_number.canonical_to_number(action_information2)),0)
747: FROM pay_action_information
748: WHERE action_information_category = 'IN_24Q_SALARY'
749: AND action_context_type = 'AAP'
750: AND action_information1 = p_balance