APPS.PER_IN_ENTRY_VALUE_LEG_HOOK dependencies on FND_NUMBER

Line 397: SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT

393: AND pee.effective_start_date between pay_in_tax_utils.get_financial_year_start(p_effective_date) and pay_in_tax_utils.get_financial_year_end (p_effective_date);
394:
395:
396: CURSOR c_ppf_amount(p_ppf_element_entry_id NUMBER ) IS
397: SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT
398: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
399: WHERE pee.assignment_id = p_assignment_id
400: AND pee.element_entry_id =peev.element_entry_id
401: AND pee.element_type_id= p_element_type_id

Line 465: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN

461: pay_in_utils.trace('g_ppf_max_exemption_limit_80c ',g_ppf_max_exemption_limit_80c );
462: pay_in_utils.trace('**************************************************','********************');
463: END IF;
464:
465: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN
466: pay_in_utils.trace('inside the error loop','********************');
467: fnd_message.set_name('PER', 'PER_IN_PPF_MAX_EXEMPTION_ERROR');
468: fnd_message.set_token('PPF_LIMIT',g_ppf_max_exemption_limit_80c);
469: fnd_message.raise_error;

Line 540: SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT

536: AND pee.effective_start_date between pay_in_tax_utils.get_financial_year_start(p_effective_date) and pay_in_tax_utils.get_financial_year_end (p_effective_date);
537:
538:
539: CURSOR c_ppf_amount(p_ppf_element_entry_id NUMBER ) IS
540: SELECT fnd_number.canonical_to_number(peev.screen_entry_value) PPF_AMOUNT
541: FROM PAY_ELEMENT_ENTRIES_F pee, pay_element_entry_values_f peev
542: WHERE pee.assignment_id = p_assignment_id_O
543: AND pee.element_entry_id =peev.element_entry_id
544: AND pee.element_type_id= p_element_type_id_O

Line 608: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN

604: pay_in_utils.trace('**************************************************','********************');
605: END IF;
606:
607:
608: IF(fnd_number.canonical_to_number(l_ppf_amount) > g_ppf_max_exemption_limit_80c ) THEN
609: pay_in_utils.trace('inside the error loop','********************');
610: fnd_message.set_name('PER', 'PER_IN_PPF_MAX_EXEMPTION_ERROR');
611: fnd_message.set_token('PPF_LIMIT',g_ppf_max_exemption_limit_80c);
612: fnd_message.raise_error;