eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_DK_RULES dependencies on FND_NUMBER

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

224: ,pai.action_information5 type
225: ,pai.action_information6 uom
226: --,pai1.action_information8 record_count
227: --,sum(pai1.action_information4) value
228: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value
229: FROM pay_action_information pai
230: ,pay_action_information pai1
231: ,pay_assignment_actions paa
232: WHERE pai.action_context_type = 'PA'

Line 259: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8);

255: --Information 3 and 9 added in group by clause to get the sum based on pension provider
256: ,pai1.action_information3
257: ,pai1.action_information9
258: ,pai1.action_information8
259: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8);
260:
261: ----- cursor to get the element information for additional elements ----------------
262:
263: /*Modified order by clause for bug fix 6165239*/

Line 306: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8);

302: ,pai.action_information6
303: ,pai1.action_information4
304: ,pai1.action_information8
305: -- ORDER BY pai.action_information5,pai1.action_information8 DESC;
306: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8);
307:
308:
309:
310: -------- cursor to get the payroll information -----------------------------

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

418: --pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
419: -- load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4',csr_element_info_rec.value );
420:
421: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
422: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4',fnd_number.canonical_to_number(csr_element_info_rec.value) );
423:
424: --
425: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
426: load_xml('CE', NULL, 'ELEMENT DETAILS', NULL);

Line 521: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );

517: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
518: load_xml('CS', NULL, 'SUMMARY OF PAYMENTS', NULL);
519: --
520: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
521: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
522: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
523: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
524: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
525: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );

Line 523: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );

519: --
520: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
521: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
522: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
523: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
524: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
525: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );
526: --
527: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 525: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );

521: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
522: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
523: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
524: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
525: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );
526: --
527: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
528: load_xml('CE', NULL, 'SUMMARY OF PAYMENTS', NULL);
529: --