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

Line 1442: ,p_action_information9 => fnd_number.number_to_canonical(l_emp_contr_bse) -- 2007/2008 changes

1438: ,p_action_information5 => l_rec2.local_unit
1439: ,p_action_information6 => l_rec2.tax_municipality_id
1440: ,p_action_information7 => l_rec2.tax_municipality
1441: ,p_action_information8 => l_ni_zone_arc
1442: ,p_action_information9 => fnd_number.number_to_canonical(l_emp_contr_bse) -- 2007/2008 changes
1443: ,p_action_information10 => fnd_number.number_to_canonical(l_reimb_bse) -- 2007/2008 changes
1444: ,p_action_information11 => fnd_number.number_to_canonical(l_pension_bse)); -- 2007/2008 Changes
1445: --
1446:

Line 1443: ,p_action_information10 => fnd_number.number_to_canonical(l_reimb_bse) -- 2007/2008 changes

1439: ,p_action_information6 => l_rec2.tax_municipality_id
1440: ,p_action_information7 => l_rec2.tax_municipality
1441: ,p_action_information8 => l_ni_zone_arc
1442: ,p_action_information9 => fnd_number.number_to_canonical(l_emp_contr_bse) -- 2007/2008 changes
1443: ,p_action_information10 => fnd_number.number_to_canonical(l_reimb_bse) -- 2007/2008 changes
1444: ,p_action_information11 => fnd_number.number_to_canonical(l_pension_bse)); -- 2007/2008 Changes
1445: --
1446:
1447: -- Retrieve balances for:-

Line 1444: ,p_action_information11 => fnd_number.number_to_canonical(l_pension_bse)); -- 2007/2008 Changes

1440: ,p_action_information7 => l_rec2.tax_municipality
1441: ,p_action_information8 => l_ni_zone_arc
1442: ,p_action_information9 => fnd_number.number_to_canonical(l_emp_contr_bse) -- 2007/2008 changes
1443: ,p_action_information10 => fnd_number.number_to_canonical(l_reimb_bse) -- 2007/2008 changes
1444: ,p_action_information11 => fnd_number.number_to_canonical(l_pension_bse)); -- 2007/2008 Changes
1445: --
1446:
1447: -- Retrieve balances for:-
1448: --

Line 1488: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))

1484: ,p_action_information_category => 'EMEA REPORT INFORMATION'
1485: ,p_action_information1 => 'LE_SI_BALS'
1486: ,p_action_information2 => TO_CHAR(l_rec1.legal_employer_id)
1487: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1488: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1489: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))

Line 1489: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))

1485: ,p_action_information1 => 'LE_SI_BALS'
1486: ,p_action_information2 => TO_CHAR(l_rec1.legal_employer_id)
1487: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1488: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1489: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)

Line 1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))

1486: ,p_action_information2 => TO_CHAR(l_rec1.legal_employer_id)
1487: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1488: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1489: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))

Line 1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))

1487: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1488: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1489: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))

Line 1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))

1488: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1489: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))

Line 1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)

1489: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))

Line 1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))

1490: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))

Line 1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))

1491: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)

Line 1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))

1492: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)

Line 1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))

1493: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)

Line 1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))

1494: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)

Line 1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)

1495: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)

Line 1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)

1496: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))

Line 1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)

1497: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))

Line 1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)

1498: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes

Line 1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)

1499: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1507: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes

Line 1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))

1500: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1507: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1508: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes

Line 1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))

1501: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1507: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1508: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1509:

Line 1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes

1502: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1507: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1508: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1509:
1510: END LOOP;

Line 1507: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes

1503: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1507: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1508: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1509:
1510: END LOOP;
1511: END IF;

Line 1508: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes

1504: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1505: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1506: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1507: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1508: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1509:
1510: END LOOP;
1511: END IF;
1512: --

Line 2158: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value

2154: CURSOR csr_613_616_details
2155: (l_rr_id IN NUMBER
2156: ,l_element_type_id IN NUMBER
2157: ,p_report_date IN DATE) IS
2158: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2159: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2160: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2161: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2162: ,max(decode (piv.name,'Country', rrv.result_value)) Country

Line 2159: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem

2155: (l_rr_id IN NUMBER
2156: ,l_element_type_id IN NUMBER
2157: ,p_report_date IN DATE) IS
2158: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2159: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2160: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2161: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2162: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2163: FROM pay_run_result_values rrv

Line 2160: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days

2156: ,l_element_type_id IN NUMBER
2157: ,p_report_date IN DATE) IS
2158: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2159: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2160: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2161: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2162: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2163: FROM pay_run_result_values rrv
2164: ,pay_input_values_f piv

Line 2161: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days

2157: ,p_report_date IN DATE) IS
2158: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2159: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2160: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2161: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2162: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2163: FROM pay_run_result_values rrv
2164: ,pay_input_values_f piv
2165: WHERE rrv.run_result_id = l_rr_id

Line 2242: l_rep_code_rec.amount := fnd_number.number_to_canonical(l_amount);

2238: END IF;
2239: --
2240: IF l_amount <> 0 THEN
2241: l_rep_code_rec.reporting_code := l_bal_rec.reporting_code;
2242: l_rep_code_rec.amount := fnd_number.number_to_canonical(l_amount);
2243: --
2244: l_seaman_status := 'N';
2245: --
2246: OPEN csr_seaman_bal_status(l_classification_id, l_bal_rec.defined_balance_id);

Line 2271: l_rep_code_rec.amount := fnd_number.number_to_canonical(rec_549_118A.value);

2267: ,l_element_name )
2268: LOOP
2269: --
2270: IF rec_549_118A.dtype = 'M' THEN
2271: l_rep_code_rec.amount := fnd_number.number_to_canonical(rec_549_118A.value);
2272: ELSE
2273: l_rep_code_rec.amount := rec_549_118A.value;
2274: END IF;
2275: --

Line 2340: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)

2336: ,p_effective_date => g_report_date
2337: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2338: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2339: ,p_action_information2 => l_bal_rec.reporting_code
2340: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2341: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2342: ,p_action_information10 => l_seaman_status);
2343: --
2344: l_Pay_Value := rec_613_616_details.Pay_Value;

Line 2341: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)

2337: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2338: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2339: ,p_action_information2 => l_bal_rec.reporting_code
2340: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2341: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2342: ,p_action_information10 => l_seaman_status);
2343: --
2344: l_Pay_Value := rec_613_616_details.Pay_Value;
2345: l_Days := rec_613_616_details.Days;

Line 2370: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)

2366: ,p_effective_date => g_report_date
2367: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2368: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2369: ,p_action_information2 => l_bal_rec.reporting_code
2370: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2371: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2372: ,p_action_information10 => l_seaman_status);
2373: --
2374: END IF;

Line 2371: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)

2367: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2368: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2369: ,p_action_information2 => l_bal_rec.reporting_code
2370: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2371: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2372: ,p_action_information10 => l_seaman_status);
2373: --
2374: END IF;
2375: --

Line 2487: ,p_action_information3 => fnd_number.number_to_canonical(l_code_616(i).Pay_Value)

2483: ,p_effective_date => g_report_date
2484: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2485: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2486: ,p_action_information2 => l_bal_rec.reporting_code
2487: ,p_action_information3 => fnd_number.number_to_canonical(l_code_616(i).Pay_Value)
2488: ,p_action_information4 => fnd_number.number_to_canonical(l_code_616(i).Per_Diem)
2489: ,p_action_information5 => fnd_number.number_to_canonical(l_code_616(i).Days)
2490: ,p_action_information6 => l_code_616(i).Country
2491: ,p_action_information10 => l_seaman_status);

Line 2488: ,p_action_information4 => fnd_number.number_to_canonical(l_code_616(i).Per_Diem)

2484: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2485: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2486: ,p_action_information2 => l_bal_rec.reporting_code
2487: ,p_action_information3 => fnd_number.number_to_canonical(l_code_616(i).Pay_Value)
2488: ,p_action_information4 => fnd_number.number_to_canonical(l_code_616(i).Per_Diem)
2489: ,p_action_information5 => fnd_number.number_to_canonical(l_code_616(i).Days)
2490: ,p_action_information6 => l_code_616(i).Country
2491: ,p_action_information10 => l_seaman_status);
2492: --

Line 2489: ,p_action_information5 => fnd_number.number_to_canonical(l_code_616(i).Days)

2485: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2486: ,p_action_information2 => l_bal_rec.reporting_code
2487: ,p_action_information3 => fnd_number.number_to_canonical(l_code_616(i).Pay_Value)
2488: ,p_action_information4 => fnd_number.number_to_canonical(l_code_616(i).Per_Diem)
2489: ,p_action_information5 => fnd_number.number_to_canonical(l_code_616(i).Days)
2490: ,p_action_information6 => l_code_616(i).Country
2491: ,p_action_information10 => l_seaman_status);
2492: --
2493: END LOOP;

Line 2522: l_rep_code_rec.info1 := fnd_number.number_to_canonical(l_amount);

2518: END IF;
2519: --
2520: --
2521: IF l_bal_info_rec.info_id = 'INFO1' THEN
2522: l_rep_code_rec.info1 := fnd_number.number_to_canonical(l_amount);
2523: ELSIF l_bal_info_rec.info_id = 'INFO2' THEN
2524: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2525: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2526: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);

Line 2524: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);

2520: --
2521: IF l_bal_info_rec.info_id = 'INFO1' THEN
2522: l_rep_code_rec.info1 := fnd_number.number_to_canonical(l_amount);
2523: ELSIF l_bal_info_rec.info_id = 'INFO2' THEN
2524: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2525: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2526: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2527: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2528: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);

Line 2526: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);

2522: l_rep_code_rec.info1 := fnd_number.number_to_canonical(l_amount);
2523: ELSIF l_bal_info_rec.info_id = 'INFO2' THEN
2524: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2525: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2526: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2527: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2528: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2529: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2530: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);

Line 2528: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);

2524: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2525: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2526: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2527: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2528: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2529: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2530: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);
2531: ELSIF l_bal_info_rec.info_id = 'INFO6' THEN
2532: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);

Line 2530: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);

2526: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2527: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2528: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2529: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2530: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);
2531: ELSIF l_bal_info_rec.info_id = 'INFO6' THEN
2532: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);
2533: END IF;
2534: END LOOP;

Line 2532: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);

2528: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2529: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2530: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);
2531: ELSIF l_bal_info_rec.info_id = 'INFO6' THEN
2532: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);
2533: END IF;
2534: END LOOP;
2535: --
2536: --

Line 2624: -- l_rrv_rec.result_value := fnd_number.number_to_canonical(l_rrv_rec.result_value);

2620: END IF;
2621: --
2622: -- IF l_rrv_rec.dtype IN ('M','N') THEN
2623: --
2624: -- l_rrv_rec.result_value := fnd_number.number_to_canonical(l_rrv_rec.result_value);
2625: -- END IF;
2626: --
2627: --
2628: -- Store value against correct information column.

Line 2662: l_rep_code_rec.amount := fnd_number.number_to_canonical(-1 * fnd_number.canonical_to_number(l_rrv_rec.result_value));

2658: ELSIF l_rrv_rec.info_id = 'INFO6' THEN
2659: l_rep_code_rec.info6 := l_rrv_rec.result_value;
2660: ELSIF l_rrv_rec.info_id = 'AMOUNT' THEN
2661: IF is_EA_classification(l_rrv_rec.element_type, g_report_date) THEN
2662: l_rep_code_rec.amount := fnd_number.number_to_canonical(-1 * fnd_number.canonical_to_number(l_rrv_rec.result_value));
2663: ELSE
2664: l_rep_code_rec.amount := l_rrv_rec.result_value;
2665: END IF;
2666: END IF;

Line 2779: HAVING SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) < 1000;

2775: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
2776: AND rep_cde.action_information1 = 'ASG_REP_CODE_INFO'
2777: GROUP BY le_lu.action_information2
2778: ,asg_act.action_information5
2779: HAVING SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) < 1000;
2780: --
2781: CURSOR csr_ASGACT
2782: (p_payroll_action_id IN NUMBER
2783: ,p_legal_employer_id IN VARCHAR2

Line 2845: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount

2841: SELECT asg_act.action_information2 legal_employer_id
2842: ,asg_act.action_information5 person_id
2843: ,asg_act.action_information6 tax_municipality
2844: ,rep_cde.action_information2 code
2845: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
2846: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4

Line 2846: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1

2842: ,asg_act.action_information5 person_id
2843: ,asg_act.action_information6 tax_municipality
2844: ,rep_cde.action_information2 code
2845: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
2846: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
2850: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5

Line 2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2

2843: ,asg_act.action_information6 tax_municipality
2844: ,rep_cde.action_information2 code
2845: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
2846: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
2850: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
2851: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6

Line 2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3

2844: ,rep_cde.action_information2 code
2845: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
2846: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
2850: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
2851: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
2852: ,rep_cde.action_information10 seaman_component

Line 2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4

2845: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
2846: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
2850: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
2851: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
2852: ,rep_cde.action_information10 seaman_component
2853: ,rep_cde.action_information11 cinfo1

Line 2850: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5

2846: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
2850: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
2851: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
2852: ,rep_cde.action_information10 seaman_component
2853: ,rep_cde.action_information11 cinfo1
2854: ,rep_cde.action_information12 cinfo2

Line 2851: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6

2847: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
2848: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
2849: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
2850: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
2851: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
2852: ,rep_cde.action_information10 seaman_component
2853: ,rep_cde.action_information11 cinfo1
2854: ,rep_cde.action_information12 cinfo2
2855: ,rep_cde.action_information13 cinfo3

Line 3025: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)

3021: ,p_action_information1 => 'AUDIT_REP_SUMMARY'
3022: ,p_action_information2 => l_cde_rec.legal_employer_id
3023: ,p_action_information3 => l_cde_rec.person_id
3024: ,p_action_information4 => l_cde_rec.code
3025: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3026: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))

Line 3026: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))

3022: ,p_action_information2 => l_cde_rec.legal_employer_id
3023: ,p_action_information3 => l_cde_rec.person_id
3024: ,p_action_information4 => l_cde_rec.code
3025: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3026: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3030: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))

Line 3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))

3023: ,p_action_information3 => l_cde_rec.person_id
3024: ,p_action_information4 => l_cde_rec.code
3025: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3026: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3030: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3031: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))

Line 3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))

3024: ,p_action_information4 => l_cde_rec.code
3025: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3026: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3030: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3031: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3032: ,p_action_information12 => l_cde_rec.tax_municipality

Line 3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))

3025: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3026: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3030: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3031: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3032: ,p_action_information12 => l_cde_rec.tax_municipality
3033: ,p_action_information13 => l_cde_rec.seaman_component);

Line 3030: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))

3026: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3030: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3031: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3032: ,p_action_information12 => l_cde_rec.tax_municipality
3033: ,p_action_information13 => l_cde_rec.seaman_component);
3034: END LOOP;

Line 3031: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))

3027: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3028: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3029: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3030: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3031: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3032: ,p_action_information12 => l_cde_rec.tax_municipality
3033: ,p_action_information13 => l_cde_rec.seaman_component);
3034: END LOOP;
3035: --

Line 3122: ,fnd_number.canonical_to_number(summ_cde.action_information5) amount

3118: ,p_person_id IN VARCHAR2
3119: ,p_tax_municipality IN VARCHAR2
3120: ,l_seaman_status IN VARCHAR2 ) IS
3121: SELECT summ_cde.action_information4 code
3122: ,fnd_number.canonical_to_number(summ_cde.action_information5) amount
3123: ,summ_cde.action_information6 info1
3124: ,summ_cde.action_information7 info2
3125: ,summ_cde.action_information8 info3
3126: ,summ_cde.action_information9 info4

Line 3277: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1), lg_format_mask);

3273: l_xml_element_count := l_xml_element_count + 1;
3274: --
3275: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3276: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
3277: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1), lg_format_mask);
3278: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
3279: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
3280:
3281: ELSE

Line 3302: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2),lg_format_mask);

3298: l_xml_element_count := l_xml_element_count + 1;
3299: --
3300: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3301: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
3302: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2),lg_format_mask);
3303: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
3304: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
3305: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info2),'DD-MM-YYYY');
3306: ELSE

Line 3327: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3), lg_format_mask);

3323: l_xml_element_count := l_xml_element_count + 1;
3324: --
3325: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3326: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
3327: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3), lg_format_mask);
3328: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
3329: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
3330: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info3),'DD-MM-YYYY');
3331: ELSE

Line 3352: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4),lg_format_mask);

3348: l_xml_element_count := l_xml_element_count + 1;
3349: --
3350: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3351: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
3352: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4),lg_format_mask);
3353: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
3354: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
3355: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info4),'DD-MM-YYYY');
3356: ELSE

Line 3377: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5), lg_format_mask);

3373: l_xml_element_count := l_xml_element_count + 1;
3374: --
3375: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3376: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
3377: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5), lg_format_mask);
3378: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
3379: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
3380: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info5),'DD-MM-YYYY');
3381: ELSE

Line 3402: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6),lg_format_mask);

3398: l_xml_element_count := l_xml_element_count + 1;
3399: --
3400: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3401: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
3402: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6),lg_format_mask);
3403: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
3404: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
3405: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info6),'DD-MM-YYYY');
3406: ELSE

Line 3505: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse

3501: ,le_lu_tm.action_information5 local_unit
3502: ,le_lu_tm.action_information6 tax_municipality_id
3503: ,le_lu_tm.action_information7 tax_municipality
3504: ,le_lu_tm.action_information8 ni_zone_arc
3505: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
3506: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
3507: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
3508: FROM pay_action_information le_lu_tm
3509: WHERE le_lu_tm.action_context_type = 'PA'

Line 3506: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse

3502: ,le_lu_tm.action_information6 tax_municipality_id
3503: ,le_lu_tm.action_information7 tax_municipality
3504: ,le_lu_tm.action_information8 ni_zone_arc
3505: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
3506: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
3507: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
3508: FROM pay_action_information le_lu_tm
3509: WHERE le_lu_tm.action_context_type = 'PA'
3510: AND le_lu_tm.action_context_id = l_payroll_action_id

Line 3507: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse

3503: ,le_lu_tm.action_information7 tax_municipality
3504: ,le_lu_tm.action_information8 ni_zone_arc
3505: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
3506: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
3507: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
3508: FROM pay_action_information le_lu_tm
3509: WHERE le_lu_tm.action_context_type = 'PA'
3510: AND le_lu_tm.action_context_id = l_payroll_action_id
3511: AND le_lu_tm.action_information_category = 'EMEA REPORT INFORMATION'

Line 3552: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1

3548: CURSOR csr_LE_SI_BAL_SUMMARY
3549: (l_payroll_action_id IN NUMBER
3550: ,p_legal_employer_id IN VARCHAR2
3551: ,p_si_status IN VARCHAR2) IS
3552: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
3553: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5

Line 3553: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2

3549: (l_payroll_action_id IN NUMBER
3550: ,p_legal_employer_id IN VARCHAR2
3551: ,p_si_status IN VARCHAR2) IS
3552: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
3553: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total

Line 3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3

3550: ,p_legal_employer_id IN VARCHAR2
3551: ,p_si_status IN VARCHAR2) IS
3552: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
3553: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1

Line 3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4

3551: ,p_si_status IN VARCHAR2) IS
3552: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
3553: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2

Line 3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5

3552: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
3553: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3

Line 3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total

3553: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4

Line 3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1

3554: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5

Line 3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2

3555: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total

Line 3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3

3556: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax

Line 3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4

3557: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base

Line 3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5

3558: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct

Line 3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total

3559: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl

Line 3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax

3560: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage

Line 3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base

3561: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount

Line 3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct

3562: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes

Line 3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl

3563: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes

Line 3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage

3564: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
3572: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes

Line 3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount

3565: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
3572: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
3573: FROM pay_action_information le_si_bals

Line 3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes

3566: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
3572: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
3573: FROM pay_action_information le_si_bals
3574: WHERE le_si_bals.action_context_type = 'PA'

Line 3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes

3567: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
3572: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
3573: FROM pay_action_information le_si_bals
3574: WHERE le_si_bals.action_context_type = 'PA'
3575: AND le_si_bals.action_context_id = l_payroll_action_id

Line 3572: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes

3568: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
3569: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
3570: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
3571: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
3572: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
3573: FROM pay_action_information le_si_bals
3574: WHERE le_si_bals.action_context_type = 'PA'
3575: AND le_si_bals.action_context_id = l_payroll_action_id
3576: AND le_si_bals.action_information_category = 'EMEA REPORT INFORMATION'

Line 3587: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)

3583: ,p_legal_employer_id IN VARCHAR2
3584: ,p_si_status IN VARCHAR2) IS
3585: SELECT COUNT (DISTINCT asg_act.action_information5) certificates
3586: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3587: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3588: ,0)) a_zone1
3589: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3590: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3591: ,0)) a_zone2

Line 3590: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)

3586: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3587: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3588: ,0)) a_zone1
3589: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3590: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3591: ,0)) a_zone2
3592: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3593: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3594: ,0)) a_zone3

Line 3593: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)

3589: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3590: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3591: ,0)) a_zone2
3592: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3593: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3594: ,0)) a_zone3
3595: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3596: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3597: ,0)) a_zone4

Line 3596: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)

3592: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3593: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3594: ,0)) a_zone3
3595: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3596: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3597: ,0)) a_zone4
3598: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3599: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3600: ,0)) a_zone5

Line 3599: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)

3595: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3596: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3597: ,0)) a_zone4
3598: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3599: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3600: ,0)) a_zone5
3601: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3602: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3603: ,0)) bl_zone1

Line 3602: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

3598: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3599: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
3600: ,0)) a_zone5
3601: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3602: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3603: ,0)) bl_zone1
3604: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3605: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3606: ,0)) bl_zone2

Line 3605: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

3601: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3602: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3603: ,0)) bl_zone1
3604: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3605: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3606: ,0)) bl_zone2
3607: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3608: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3609: ,0)) bl_zone3

Line 3608: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

3604: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3605: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3606: ,0)) bl_zone2
3607: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3608: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3609: ,0)) bl_zone3
3610: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3611: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3612: ,0)) bl_zone4

Line 3611: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

3607: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3608: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3609: ,0)) bl_zone3
3610: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3611: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3612: ,0)) bl_zone4
3613: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3614: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3615: ,0)) bl_zone5

Line 3614: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

3610: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3611: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3612: ,0)) bl_zone4
3613: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3614: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3615: ,0)) bl_zone5
3616: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3617: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
3618: ,0)) sum_zone1

Line 3617: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)

3613: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3614: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
3615: ,0)) bl_zone5
3616: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3617: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
3618: ,0)) sum_zone1
3619: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3620: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
3621: ,0)) sum_zone2

Line 3620: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)

3616: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3617: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
3618: ,0)) sum_zone1
3619: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3620: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
3621: ,0)) sum_zone2
3622: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3623: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
3624: ,0)) sum_zone3

Line 3623: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)

3619: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3620: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
3621: ,0)) sum_zone2
3622: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3623: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
3624: ,0)) sum_zone3
3625: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3626: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
3627: ,0)) sum_zone4

Line 3626: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)

3622: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3623: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
3624: ,0)) sum_zone3
3625: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3626: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
3627: ,0)) sum_zone4
3628: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3629: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
3630: ,0)) sum_zone5

Line 3629: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)

3625: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3626: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
3627: ,0)) sum_zone4
3628: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3629: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
3630: ,0)) sum_zone5
3631: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3632: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
3633: ,0)) sum_totals

Line 3632: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)

3628: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3629: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
3630: ,0)) sum_zone5
3631: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
3632: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
3633: ,0)) sum_totals
3634: FROM pay_assignment_actions paa
3635: ,pay_action_information le_lu
3636: ,pay_action_information asg_act

Line 3671: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)

3667: (l_payroll_action_id IN NUMBER
3668: ,p_legal_employer_id IN VARCHAR2
3669: ,p_si_status IN VARCHAR2) IS
3670: SELECT SUM(DECODE(asg_act.action_information7
3671: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
3672: , 0)) a_earnings
3673: ,SUM(DECODE(asg_act.action_information7
3674: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
3675: , 0)) bl_earnings

Line 3674: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)

3670: SELECT SUM(DECODE(asg_act.action_information7
3671: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
3672: , 0)) a_earnings
3673: ,SUM(DECODE(asg_act.action_information7
3674: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
3675: , 0)) bl_earnings
3676: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
3677: FROM pay_assignment_actions paa
3678: ,pay_action_information le_lu

Line 3676: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings

3672: , 0)) a_earnings
3673: ,SUM(DECODE(asg_act.action_information7
3674: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
3675: , 0)) bl_earnings
3676: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
3677: FROM pay_assignment_actions paa
3678: ,pay_action_information le_lu
3679: ,pay_action_information asg_act
3680: ,pay_action_information rep_cde

Line 3717: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount

3713: ,p_si_status IN VARCHAR2) IS
3714: SELECT asg_act.action_information2 legal_employer_id
3715: ,le_lu.action_information3 si_status
3716: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
3717: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3718: FROM pay_assignment_actions paa
3719: ,pay_action_information le_lu
3720: ,pay_action_information asg_act
3721: ,pay_action_information rep_cde

Line 3843: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_rec.le_economic_aid),lg_format_mask);

3839: g_xml_element_table(l_xml_element_count).tagvalue := l_le_si_rec.si_status;
3840: l_xml_element_count := l_xml_element_count + 1;
3841: -- ORID 27604 Economic Aid Received - 2007/2008 Changes
3842: g_xml_element_table(l_xml_element_count).tagname := 'ECONOMIC_AID';
3843: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_rec.le_economic_aid),lg_format_mask);
3844: l_xml_element_count := l_xml_element_count + 1;
3845: --
3846: g_xml_element_table(l_xml_element_count).tagname := 'LEGAL_EMPLOYER_ADDRESS1';
3847: g_xml_element_table(l_xml_element_count).tagvalue := l_le_si_rec.le_addr1;

Line 3924: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone1),lg_format_mask);

3920: FETCH csr_LE_SI_BAL_SUMMARY INTO l_le_si_bal_rec;
3921: CLOSE csr_LE_SI_BAL_SUMMARY;
3922: --
3923: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE1';
3924: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone1),lg_format_mask);
3925: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3926: l_xml_element_count := l_xml_element_count + 1;
3927: --
3928: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE2';

Line 3929: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone2),lg_format_mask);

3925: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3926: l_xml_element_count := l_xml_element_count + 1;
3927: --
3928: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE2';
3929: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone2),lg_format_mask);
3930: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3931: l_xml_element_count := l_xml_element_count + 1;
3932: --
3933: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE3';

Line 3934: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone3),lg_format_mask);

3930: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3931: l_xml_element_count := l_xml_element_count + 1;
3932: --
3933: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE3';
3934: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone3),lg_format_mask);
3935: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3936: l_xml_element_count := l_xml_element_count + 1;
3937: --
3938: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE4';

Line 3939: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone4),lg_format_mask);

3935: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3936: l_xml_element_count := l_xml_element_count + 1;
3937: --
3938: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE4';
3939: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone4),lg_format_mask);
3940: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3941: l_xml_element_count := l_xml_element_count + 1;
3942: --
3943: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE5';

Line 3944: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone5),lg_format_mask);

3940: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3941: l_xml_element_count := l_xml_element_count + 1;
3942: --
3943: g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE5';
3944: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_zone5),lg_format_mask);
3945: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3946: l_xml_element_count := l_xml_element_count + 1;
3947: --
3948: g_xml_element_table(l_xml_element_count).tagname := 'EC_TOTAL';

Line 3949: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_total),lg_format_mask);

3945: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3946: l_xml_element_count := l_xml_element_count + 1;
3947: --
3948: g_xml_element_table(l_xml_element_count).tagname := 'EC_TOTAL';
3949: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_total),lg_format_mask);
3950: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3951: l_xml_element_count := l_xml_element_count + 1;
3952: --
3953: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE1';

Line 3954: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone1),lg_format_mask);

3950: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3951: l_xml_element_count := l_xml_element_count + 1;
3952: --
3953: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE1';
3954: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone1),lg_format_mask);
3955: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3956: l_xml_element_count := l_xml_element_count + 1;
3957: --
3958: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE2';

Line 3959: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone2),lg_format_mask);

3955: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3956: l_xml_element_count := l_xml_element_count + 1;
3957: --
3958: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE2';
3959: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone2),lg_format_mask);
3960: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3961: l_xml_element_count := l_xml_element_count + 1;
3962: --
3963: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE3';

Line 3964: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone3),lg_format_mask);

3960: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3961: l_xml_element_count := l_xml_element_count + 1;
3962: --
3963: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE3';
3964: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone3),lg_format_mask);
3965: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3966: l_xml_element_count := l_xml_element_count + 1;
3967: --
3968: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE4';

Line 3969: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone4),lg_format_mask);

3965: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3966: l_xml_element_count := l_xml_element_count + 1;
3967: --
3968: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE4';
3969: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone4),lg_format_mask);
3970: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3971: l_xml_element_count := l_xml_element_count + 1;
3972: --
3973: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE5';

Line 3974: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone5),lg_format_mask);

3970: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3971: l_xml_element_count := l_xml_element_count + 1;
3972: --
3973: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE5';
3974: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_zone5),lg_format_mask);
3975: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3976: l_xml_element_count := l_xml_element_count + 1;
3977: --
3978: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_TOTAL';

Line 3979: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_total),lg_format_mask);

3975: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3976: l_xml_element_count := l_xml_element_count + 1;
3977: --
3978: g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_TOTAL';
3979: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_o62_ni_total),lg_format_mask);
3980: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3981: l_xml_element_count := l_xml_element_count + 1;
3982: --
3983: -- Total witholding Tax

Line 3986: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.tax),lg_format_mask);

3982: --
3983: -- Total witholding Tax
3984: --
3985: g_xml_element_table(l_xml_element_count).tagname := 'A_TAX';
3986: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.tax),lg_format_mask);
3987: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3988: l_xml_element_count := l_xml_element_count + 1;
3989: --
3990: -- ORID 22225 - Gross Base for Employees from USA/Canada

Line 3993: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_spcl_pct_base),lg_format_mask);

3989: --
3990: -- ORID 22225 - Gross Base for Employees from USA/Canada
3991: --
3992: g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT_BASE';
3993: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_spcl_pct_base),lg_format_mask);
3994: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3995: l_xml_element_count := l_xml_element_count + 1;
3996: --
3997: g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT';

Line 3998: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.foreign_special_percentage),lg_format_mask);

3994: g_xml_element_table(l_xml_element_count).tagtype := 'A';
3995: l_xml_element_count := l_xml_element_count + 1;
3996: --
3997: g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT';
3998: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.foreign_special_percentage),lg_format_mask);
3999: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4000: l_xml_element_count := l_xml_element_count + 1;
4001: --
4002: g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT_AMOUNT';

Line 4003: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_spcl_pct),lg_format_mask);

3999: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4000: l_xml_element_count := l_xml_element_count + 1;
4001: --
4002: g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT_AMOUNT';
4003: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_spcl_pct),lg_format_mask);
4004: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4005: l_xml_element_count := l_xml_element_count + 1;
4006: -- ORID 25415 Total number of months Foreign Employees on Monthly Rate
4007: g_xml_element_table(l_xml_element_count).tagname := 'FE_MONTHS';

Line 4024: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_reimb_spcl_base),lg_format_mask);

4020: --
4021: --Reimbursement Base Employees From USA/Canada ORID-27612 - 2007/2008 Changes
4022: --
4023: g_xml_element_table(l_xml_element_count).tagname := 'FE_REIMBURSEMENT_BASE';
4024: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_reimb_spcl_base),lg_format_mask);
4025: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4026: l_xml_element_count := l_xml_element_count + 1;
4027:
4028: -- Net Base for Employees from USA/Canada - 2007/2008 Changes

Line 4035: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_total),lg_format_mask);

4031: g_xml_element_table(l_xml_element_count).tagvalue := to_char(l_spcl_net_base,lg_format_mask);
4032: l_xml_element_count := l_xml_element_count + 1;
4033: --ORID 28103 Total EC Base - 2007/2008 Changes
4034: g_xml_element_table(l_xml_element_count).tagname := 'TOT_EC_BASE';
4035: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.emp_contr_ni_total),lg_format_mask);
4036: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4037: l_xml_element_count := l_xml_element_count + 1;
4038: -- ORID 28104 Total Pension Base
4039: g_xml_element_table(l_xml_element_count).tagname := 'TOT_PEN_BASE';

Line 4040: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.tot_pension_bse),lg_format_mask);

4036: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4037: l_xml_element_count := l_xml_element_count + 1;
4038: -- ORID 28104 Total Pension Base
4039: g_xml_element_table(l_xml_element_count).tagname := 'TOT_PEN_BASE';
4040: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_bal_rec.tot_pension_bse),lg_format_mask);
4041: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4042: l_xml_element_count := l_xml_element_count + 1;
4043: --
4044: --Gross Employer Contribution Base - 2007/2008 Changes

Line 4336: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse

4332: ,le_lu_tm.action_information5 local_unit
4333: ,le_lu_tm.action_information6 tax_municipality_id
4334: ,le_lu_tm.action_information7 tax_municipality
4335: ,le_lu_tm.action_information8 ni_zone_arc
4336: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
4337: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
4338: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
4339: FROM pay_action_information le_lu_tm
4340: WHERE le_lu_tm.action_context_type = 'PA'

Line 4337: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse

4333: ,le_lu_tm.action_information6 tax_municipality_id
4334: ,le_lu_tm.action_information7 tax_municipality
4335: ,le_lu_tm.action_information8 ni_zone_arc
4336: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
4337: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
4338: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
4339: FROM pay_action_information le_lu_tm
4340: WHERE le_lu_tm.action_context_type = 'PA'
4341: AND le_lu_tm.action_context_id = l_payroll_action_id

Line 4338: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse

4334: ,le_lu_tm.action_information7 tax_municipality
4335: ,le_lu_tm.action_information8 ni_zone_arc
4336: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
4337: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
4338: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
4339: FROM pay_action_information le_lu_tm
4340: WHERE le_lu_tm.action_context_type = 'PA'
4341: AND le_lu_tm.action_context_id = l_payroll_action_id
4342: AND le_lu_tm.action_information_category = 'EMEA REPORT INFORMATION'

Line 4383: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1

4379: CURSOR csr_LE_SI_BAL_SUMMARY
4380: (l_payroll_action_id IN NUMBER
4381: ,p_legal_employer_id IN VARCHAR2
4382: ,p_si_status IN VARCHAR2) IS
4383: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4384: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5

Line 4384: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2

4380: (l_payroll_action_id IN NUMBER
4381: ,p_legal_employer_id IN VARCHAR2
4382: ,p_si_status IN VARCHAR2) IS
4383: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4384: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total

Line 4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3

4381: ,p_legal_employer_id IN VARCHAR2
4382: ,p_si_status IN VARCHAR2) IS
4383: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4384: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1

Line 4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4

4382: ,p_si_status IN VARCHAR2) IS
4383: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4384: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2

Line 4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5

4383: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4384: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3

Line 4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total

4384: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4

Line 4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1

4385: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5

Line 4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2

4386: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total

Line 4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3

4387: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax

Line 4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4

4388: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base

Line 4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5

4389: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct

Line 4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total

4390: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl

Line 4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax

4391: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage

Line 4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base

4392: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount

Line 4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct

4393: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes

Line 4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl

4394: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes

Line 4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage

4395: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4403: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes

Line 4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount

4396: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4403: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4404: FROM pay_action_information le_si_bals

Line 4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes

4397: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4403: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4404: FROM pay_action_information le_si_bals
4405: WHERE le_si_bals.action_context_type = 'PA'

Line 4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes

4398: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4403: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4404: FROM pay_action_information le_si_bals
4405: WHERE le_si_bals.action_context_type = 'PA'
4406: AND le_si_bals.action_context_id = l_payroll_action_id

Line 4403: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes

4399: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4400: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4401: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4402: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4403: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4404: FROM pay_action_information le_si_bals
4405: WHERE le_si_bals.action_context_type = 'PA'
4406: AND le_si_bals.action_context_id = l_payroll_action_id
4407: AND le_si_bals.action_information_category = 'EMEA REPORT INFORMATION'

Line 4418: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)

4414: ,p_legal_employer_id IN VARCHAR2
4415: ,p_si_status IN VARCHAR2) IS
4416: SELECT COUNT (DISTINCT asg_act.action_information5) certificates
4417: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4418: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4419: ,0)) a_zone1
4420: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4421: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4422: ,0)) a_zone2

Line 4421: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)

4417: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4418: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4419: ,0)) a_zone1
4420: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4421: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4422: ,0)) a_zone2
4423: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4424: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4425: ,0)) a_zone3

Line 4424: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)

4420: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4421: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4422: ,0)) a_zone2
4423: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4424: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4425: ,0)) a_zone3
4426: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4427: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4428: ,0)) a_zone4

Line 4427: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)

4423: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4424: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4425: ,0)) a_zone3
4426: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4427: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4428: ,0)) a_zone4
4429: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4430: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4431: ,0)) a_zone5

Line 4430: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)

4426: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4427: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4428: ,0)) a_zone4
4429: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4430: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4431: ,0)) a_zone5
4432: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4433: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4434: ,0)) bl_zone1

Line 4433: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

4429: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4430: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4431: ,0)) a_zone5
4432: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4433: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4434: ,0)) bl_zone1
4435: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4436: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4437: ,0)) bl_zone2

Line 4436: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

4432: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4433: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4434: ,0)) bl_zone1
4435: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4436: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4437: ,0)) bl_zone2
4438: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4439: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4440: ,0)) bl_zone3

Line 4439: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

4435: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4436: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4437: ,0)) bl_zone2
4438: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4439: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4440: ,0)) bl_zone3
4441: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4442: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4443: ,0)) bl_zone4

Line 4442: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

4438: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4439: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4440: ,0)) bl_zone3
4441: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4442: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4443: ,0)) bl_zone4
4444: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4445: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4446: ,0)) bl_zone5

Line 4445: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)

4441: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4442: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4443: ,0)) bl_zone4
4444: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4445: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4446: ,0)) bl_zone5
4447: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4448: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
4449: ,0)) sum_zone1

Line 4448: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)

4444: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4445: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4446: ,0)) bl_zone5
4447: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4448: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
4449: ,0)) sum_zone1
4450: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4451: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
4452: ,0)) sum_zone2

Line 4451: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)

4447: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4448: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
4449: ,0)) sum_zone1
4450: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4451: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
4452: ,0)) sum_zone2
4453: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4454: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
4455: ,0)) sum_zone3

Line 4454: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)

4450: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4451: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
4452: ,0)) sum_zone2
4453: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4454: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
4455: ,0)) sum_zone3
4456: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4457: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
4458: ,0)) sum_zone4

Line 4457: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)

4453: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4454: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
4455: ,0)) sum_zone3
4456: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4457: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
4458: ,0)) sum_zone4
4459: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4460: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
4461: ,0)) sum_zone5

Line 4460: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)

4456: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4457: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
4458: ,0)) sum_zone4
4459: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4460: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
4461: ,0)) sum_zone5
4462: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4463: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4464: ,0)) sum_totals

Line 4463: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)

4459: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4460: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
4461: ,0)) sum_zone5
4462: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4463: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4464: ,0)) sum_totals
4465: FROM pay_assignment_actions paa
4466: ,pay_action_information le_lu
4467: ,pay_action_information asg_act

Line 4502: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)

4498: (l_payroll_action_id IN NUMBER
4499: ,p_legal_employer_id IN VARCHAR2
4500: ,p_si_status IN VARCHAR2) IS
4501: SELECT SUM(DECODE(asg_act.action_information7
4502: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
4503: , 0)) a_earnings
4504: ,SUM(DECODE(asg_act.action_information7
4505: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4506: , 0)) bl_earnings

Line 4505: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)

4501: SELECT SUM(DECODE(asg_act.action_information7
4502: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
4503: , 0)) a_earnings
4504: ,SUM(DECODE(asg_act.action_information7
4505: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4506: , 0)) bl_earnings
4507: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4508: FROM pay_assignment_actions paa
4509: ,pay_action_information le_lu

Line 4507: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings

4503: , 0)) a_earnings
4504: ,SUM(DECODE(asg_act.action_information7
4505: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4506: , 0)) bl_earnings
4507: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4508: FROM pay_assignment_actions paa
4509: ,pay_action_information le_lu
4510: ,pay_action_information asg_act
4511: ,pay_action_information rep_cde

Line 4548: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount

4544: ,p_si_status IN VARCHAR2) IS
4545: SELECT asg_act.action_information2 legal_employer_id
4546: ,le_lu.action_information3 si_status
4547: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
4548: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
4549: FROM pay_assignment_actions paa
4550: ,pay_action_information le_lu
4551: ,pay_action_information asg_act
4552: ,pay_action_information rep_cde

Line 4817: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_rec.le_economic_aid),lg_format_mask);

4813: -- Other subsidis received (to reduce excemption limit),
4814: -- same as in bi-monthly recording sheet, but total for the year
4815: --
4816: g_xml_element_table(l_xml_element_count).tagname := 'TilskuddAndreTerminoppgave-datadef-27604';
4817: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_rec.le_economic_aid),lg_format_mask);
4818: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="27604"';
4819: l_xml_element_count := l_xml_element_count + 1;
4820: --
4821: --

Line 5096: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount

5092: (l_payroll_action_id IN NUMBER
5093: ,p_legal_employer_id IN VARCHAR2
5094: ,l_person_id IN NUMBER) IS
5095: SELECT rep_cde.action_information3 code
5096: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount
5097: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
5098: FROM pay_action_information rep_cde
5099: ,pay_action_information aud_smr
5100: WHERE rep_cde.action_context_type = 'PA'

Line 5120: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1

5116: (l_payroll_action_id IN NUMBER
5117: ,p_legal_employer_id IN VARCHAR2
5118: ,l_person_id IN NUMBER
5119: ,l_eoy_code IN VARCHAR2) IS
5120: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
5121: FROM pay_action_information rep_cde
5122: ,pay_action_information aud_smr
5123: WHERE rep_cde.action_context_type = 'PA'
5124: AND rep_cde.action_context_id = l_payroll_action_id

Line 5166: ,fnd_number.canonical_to_number(summ_cde.action_information5) amount

5162: (l_payroll_action_id IN NUMBER
5163: ,p_legal_employer_id IN VARCHAR2
5164: ,p_person_id IN VARCHAR2 ) IS
5165: SELECT summ_cde.action_information4 code
5166: ,fnd_number.canonical_to_number(summ_cde.action_information5) amount
5167: ,summ_cde.action_information6 info1
5168: ,summ_cde.action_information7 info2
5169: ,summ_cde.action_information8 info3
5170: ,summ_cde.action_information9 info4

Line 5523: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1), lg_format_mask);

5519: l_xml_element_count := l_xml_element_count + 1;
5520: --
5521: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5522: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
5523: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1), lg_format_mask);
5524: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
5525: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
5526: ELSE
5527: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info1;

Line 5547: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2),lg_format_mask);

5543: l_xml_element_count := l_xml_element_count + 1;
5544: --
5545: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5546: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
5547: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2),lg_format_mask);
5548: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
5549: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
5550: ELSE
5551: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;

Line 5571: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3), lg_format_mask);

5567: l_xml_element_count := l_xml_element_count + 1;
5568: --
5569: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5570: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
5571: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3), lg_format_mask);
5572: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
5573: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
5574: ELSE
5575: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;

Line 5595: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4),lg_format_mask);

5591: l_xml_element_count := l_xml_element_count + 1;
5592: --
5593: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5594: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
5595: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4),lg_format_mask);
5596: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
5597: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
5598: ELSE
5599: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;

Line 5619: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5), lg_format_mask);

5615: l_xml_element_count := l_xml_element_count + 1;
5616: --
5617: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5618: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
5619: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5), lg_format_mask);
5620: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
5621: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
5622: ELSE
5623: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;

Line 5643: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6),lg_format_mask);

5639: l_xml_element_count := l_xml_element_count + 1;
5640: --
5641: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
5642: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
5643: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6),lg_format_mask);
5644: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
5645: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
5646: ELSE
5647: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;

Line 5753: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount

5749: (l_payroll_action_id IN NUMBER
5750: ,p_legal_employer_id IN VARCHAR2
5751: ,l_person_id IN NUMBER) IS
5752: SELECT rep_cde.action_information3 code
5753: ,SUM(fnd_number.canonical_to_number(aud_smr.action_information5)) amount
5754: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
5755: FROM pay_action_information rep_cde
5756: ,pay_action_information aud_smr
5757: WHERE rep_cde.action_context_type = 'PA'

Line 5777: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1

5773: (l_payroll_action_id IN NUMBER
5774: ,p_legal_employer_id IN VARCHAR2
5775: ,l_person_id IN NUMBER
5776: ,l_eoy_code IN VARCHAR2) IS
5777: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
5778: FROM pay_action_information rep_cde
5779: ,pay_action_information aud_smr
5780: WHERE rep_cde.action_context_type = 'PA'
5781: AND rep_cde.action_context_id = l_payroll_action_id

Line 5823: ,fnd_number.canonical_to_number(summ_cde.action_information5) amount

5819: (l_payroll_action_id IN NUMBER
5820: ,p_legal_employer_id IN VARCHAR2
5821: ,p_person_id IN VARCHAR2 ) IS
5822: SELECT summ_cde.action_information4 code
5823: ,fnd_number.canonical_to_number(summ_cde.action_information5) amount
5824: ,summ_cde.action_information6 info1
5825: ,summ_cde.action_information7 info2
5826: ,summ_cde.action_information8 info3
5827: ,summ_cde.action_information9 info4

Line 6476: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6472: FOR l_summ_var IN 1..6 LOOP
6473: IF g_summary_code_orid(l_summ_var).orid_value = '25438' THEN
6474: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop2-datadef-25438';
6475: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6476: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6477: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6478: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6479: ELSE
6480: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6493: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6489: FOR l_summ_var IN 1..6 LOOP
6490: IF g_summary_code_orid(l_summ_var).orid_value = '25439' THEN
6491: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAntall-datadef-25439';
6492: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6493: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6494: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6495: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6496: ELSE
6497: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6511: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6507: FOR l_summ_var IN 1..6 LOOP
6508: IF g_summary_code_orid(l_summ_var).orid_value = '25440' THEN
6509: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode1-datadef-25440';
6510: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6511: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6512: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6513: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6514: ELSE
6515: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6529: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6525: FOR l_summ_var IN 1..6 LOOP
6526: IF g_summary_code_orid(l_summ_var).orid_value = '25441' THEN
6527: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode2-datadef-25441';
6528: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6529: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6530: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6531: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6532: ELSE
6533: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6547: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6543: FOR l_summ_var IN 1..6 LOOP
6544: IF g_summary_code_orid(l_summ_var).orid_value = '25442' THEN
6545: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAr-datadef-25442';
6546: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6547: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6548: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6549: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6550: ELSE
6551: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6565: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6561: FOR l_summ_var IN 1..6 LOOP
6562: IF g_summary_code_orid(l_summ_var).orid_value = '25443' THEN
6563: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop3-datadef-25443 ';
6564: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6565: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6566: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6567: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6568: ELSE
6569: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6583: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6579: FOR l_summ_var IN 1..6 LOOP
6580: IF g_summary_code_orid(l_summ_var).orid_value = '25444' THEN
6581: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettFraDato-datadef-25444';
6582: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6583: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6584: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6585: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6586: ELSE
6587: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6601: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6597: FOR l_summ_var IN 1..6 LOOP
6598: IF g_summary_code_orid(l_summ_var).orid_value = '25445' THEN
6599: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettTilDato-datadef-25445';
6600: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6601: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6602: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6603: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6604: ELSE
6605: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6619: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6615: FOR l_summ_var IN 1..6 LOOP
6616: IF g_summary_code_orid(l_summ_var).orid_value = '25446' THEN
6617: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop4-datadef-25446';
6618: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6619: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6620: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6621: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6622: ELSE
6623: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6637: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6633: FOR l_summ_var IN 1..6 LOOP
6634: IF g_summary_code_orid(l_summ_var).orid_value = '25447' THEN
6635: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop5-datadef-25447';
6636: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6637: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6638: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6639: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6640: ELSE
6641: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6655: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6651: FOR l_summ_var IN 1..6 LOOP
6652: IF g_summary_code_orid(l_summ_var).orid_value = '25448' THEN
6653: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning1-datadef-25448';
6654: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6655: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6656: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6657: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6658: ELSE
6659: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6673: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6669: FOR l_summ_var IN 1..6 LOOP
6670: IF g_summary_code_orid(l_summ_var).orid_value = '25449' THEN
6671: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning2-datadef-25449';
6672: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6673: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6674: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6675: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6676: ELSE
6677: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;

Line 6691: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);

6687: FOR l_summ_var IN 1..6 LOOP
6688: IF g_summary_code_orid(l_summ_var).orid_value = '25450' THEN
6689: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning3-datadef-25450';
6690: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
6691: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(g_summary_code_orid(l_summ_var).info_data), lg_format_mask);
6692: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
6693: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
6694: ELSE
6695: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;