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 232: ,fnd_number.canonical_to_number(pai1.action_information8) record_count -- Format Changes for Payslip Bug - 7229247 /* 9358829 */

228: INSTR(pai1.action_information9,':')-1)||')',SUBSTR(pai.action_information4,INSTR(pai.action_information4,',')+1))) Name
229: ,SUBSTR(pai.action_information4,1,INSTR(pai.action_information4,',')-1) CODE -- Changes for Bug 7229247
230: ,pai.action_information5 type
231: ,pai.action_information6 uom
232: ,fnd_number.canonical_to_number(pai1.action_information8) record_count -- Format Changes for Payslip Bug - 7229247 /* 9358829 */
233: --,sum(pai1.action_information4) value
234: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price -- Format Changes in Payslip Bug - 7229247
235: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value -- Format Changes for Payslip Bug - 7229247
236: FROM pay_action_information pai

Line 235: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value -- Format Changes for Payslip Bug - 7229247

231: ,pai.action_information6 uom
232: ,fnd_number.canonical_to_number(pai1.action_information8) record_count -- Format Changes for Payslip Bug - 7229247 /* 9358829 */
233: --,sum(pai1.action_information4) value
234: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price -- Format Changes in Payslip Bug - 7229247
235: ,sum(fnd_number.canonical_to_number(pai1.action_information4)) value -- Format Changes for Payslip Bug - 7229247
236: FROM pay_action_information pai
237: ,pay_action_information pai1
238: ,pay_assignment_actions paa
239: WHERE pai.action_context_type = 'PA'

Line 268: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information10); /* 9358829 */

264: ,pai1.action_information3
265: ,pai1.action_information9 -- Format Changes for Payslip Bug - 7229247
266: ,pai1.action_information10 /* 9358829 */
267: ,pai1.action_information8 -- Format Changes for Payslip Bug - 7229247
268: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information10); /* 9358829 */
269:
270:
271:
272: ----- cursor to get the element information for additional elements ----------------

Line 287: ,fnd_number.canonical_to_number(pai1.action_information8) record_count

283: -- ,decode(pai1.action_information8,NULL,pai.action_information4,
284: -- pai.action_information4||'('||pai1.action_information8||')') Name
285: ,SUBSTR(pai.action_information4,INSTR(pai.action_information4,',')+1) Name
286: ,SUBSTR(pai.action_information4,1,INSTR(pai.action_information4,',')-1) CODE
287: ,fnd_number.canonical_to_number(pai1.action_information8) record_count
288: ,substr(pai1.action_information9,instr(pai1.action_information9,':',-1)+1) unit_price
289: -- End
290: ,pai.action_information5 type
291: ,pai.action_information6 uom

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

320: ,pai1.action_information4
321: ,pai1.action_information8 -- Format Changes for Payslip Bug - 7229247
322: ,pai1.action_information9 -- Format Changes for Payslip Bug - 7229247
323: -- ORDER BY pai.action_information5,pai1.action_information8 DESC;
324: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8);
325:
326:
327:
328: -------- cursor to get the payroll information -----------------------------

Line 427: l_total_earnings := l_total_earnings + fnd_number.canonical_to_number(nvl(csr_element_info_rec.value,0)) ;

423: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
424: load_xml('CS', NULL, 'ELEMENT DETAILS', NULL) ;
425: --
426: IF csr_element_info_rec.type = 'E' THEN
427: l_total_earnings := l_total_earnings + fnd_number.canonical_to_number(nvl(csr_element_info_rec.value,0)) ;
428: END IF ;
429:
430: IF csr_element_info_rec.type = 'D' THEN
431: l_total_deductions := l_total_deductions + fnd_number.canonical_to_number(nvl(csr_element_info_rec.value,0)) ;

Line 431: l_total_deductions := l_total_deductions + fnd_number.canonical_to_number(nvl(csr_element_info_rec.value,0)) ;

427: l_total_earnings := l_total_earnings + fnd_number.canonical_to_number(nvl(csr_element_info_rec.value,0)) ;
428: END IF ;
429:
430: IF csr_element_info_rec.type = 'D' THEN
431: l_total_deductions := l_total_deductions + fnd_number.canonical_to_number(nvl(csr_element_info_rec.value,0)) ;
432: END IF ;
433: --
434: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
435: load_xml('D', 'EMEA ELEMENT DEFINITION', 'ACTION_INFORMATION2',csr_element_info_rec.element_type_id );

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

460:
461: /*End*/
462:
463: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
464: load_xml('D', 'EMEA ELEMENT INFO', 'ACTION_INFORMATION4',fnd_number.canonical_to_number(csr_element_info_rec.value) );
465:
466:
467: --
468: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

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

571: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
572: load_xml('CS', NULL, 'SUMMARY OF PAYMENTS', NULL);
573: --
574: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
575: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
576: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
577: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
578: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
579: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );

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

573: --
574: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
575: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
576: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
577: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
578: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
579: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );
580: --
581: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

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

575: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
576: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
577: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
578: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
579: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );
580: --
581: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
582: load_xml('CE', NULL, 'SUMMARY OF PAYMENTS', NULL);
583: --