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_NL_ABP_REPORT dependencies on FND_NUMBER

Line 331: ,fnd_number.canonical_to_number(pai.action_information5) ptp

327: SELECT to_char(fnd_date.canonical_to_date(pai.action_information1),'RRRR-MM-DD') start_date
328: ,to_char(fnd_date.canonical_to_date(pai.action_information2),'RRRR-MM-DD') end_date
329: ,pai.action_information3 kop
330: ,pai.action_information4 income_code
331: ,fnd_number.canonical_to_number(pai.action_information5) ptp
332: ,pai.action_information6 code_inc
333: FROM pay_action_information pai
334: WHERE pai.action_context_id = c_assignment_action_id
335: AND pai.action_information_category = 'NL_ABP_PAY_PERIOD_INFO'

Line 345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base

341: ,pai.action_information2 pension_type_variant
342: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') pension_type_sdate
343: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') pension_type_info_sdate
344: ,pai.action_information5 wage_type
345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base
346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base
347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt
348: ,fnd_number.canonical_to_number(pai.action_information9) vop
349: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') pension_type_info_sdate_multi --Bug 16301893

Line 346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base

342: ,to_char(fnd_date.canonical_to_date(pai.action_information3),'RRRR-MM-DD') pension_type_sdate
343: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') pension_type_info_sdate
344: ,pai.action_information5 wage_type
345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base
346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base
347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt
348: ,fnd_number.canonical_to_number(pai.action_information9) vop
349: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') pension_type_info_sdate_multi --Bug 16301893
350: ,to_char(fnd_date.canonical_to_date(pai.action_information11),'RRRR-MM-DD') pension_type_edate

Line 347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt

343: ,to_char(fnd_date.canonical_to_date(pai.action_information4),'RRRR-MM-DD') pension_type_info_sdate
344: ,pai.action_information5 wage_type
345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base
346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base
347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt
348: ,fnd_number.canonical_to_number(pai.action_information9) vop
349: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') pension_type_info_sdate_multi --Bug 16301893
350: ,to_char(fnd_date.canonical_to_date(pai.action_information11),'RRRR-MM-DD') pension_type_edate
351: FROM pay_action_information pai

Line 348: ,fnd_number.canonical_to_number(pai.action_information9) vop

344: ,pai.action_information5 wage_type
345: ,fnd_number.canonical_to_number(pai.action_information6) abp_pension_base
346: ,fnd_number.canonical_to_number(pai.action_information7) contr_base
347: ,fnd_number.canonical_to_number(pai.action_information8) contr_amt
348: ,fnd_number.canonical_to_number(pai.action_information9) vop
349: ,to_char(fnd_date.canonical_to_date(pai.action_information10),'RRRR-MM-DD') pension_type_info_sdate_multi --Bug 16301893
350: ,to_char(fnd_date.canonical_to_date(pai.action_information11),'RRRR-MM-DD') pension_type_edate
351: FROM pay_action_information pai
352: WHERE pai.action_context_id = c_assignment_action_id

Line 381: , nvl (fnd_number.canonical_to_number (pai.action_information6), 0) abp_pension_base

377: FROM (
378: SELECT pai.action_information1 pension_type
379: , pai.action_information2 pension_type_variant
380: , pai.action_information4 pension_type_info_sdate
381: , nvl (fnd_number.canonical_to_number (pai.action_information6), 0) abp_pension_base
382: , avg (nvl (fnd_number.canonical_to_number (pai.action_information7), 0)) contr_base
383: , avg (nvl (fnd_number.canonical_to_number (pai.action_information8), 0)) contr_amt
384: FROM pay_action_information pai
385: WHERE pai.action_context_id = c_action_context_id

Line 382: , avg (nvl (fnd_number.canonical_to_number (pai.action_information7), 0)) contr_base

378: SELECT pai.action_information1 pension_type
379: , pai.action_information2 pension_type_variant
380: , pai.action_information4 pension_type_info_sdate
381: , nvl (fnd_number.canonical_to_number (pai.action_information6), 0) abp_pension_base
382: , avg (nvl (fnd_number.canonical_to_number (pai.action_information7), 0)) contr_base
383: , avg (nvl (fnd_number.canonical_to_number (pai.action_information8), 0)) contr_amt
384: FROM pay_action_information pai
385: WHERE pai.action_context_id = c_action_context_id
386: AND pai.action_information_category = 'NL_ABP_PENSION_INFO'

Line 383: , avg (nvl (fnd_number.canonical_to_number (pai.action_information8), 0)) contr_amt

379: , pai.action_information2 pension_type_variant
380: , pai.action_information4 pension_type_info_sdate
381: , nvl (fnd_number.canonical_to_number (pai.action_information6), 0) abp_pension_base
382: , avg (nvl (fnd_number.canonical_to_number (pai.action_information7), 0)) contr_base
383: , avg (nvl (fnd_number.canonical_to_number (pai.action_information8), 0)) contr_amt
384: FROM pay_action_information pai
385: WHERE pai.action_context_id = c_action_context_id
386: AND pai.action_information_category = 'NL_ABP_PENSION_INFO'
387: AND action_context_type = 'AAP'