APPS.PQH_LENGTH_OF_SERVICE_PKG dependencies on FND_NUMBER

Line 598: SELECT NVL(fnd_number.canonical_to_number(peit.pei_information4),0)

594: l_correct_days NUMBER(22,3) := 0;
595: l_proc varchar2(60) := g_package||'get_correction_factor';
596:
597: CURSOR Csr_correction IS
598: SELECT NVL(fnd_number.canonical_to_number(peit.pei_information4),0)
599: FROM per_people_extra_info peit
600: WHERE peit.person_id = p_person_id
601: AND peit.information_type = 'FR_PQH_ADDL_SENIORITY_INFO'
602: AND peit.pei_information1 = p_los_type

Line 666: l_military_duration := l_military_duration + fnd_number.canonical_to_number(lr_military.length_of_service)*(NVL(l_entitlement_value,0)/100);

662: CLOSE csr_military_entitlement;
663: hr_utility.set_location(l_proc||' military entitlement '||l_entitlement_value,1);
664: FOR lr_military IN csr_military_periods
665: LOOP
666: l_military_duration := l_military_duration + fnd_number.canonical_to_number(lr_military.length_of_service)*(NVL(l_entitlement_value,0)/100);
667: END LOOP;
668: END IF;
669: hr_utility.set_location(l_proc||' Military Duration '||l_military_duration,1);
670: RETURN l_military_duration;