APPS.PAY_FI_RULES dependencies on FND_NUMBER

Line 704: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value

700: pai.action_information4||'('||pai1.action_information8||')') Name
701: ,pai.action_information5 type
702: ,pai.action_information6 uom
703: --,pai1.action_information8 record_count
704: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
705: FROM pay_action_information pai
706: ,pay_action_information pai1
707: ,pay_assignment_actions paa
708: WHERE pai.action_context_type = 'PA'

Line 837: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(element_info_rec.value));

833: load_xml('D', 'EMEA ELEMENT DEFINITION', 'ACTION_INFORMATION3', element_info_rec.input_value_id);
834: load_xml('D', 'EMEA ELEMENT DEFINITION', 'ACTION_INFORMATION4', element_info_rec.Name);
835: load_xml('D', 'EMEA ELEMENT DEFINITION', 'ACTION_INFORMATION5', element_info_rec.type);
836: load_xml('D', 'EMEA ELEMENT DEFINITION', 'ACTION_INFORMATION6', element_info_rec.uom);
837: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(element_info_rec.value));
838: load_xml('CE', NULL, 'ELEMENT DETAILS', NULL);
839:
840: IF element_info_rec.type = 'E' THEN
841: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;

Line 841: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;

837: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4', fnd_number.canonical_to_number(element_info_rec.value));
838: load_xml('CE', NULL, 'ELEMENT DETAILS', NULL);
839:
840: IF element_info_rec.type = 'E' THEN
841: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
842: ELSIF element_info_rec.type = 'D' THEN
843: l_total_deductions := fnd_number.canonical_to_number(l_total_deductions) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
844: END IF ;
845: l_total_pay := l_total_earnings - l_total_deductions ;

Line 843: l_total_deductions := fnd_number.canonical_to_number(l_total_deductions) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;

839:
840: IF element_info_rec.type = 'E' THEN
841: l_total_earnings := fnd_number.canonical_to_number(l_total_earnings) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
842: ELSIF element_info_rec.type = 'D' THEN
843: l_total_deductions := fnd_number.canonical_to_number(l_total_deductions) + fnd_number.canonical_to_number(nvl(element_info_rec.value,0)) ;
844: END IF ;
845: l_total_pay := l_total_earnings - l_total_deductions ;
846:
847: END LOOP;