[Home] [Help]
1616: ,p_action_information5 => l_rec2.local_unit
1617: ,p_action_information6 => l_rec2.tax_municipality_id
1618: ,p_action_information7 => l_rec2.tax_municipality
1619: ,p_action_information8 => l_ni_zone_arc
1620: ,p_action_information9 => fnd_number.number_to_canonical(l_emp_contr_bse) -- 2007/2008 changes
1621: ,p_action_information10 => fnd_number.number_to_canonical(l_reimb_bse) -- 2007/2008 changes
1622: ,p_action_information11 => fnd_number.number_to_canonical(l_pension_bse) -- 2007/2008 Changes
1623: ,p_action_information12 => l_rec2.org_number); --Bug 14671801
1624: --
1617: ,p_action_information6 => l_rec2.tax_municipality_id
1618: ,p_action_information7 => l_rec2.tax_municipality
1619: ,p_action_information8 => l_ni_zone_arc
1620: ,p_action_information9 => fnd_number.number_to_canonical(l_emp_contr_bse) -- 2007/2008 changes
1621: ,p_action_information10 => fnd_number.number_to_canonical(l_reimb_bse) -- 2007/2008 changes
1622: ,p_action_information11 => fnd_number.number_to_canonical(l_pension_bse) -- 2007/2008 Changes
1623: ,p_action_information12 => l_rec2.org_number); --Bug 14671801
1624: --
1625:
1618: ,p_action_information7 => l_rec2.tax_municipality
1619: ,p_action_information8 => l_ni_zone_arc
1620: ,p_action_information9 => fnd_number.number_to_canonical(l_emp_contr_bse) -- 2007/2008 changes
1621: ,p_action_information10 => fnd_number.number_to_canonical(l_reimb_bse) -- 2007/2008 changes
1622: ,p_action_information11 => fnd_number.number_to_canonical(l_pension_bse) -- 2007/2008 Changes
1623: ,p_action_information12 => l_rec2.org_number); --Bug 14671801
1624: --
1625:
1626: -- Retrieve balances for:-
1663: ,p_action_information_category => 'EMEA REPORT INFORMATION'
1664: ,p_action_information1 => 'LE_SI_BALS'
1665: ,p_action_information2 => TO_CHAR(l_rec1.legal_employer_id)
1666: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1667: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1668: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1669: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1664: ,p_action_information1 => 'LE_SI_BALS'
1665: ,p_action_information2 => TO_CHAR(l_rec1.legal_employer_id)
1666: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1667: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1668: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1669: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1665: ,p_action_information2 => TO_CHAR(l_rec1.legal_employer_id)
1666: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1667: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1668: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1669: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1666: ,p_action_information3 => l_le_si_bal_table(l_count2).si_status
1667: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1668: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1669: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1667: ,p_action_information4 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(1))
1668: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1669: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1668: ,p_action_information5 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(2))
1669: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1669: ,p_action_information6 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(3))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1670: ,p_action_information7 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(4))
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1671: ,p_action_information8 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.ni_zone(5))
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1672: ,p_action_information9 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr.total)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1673: ,p_action_information10 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(1))
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1674: ,p_action_information11 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(2))
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1675: ,p_action_information12 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(3))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1676: ,p_action_information13 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(4))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1677: ,p_action_information14 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.ni_zone(5))
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1685: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1678: ,p_action_information15 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_over62.total)
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1685: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1686: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1679: ,p_action_information16 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).tax)
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1685: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1686: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1687: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1680: ,p_action_information17 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct_base)
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1685: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1686: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1687: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1688:
1681: ,p_action_information18 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl_pct)
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1685: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1686: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1687: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1688:
1689: END LOOP;
1682: ,p_action_information19 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_spcl)
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1685: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1686: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1687: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1688:
1689: END LOOP;
1690: END IF;
1683: ,p_action_information20 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_SPECIAL_RATE'))
1684: ,p_action_information21 => fnd_number.number_to_canonical(get_global(g_report_date, 'NO_NI_FOREIGN_MARINER_AMOUNT'))
1685: ,p_action_information22 => fnd_number.number_to_canonical(l_le_si_bal_table(l_count2).emp_contr_reimb_spcl_base) -- 2007/2008 changes
1686: ,p_action_information23 => fnd_number.number_to_canonical(l_tot_reimb_bse) -- 2007/2008 changes
1687: ,p_action_information24 => fnd_number.number_to_canonical(l_tot_pension_bse)); -- 2007/2008 changes
1688:
1689: END LOOP;
1690: END IF;
1691: --
2413: CURSOR csr_613_616_details
2414: (l_rr_id IN NUMBER
2415: ,l_element_type_id IN NUMBER
2416: ,p_report_date IN DATE) IS
2417: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2418: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2419: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2420: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2421: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2414: (l_rr_id IN NUMBER
2415: ,l_element_type_id IN NUMBER
2416: ,p_report_date IN DATE) IS
2417: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2418: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2419: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2420: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2421: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2422: FROM pay_run_result_values rrv
2415: ,l_element_type_id IN NUMBER
2416: ,p_report_date IN DATE) IS
2417: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2418: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2419: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2420: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2421: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2422: FROM pay_run_result_values rrv
2423: ,pay_input_values_f piv
2416: ,p_report_date IN DATE) IS
2417: SELECT sum(decode (piv.name,'Pay Value', fnd_number.canonical_to_number(rrv.result_value) ,0)) Pay_Value
2418: ,sum(decode (piv.name,'Per Diem', fnd_number.canonical_to_number(rrv.result_value) ,0)) Per_Diem
2419: ,sum(decode (piv.name,'Number of Days to be reported', fnd_number.canonical_to_number(rrv.result_value) ,0)) Reporting_Days
2420: ,sum(decode (piv.name,'Number of Days', fnd_number.canonical_to_number(rrv.result_value) ,0)) Days
2421: ,max(decode (piv.name,'Country', rrv.result_value)) Country
2422: FROM pay_run_result_values rrv
2423: ,pay_input_values_f piv
2424: WHERE rrv.run_result_id = l_rr_id
2516: --fnd_file.put_line(fnd_file.log,'$$$ l_amount: '||l_amount);
2517: --
2518: IF l_amount <> 0 THEN
2519: l_rep_code_rec.reporting_code := l_bal_rec.reporting_code;
2520: l_rep_code_rec.amount := fnd_number.number_to_canonical(l_amount);
2521: --
2522: l_seaman_status := 'N';
2523: --
2524: OPEN csr_seaman_bal_status(l_classification_id, l_bal_rec.defined_balance_id);
2545: ,l_element_name )
2546: LOOP
2547: --
2548: IF rec_549_118A.dtype = 'M' THEN
2549: l_rep_code_rec.amount := fnd_number.number_to_canonical(rec_549_118A.value);
2550: ELSE
2551: l_rep_code_rec.amount := rec_549_118A.value;
2552: END IF;
2553: --
2618: ,p_effective_date => g_report_date
2619: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2620: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2621: ,p_action_information2 => l_bal_rec.reporting_code
2622: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2623: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2624: ,p_action_information10 => l_seaman_status);
2625: --
2626: l_Pay_Value := rec_613_616_details.Pay_Value;
2619: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2620: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2621: ,p_action_information2 => l_bal_rec.reporting_code
2622: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2623: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2624: ,p_action_information10 => l_seaman_status);
2625: --
2626: l_Pay_Value := rec_613_616_details.Pay_Value;
2627: l_Days := rec_613_616_details.Days;
2648: ,p_effective_date => g_report_date
2649: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2650: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2651: ,p_action_information2 => l_bal_rec.reporting_code
2652: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2653: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2654: ,p_action_information10 => l_seaman_status);
2655: --
2656: END IF;
2649: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2650: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2651: ,p_action_information2 => l_bal_rec.reporting_code
2652: ,p_action_information3 => fnd_number.number_to_canonical(l_Pay_Value)
2653: ,p_action_information4 => fnd_number.number_to_canonical(l_Days)
2654: ,p_action_information10 => l_seaman_status);
2655: --
2656: END IF;
2657: --
2769: ,p_effective_date => g_report_date
2770: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2771: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2772: ,p_action_information2 => l_bal_rec.reporting_code
2773: ,p_action_information3 => fnd_number.number_to_canonical(l_code_616(i).Pay_Value)
2774: ,p_action_information4 => fnd_number.number_to_canonical(l_code_616(i).Per_Diem)
2775: ,p_action_information5 => fnd_number.number_to_canonical(l_code_616(i).Days)
2776: ,p_action_information6 => l_code_616(i).Country
2777: ,p_action_information10 => l_seaman_status);
2770: ,p_action_information_category => 'EMEA REPORT INFORMATION'
2771: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2772: ,p_action_information2 => l_bal_rec.reporting_code
2773: ,p_action_information3 => fnd_number.number_to_canonical(l_code_616(i).Pay_Value)
2774: ,p_action_information4 => fnd_number.number_to_canonical(l_code_616(i).Per_Diem)
2775: ,p_action_information5 => fnd_number.number_to_canonical(l_code_616(i).Days)
2776: ,p_action_information6 => l_code_616(i).Country
2777: ,p_action_information10 => l_seaman_status);
2778: --
2771: ,p_action_information1 => 'ASG_REP_CODE_INFO'
2772: ,p_action_information2 => l_bal_rec.reporting_code
2773: ,p_action_information3 => fnd_number.number_to_canonical(l_code_616(i).Pay_Value)
2774: ,p_action_information4 => fnd_number.number_to_canonical(l_code_616(i).Per_Diem)
2775: ,p_action_information5 => fnd_number.number_to_canonical(l_code_616(i).Days)
2776: ,p_action_information6 => l_code_616(i).Country
2777: ,p_action_information10 => l_seaman_status);
2778: --
2779: END LOOP;
2804: END IF;
2805: --
2806: --
2807: IF l_bal_info_rec.info_id = 'INFO1' THEN
2808: l_rep_code_rec.info1 := fnd_number.number_to_canonical(l_amount);
2809: ELSIF l_bal_info_rec.info_id = 'INFO2' THEN
2810: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2811: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2812: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2806: --
2807: IF l_bal_info_rec.info_id = 'INFO1' THEN
2808: l_rep_code_rec.info1 := fnd_number.number_to_canonical(l_amount);
2809: ELSIF l_bal_info_rec.info_id = 'INFO2' THEN
2810: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2811: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2812: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2813: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2814: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2808: l_rep_code_rec.info1 := fnd_number.number_to_canonical(l_amount);
2809: ELSIF l_bal_info_rec.info_id = 'INFO2' THEN
2810: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2811: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2812: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2813: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2814: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2815: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2816: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);
2810: l_rep_code_rec.info2 := fnd_number.number_to_canonical(l_amount);
2811: ELSIF l_bal_info_rec.info_id = 'INFO3' THEN
2812: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2813: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2814: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2815: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2816: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);
2817: ELSIF l_bal_info_rec.info_id = 'INFO6' THEN
2818: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);
2812: l_rep_code_rec.info3 := fnd_number.number_to_canonical(l_amount);
2813: ELSIF l_bal_info_rec.info_id = 'INFO4' THEN
2814: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2815: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2816: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);
2817: ELSIF l_bal_info_rec.info_id = 'INFO6' THEN
2818: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);
2819: -- 2009 changes starts
2820: ELSIF l_bal_info_rec.info_id = 'INFO7' THEN
2814: l_rep_code_rec.info4 := fnd_number.number_to_canonical(l_amount);
2815: ELSIF l_bal_info_rec.info_id = 'INFO5' THEN
2816: l_rep_code_rec.info5 := fnd_number.number_to_canonical(l_amount);
2817: ELSIF l_bal_info_rec.info_id = 'INFO6' THEN
2818: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);
2819: -- 2009 changes starts
2820: ELSIF l_bal_info_rec.info_id = 'INFO7' THEN
2821: l_rep_code_rec.info7 := fnd_number.number_to_canonical(l_amount);
2822: ELSIF l_bal_info_rec.info_id = 'INFO8' THEN
2817: ELSIF l_bal_info_rec.info_id = 'INFO6' THEN
2818: l_rep_code_rec.info6 := fnd_number.number_to_canonical(l_amount);
2819: -- 2009 changes starts
2820: ELSIF l_bal_info_rec.info_id = 'INFO7' THEN
2821: l_rep_code_rec.info7 := fnd_number.number_to_canonical(l_amount);
2822: ELSIF l_bal_info_rec.info_id = 'INFO8' THEN
2823: l_rep_code_rec.info8 := fnd_number.number_to_canonical(l_amount);
2824: ELSIF l_bal_info_rec.info_id = 'INFO9' THEN
2825: l_rep_code_rec.info9 := fnd_number.number_to_canonical(l_amount);
2819: -- 2009 changes starts
2820: ELSIF l_bal_info_rec.info_id = 'INFO7' THEN
2821: l_rep_code_rec.info7 := fnd_number.number_to_canonical(l_amount);
2822: ELSIF l_bal_info_rec.info_id = 'INFO8' THEN
2823: l_rep_code_rec.info8 := fnd_number.number_to_canonical(l_amount);
2824: ELSIF l_bal_info_rec.info_id = 'INFO9' THEN
2825: l_rep_code_rec.info9 := fnd_number.number_to_canonical(l_amount);
2826: ELSIF l_bal_info_rec.info_id = 'INFO10' THEN
2827: l_rep_code_rec.info10 := fnd_number.number_to_canonical(l_amount);
2821: l_rep_code_rec.info7 := fnd_number.number_to_canonical(l_amount);
2822: ELSIF l_bal_info_rec.info_id = 'INFO8' THEN
2823: l_rep_code_rec.info8 := fnd_number.number_to_canonical(l_amount);
2824: ELSIF l_bal_info_rec.info_id = 'INFO9' THEN
2825: l_rep_code_rec.info9 := fnd_number.number_to_canonical(l_amount);
2826: ELSIF l_bal_info_rec.info_id = 'INFO10' THEN
2827: l_rep_code_rec.info10 := fnd_number.number_to_canonical(l_amount);
2828: -- 2009 changes ends
2829: END IF;
2823: l_rep_code_rec.info8 := fnd_number.number_to_canonical(l_amount);
2824: ELSIF l_bal_info_rec.info_id = 'INFO9' THEN
2825: l_rep_code_rec.info9 := fnd_number.number_to_canonical(l_amount);
2826: ELSIF l_bal_info_rec.info_id = 'INFO10' THEN
2827: l_rep_code_rec.info10 := fnd_number.number_to_canonical(l_amount);
2828: -- 2009 changes ends
2829: END IF;
2830: END LOOP;
2831: --
2929: END IF;
2930: --
2931: -- IF l_rrv_rec.dtype IN ('M','N') THEN
2932: --
2933: -- l_rrv_rec.result_value := fnd_number.number_to_canonical(l_rrv_rec.result_value);
2934: -- END IF;
2935: --
2936: --
2937: IF l_rrv_rec.creator_type = 'RR' and l_rrv_rec.result_value is null THEN
2991: l_rep_code_rec.info16 := r_retro_rec.result_value;
2992: -- 2009 changes ends
2993: ELSIF r_retro_rec.info_id = 'AMOUNT' THEN
2994: IF is_EA_classification(l_rrv_rec.element_type, g_report_date) THEN
2995: l_rep_code_rec.amount := fnd_number.number_to_canonical(-1 * fnd_number.canonical_to_number(l_rrv_rec.result_value));
2996: ELSE
2997: l_rep_code_rec.amount := l_rrv_rec.result_value;
2998: END IF;
2999: END IF;
3057: l_rep_code_rec.info16 := l_rrv_rec.result_value;
3058: -- 2009 changes ends
3059: ELSIF l_rrv_rec.info_id = 'AMOUNT' THEN
3060: IF is_EA_classification(l_rrv_rec.element_type, g_report_date) THEN
3061: l_rep_code_rec.amount := fnd_number.number_to_canonical(-1 * fnd_number.canonical_to_number(l_rrv_rec.result_value));
3062: ELSE
3063: l_rep_code_rec.amount := l_rrv_rec.result_value;
3064: END IF;
3065: END IF;
3183: AND rep_cde.action_information_category = 'EMEA REPORT INFORMATION'
3184: AND rep_cde.action_information1 = 'ASG_REP_CODE_INFO'
3185: GROUP BY le_lu.action_information2
3186: ,asg_act.action_information5
3187: HAVING SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) < 1000;
3188: --
3189: CURSOR csr_ASGACT
3190: (p_payroll_action_id IN NUMBER
3191: ,p_legal_employer_id IN VARCHAR2
3352: SELECT asg_act.action_information2 legal_employer_id
3353: ,asg_act.action_information5 person_id
3354: ,asg_act.action_information6 tax_municipality
3355: ,rep_cde.action_information2 code
3356: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3357: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
3358: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
3359: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
3360: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
3353: ,asg_act.action_information5 person_id
3354: ,asg_act.action_information6 tax_municipality
3355: ,rep_cde.action_information2 code
3356: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3357: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
3358: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
3359: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
3360: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
3361: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
3354: ,asg_act.action_information6 tax_municipality
3355: ,rep_cde.action_information2 code
3356: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3357: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
3358: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
3359: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
3360: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
3361: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
3362: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
3355: ,rep_cde.action_information2 code
3356: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3357: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
3358: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
3359: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
3360: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
3361: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
3362: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
3363: ,rep_cde.action_information10 seaman_component
3356: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
3357: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
3358: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
3359: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
3360: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
3361: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
3362: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
3363: ,rep_cde.action_information10 seaman_component
3364: ,rep_cde.action_information11 cinfo1
3357: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information4,0))) info1
3358: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
3359: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
3360: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
3361: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
3362: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
3363: ,rep_cde.action_information10 seaman_component
3364: ,rep_cde.action_information11 cinfo1
3365: ,rep_cde.action_information12 cinfo2
3358: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information5,0))) info2
3359: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information6,0))) info3
3360: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information7,0))) info4
3361: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information8,0))) info5
3362: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information9,0))) info6
3363: ,rep_cde.action_information10 seaman_component
3364: ,rep_cde.action_information11 cinfo1
3365: ,rep_cde.action_information12 cinfo2
3366: ,rep_cde.action_information13 cinfo3
3366: ,rep_cde.action_information13 cinfo3
3367: ,rep_cde.action_information14 cinfo4
3368: ,rep_cde.action_information15 cinfo5
3369: ,rep_cde.action_information16 cinfo6
3370: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information17,0))) info7 --2009 changes
3371: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information18,0))) info8 --2009 changes
3372: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information19,0))) info9 --2009 changes
3373: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information20,0))) info10 --2009 changes
3374: ,rep_cde.action_information21 cinfo7 --2009 changes
3367: ,rep_cde.action_information14 cinfo4
3368: ,rep_cde.action_information15 cinfo5
3369: ,rep_cde.action_information16 cinfo6
3370: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information17,0))) info7 --2009 changes
3371: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information18,0))) info8 --2009 changes
3372: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information19,0))) info9 --2009 changes
3373: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information20,0))) info10 --2009 changes
3374: ,rep_cde.action_information21 cinfo7 --2009 changes
3375: ,rep_cde.action_information22 cinfo8 --2009 changes
3368: ,rep_cde.action_information15 cinfo5
3369: ,rep_cde.action_information16 cinfo6
3370: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information17,0))) info7 --2009 changes
3371: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information18,0))) info8 --2009 changes
3372: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information19,0))) info9 --2009 changes
3373: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information20,0))) info10 --2009 changes
3374: ,rep_cde.action_information21 cinfo7 --2009 changes
3375: ,rep_cde.action_information22 cinfo8 --2009 changes
3376: ,rep_cde.action_information23 cinfo9 --2009 changes
3369: ,rep_cde.action_information16 cinfo6
3370: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information17,0))) info7 --2009 changes
3371: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information18,0))) info8 --2009 changes
3372: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information19,0))) info9 --2009 changes
3373: ,SUM(fnd_number.canonical_to_number(nvl(rep_cde.action_information20,0))) info10 --2009 changes
3374: ,rep_cde.action_information21 cinfo7 --2009 changes
3375: ,rep_cde.action_information22 cinfo8 --2009 changes
3376: ,rep_cde.action_information23 cinfo9 --2009 changes
3377: ,rep_cde.action_information24 cinfo10 --2009 changes
3620: ,p_action_information1 => 'AUDIT_REP_SUMMARY'
3621: ,p_action_information2 => l_cde_rec.legal_employer_id
3622: ,p_action_information3 => l_cde_rec.person_id
3623: ,p_action_information4 => l_cde_rec.code
3624: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3625: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3626: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3627: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3628: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3621: ,p_action_information2 => l_cde_rec.legal_employer_id
3622: ,p_action_information3 => l_cde_rec.person_id
3623: ,p_action_information4 => l_cde_rec.code
3624: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3625: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3626: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3627: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3628: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3629: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3622: ,p_action_information3 => l_cde_rec.person_id
3623: ,p_action_information4 => l_cde_rec.code
3624: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3625: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3626: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3627: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3628: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3629: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3630: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3623: ,p_action_information4 => l_cde_rec.code
3624: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3625: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3626: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3627: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3628: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3629: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3630: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3631: ,p_action_information12 => l_cde_rec.tax_municipality
3624: ,p_action_information5 => fnd_number.number_to_canonical(l_cde_rec.amount)
3625: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3626: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3627: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3628: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3629: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3630: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3631: ,p_action_information12 => l_cde_rec.tax_municipality
3632: ,p_action_information13 => l_cde_rec.seaman_component
3625: ,p_action_information6 => nvl(l_cde_rec.cinfo1, fnd_number.number_to_canonical(l_cde_rec.info1))
3626: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3627: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3628: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3629: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3630: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3631: ,p_action_information12 => l_cde_rec.tax_municipality
3632: ,p_action_information13 => l_cde_rec.seaman_component
3633: ,p_action_information14 => nvl(l_cde_rec.cinfo7, fnd_number.number_to_canonical(l_cde_rec.info7)) --2009 chnages
3626: ,p_action_information7 => nvl(l_cde_rec.cinfo2, fnd_number.number_to_canonical(l_cde_rec.info2))
3627: ,p_action_information8 => nvl(l_cde_rec.cinfo3, fnd_number.number_to_canonical(l_cde_rec.info3))
3628: ,p_action_information9 => nvl(l_cde_rec.cinfo4, fnd_number.number_to_canonical(l_cde_rec.info4))
3629: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3630: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3631: ,p_action_information12 => l_cde_rec.tax_municipality
3632: ,p_action_information13 => l_cde_rec.seaman_component
3633: ,p_action_information14 => nvl(l_cde_rec.cinfo7, fnd_number.number_to_canonical(l_cde_rec.info7)) --2009 chnages
3634: ,p_action_information15 => nvl(l_cde_rec.cinfo8, fnd_number.number_to_canonical(l_cde_rec.info8)) --2009 chnages
3629: ,p_action_information10 => nvl(l_cde_rec.cinfo5, fnd_number.number_to_canonical(l_cde_rec.info5))
3630: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3631: ,p_action_information12 => l_cde_rec.tax_municipality
3632: ,p_action_information13 => l_cde_rec.seaman_component
3633: ,p_action_information14 => nvl(l_cde_rec.cinfo7, fnd_number.number_to_canonical(l_cde_rec.info7)) --2009 chnages
3634: ,p_action_information15 => nvl(l_cde_rec.cinfo8, fnd_number.number_to_canonical(l_cde_rec.info8)) --2009 chnages
3635: ,p_action_information16 => nvl(l_cde_rec.cinfo9, fnd_number.number_to_canonical(l_cde_rec.info9)) --2009 chnages
3636: ,p_action_information17 => nvl(l_cde_rec.cinfo10, fnd_number.number_to_canonical(l_cde_rec.info10)) --2009 chnages
3637: );
3630: ,p_action_information11 => nvl(l_cde_rec.cinfo6, fnd_number.number_to_canonical(l_cde_rec.info6))
3631: ,p_action_information12 => l_cde_rec.tax_municipality
3632: ,p_action_information13 => l_cde_rec.seaman_component
3633: ,p_action_information14 => nvl(l_cde_rec.cinfo7, fnd_number.number_to_canonical(l_cde_rec.info7)) --2009 chnages
3634: ,p_action_information15 => nvl(l_cde_rec.cinfo8, fnd_number.number_to_canonical(l_cde_rec.info8)) --2009 chnages
3635: ,p_action_information16 => nvl(l_cde_rec.cinfo9, fnd_number.number_to_canonical(l_cde_rec.info9)) --2009 chnages
3636: ,p_action_information17 => nvl(l_cde_rec.cinfo10, fnd_number.number_to_canonical(l_cde_rec.info10)) --2009 chnages
3637: );
3638: END LOOP;
3631: ,p_action_information12 => l_cde_rec.tax_municipality
3632: ,p_action_information13 => l_cde_rec.seaman_component
3633: ,p_action_information14 => nvl(l_cde_rec.cinfo7, fnd_number.number_to_canonical(l_cde_rec.info7)) --2009 chnages
3634: ,p_action_information15 => nvl(l_cde_rec.cinfo8, fnd_number.number_to_canonical(l_cde_rec.info8)) --2009 chnages
3635: ,p_action_information16 => nvl(l_cde_rec.cinfo9, fnd_number.number_to_canonical(l_cde_rec.info9)) --2009 chnages
3636: ,p_action_information17 => nvl(l_cde_rec.cinfo10, fnd_number.number_to_canonical(l_cde_rec.info10)) --2009 chnages
3637: );
3638: END LOOP;
3639: --
3632: ,p_action_information13 => l_cde_rec.seaman_component
3633: ,p_action_information14 => nvl(l_cde_rec.cinfo7, fnd_number.number_to_canonical(l_cde_rec.info7)) --2009 chnages
3634: ,p_action_information15 => nvl(l_cde_rec.cinfo8, fnd_number.number_to_canonical(l_cde_rec.info8)) --2009 chnages
3635: ,p_action_information16 => nvl(l_cde_rec.cinfo9, fnd_number.number_to_canonical(l_cde_rec.info9)) --2009 chnages
3636: ,p_action_information17 => nvl(l_cde_rec.cinfo10, fnd_number.number_to_canonical(l_cde_rec.info10)) --2009 chnages
3637: );
3638: END LOOP;
3639: --
3640: --
3722: ,p_person_id IN VARCHAR2
3723: ,p_tax_municipality IN VARCHAR2
3724: ,l_seaman_status IN VARCHAR2 ) IS
3725: SELECT summ_cde.action_information4 code
3726: ,trunc(fnd_number.canonical_to_number(summ_cde.action_information5)) amount
3727: ,summ_cde.action_information6 info1
3728: ,summ_cde.action_information7 info2
3729: ,summ_cde.action_information8 info3
3730: ,summ_cde.action_information9 info4
3895: l_xml_element_count := l_xml_element_count + 1;
3896: --
3897: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3898: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
3899: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1));
3900: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
3901: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
3902:
3903: ELSE
3920: l_xml_element_count := l_xml_element_count + 1;
3921: --
3922: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3923: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
3924: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2));
3925: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
3926: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
3927: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info2),'DD-MM-YYYY');
3928: ELSE
3945: l_xml_element_count := l_xml_element_count + 1;
3946: --
3947: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3948: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
3949: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3));
3950: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
3951: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
3952: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info3),'DD-MM-YYYY');
3953: ELSE
3970: l_xml_element_count := l_xml_element_count + 1;
3971: --
3972: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3973: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
3974: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4));
3975: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
3976: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
3977: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info4),'DD-MM-YYYY');
3978: ELSE
3995: l_xml_element_count := l_xml_element_count + 1;
3996: --
3997: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
3998: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
3999: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5));
4000: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
4001: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
4002: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info5),'DD-MM-YYYY');
4003: ELSE
4020: l_xml_element_count := l_xml_element_count + 1;
4021: --
4022: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4023: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
4024: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6));
4025: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
4026: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
4027: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info6),'DD-MM-YYYY');
4028: ELSE
4045: l_xml_element_count := l_xml_element_count + 1;
4046: --
4047: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4048: IF l_summ_code_rec.info7_dtype IN ('M','A','N') THEN
4049: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info7));
4050: ELSIF l_summ_code_rec.info7_dtype = 'D' AND l_summ_code_rec.info7 <> '0' THEN
4051: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info7));
4052: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info7),'DD-MM-YYYY');
4053: ELSE
4070: l_xml_element_count := l_xml_element_count + 1;
4071: --
4072: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4073: IF l_summ_code_rec.info8_dtype IN ('M','A','N') THEN
4074: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info8));
4075: ELSIF l_summ_code_rec.info8_dtype = 'D' AND l_summ_code_rec.info8 <> '0' THEN
4076: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info8));
4077: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info8),'DD-MM-YYYY');
4078: ELSE
4095: l_xml_element_count := l_xml_element_count + 1;
4096: --
4097: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4098: IF l_summ_code_rec.info9_dtype IN ('M','A','N') THEN
4099: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info9));
4100: ELSIF l_summ_code_rec.info9_dtype = 'D' AND l_summ_code_rec.info9 <> '0' THEN
4101: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info9));
4102: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info9),'DD-MM-YYYY');
4103: ELSE
4120: l_xml_element_count := l_xml_element_count + 1;
4121: --
4122: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
4123: IF l_summ_code_rec.info10_dtype IN ('M','A','N') THEN
4124: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info10));
4125: ELSIF l_summ_code_rec.info10_dtype = 'D' AND l_summ_code_rec.info10 <> '0' THEN
4126: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info10));
4127: --g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(l_summ_code_rec.info10),'DD-MM-YYYY');
4128: ELSE
4232: -- ,le_lu_tm.action_information5 local_unit
4233: ,le_lu_tm.action_information6 tax_municipality_id
4234: ,le_lu_tm.action_information7 tax_municipality
4235: ,le_lu_tm.action_information8 ni_zone_arc
4236: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
4237: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
4238: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
4239: FROM pay_action_information le_lu_tm
4240: WHERE le_lu_tm.action_context_type = 'PA'
4233: ,le_lu_tm.action_information6 tax_municipality_id
4234: ,le_lu_tm.action_information7 tax_municipality
4235: ,le_lu_tm.action_information8 ni_zone_arc
4236: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
4237: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
4238: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
4239: FROM pay_action_information le_lu_tm
4240: WHERE le_lu_tm.action_context_type = 'PA'
4241: AND le_lu_tm.action_context_id = l_payroll_action_id
4234: ,le_lu_tm.action_information7 tax_municipality
4235: ,le_lu_tm.action_information8 ni_zone_arc
4236: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
4237: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
4238: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
4239: FROM pay_action_information le_lu_tm
4240: WHERE le_lu_tm.action_context_type = 'PA'
4241: AND le_lu_tm.action_context_id = l_payroll_action_id
4242: AND le_lu_tm.action_information_category = 'EMEA REPORT INFORMATION'
4289: (l_payroll_action_id IN NUMBER
4290: ,p_legal_employer_id IN VARCHAR2
4291: ,p_si_status IN VARCHAR2) IS
4292: SELECT
4293: -- fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4294: -- ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4295: -- ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4290: ,p_legal_employer_id IN VARCHAR2
4291: ,p_si_status IN VARCHAR2) IS
4292: SELECT
4293: -- fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4294: -- ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4295: -- ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4291: ,p_si_status IN VARCHAR2) IS
4292: SELECT
4293: -- fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4294: -- ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4295: -- ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4292: SELECT
4293: -- fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4294: -- ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4295: -- ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4293: -- fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
4294: -- ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4295: -- ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4294: -- ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
4295: -- ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4295: -- ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4296: -- ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4297: -- ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4298: fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4299: -- ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4300: -- ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4301: -- ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4302: -- ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4303: -- ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4311: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4304: -- ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4311: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4312: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4305: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4311: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4312: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4313: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4306: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4311: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4312: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4313: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4314: FROM pay_action_information le_si_bals
4307: -- ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4311: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4312: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4313: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4314: FROM pay_action_information le_si_bals
4315: WHERE le_si_bals.action_context_type = 'PA'
4308: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4311: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4312: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4313: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4314: FROM pay_action_information le_si_bals
4315: WHERE le_si_bals.action_context_type = 'PA'
4316: AND le_si_bals.action_context_id = l_payroll_action_id
4309: -- ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
4310: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
4311: --Bug 14671801 ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
4312: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
4313: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
4314: FROM pay_action_information le_si_bals
4315: WHERE le_si_bals.action_context_type = 'PA'
4316: AND le_si_bals.action_context_id = l_payroll_action_id
4317: AND le_si_bals.action_information_category = 'EMEA REPORT INFORMATION'
4324: ,p_legal_employer_id IN VARCHAR2
4325: ,p_si_status IN VARCHAR2) IS
4326: SELECT COUNT (DISTINCT asg_act.action_information5) certificates
4327: /* ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4328: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4329: ,0)) a_zone1
4330: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4331: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4332: ,0)) a_zone2
4327: /* ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4328: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4329: ,0)) a_zone1
4330: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4331: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4332: ,0)) a_zone2
4333: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4334: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4335: ,0)) a_zone3
4330: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4331: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4332: ,0)) a_zone2
4333: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4334: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4335: ,0)) a_zone3
4336: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4337: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4338: ,0)) a_zone4
4333: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4334: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4335: ,0)) a_zone3
4336: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4337: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4338: ,0)) a_zone4
4339: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4340: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4341: ,0)) a_zone5*/
4336: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4337: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4338: ,0)) a_zone4
4339: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4340: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4341: ,0)) a_zone5*/
4342: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4343: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4344: ,0)) bl_zone1
4339: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4340: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
4341: ,0)) a_zone5*/
4342: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4343: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4344: ,0)) bl_zone1
4345: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4346: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4347: ,0)) bl_zone2
4342: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4343: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4344: ,0)) bl_zone1
4345: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4346: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4347: ,0)) bl_zone2
4348: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4349: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4350: ,0)) bl_zone3
4345: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4346: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4347: ,0)) bl_zone2
4348: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4349: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4350: ,0)) bl_zone3
4351: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4352: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4353: ,0)) bl_zone4
4348: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4349: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4350: ,0)) bl_zone3
4351: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4352: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4353: ,0)) bl_zone4
4354: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4355: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4356: ,0)) bl_zone5
4351: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4352: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4353: ,0)) bl_zone4
4354: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4355: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4356: ,0)) bl_zone5
4357: /* ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4358: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
4359: ,0)) sum_zone1
4354: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4355: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
4356: ,0)) bl_zone5
4357: /* ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4358: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
4359: ,0)) sum_zone1
4360: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4361: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
4362: ,0)) sum_zone2
4357: /* ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4358: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
4359: ,0)) sum_zone1
4360: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4361: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
4362: ,0)) sum_zone2
4363: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4364: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
4365: ,0)) sum_zone3
4360: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4361: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
4362: ,0)) sum_zone2
4363: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4364: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
4365: ,0)) sum_zone3
4366: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4367: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
4368: ,0)) sum_zone4
4363: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4364: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
4365: ,0)) sum_zone3
4366: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4367: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
4368: ,0)) sum_zone4
4369: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4370: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
4371: ,0)) sum_zone5
4366: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4367: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
4368: ,0)) sum_zone4
4369: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4370: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
4371: ,0)) sum_zone5
4372: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4373: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4374: ,0)) sum_totals*/
4369: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4370: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
4371: ,0)) sum_zone5
4372: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
4373: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
4374: ,0)) sum_totals*/
4375: FROM pay_assignment_actions paa
4376: ,pay_action_information le_lu
4377: ,pay_action_information asg_act
4409: ,p_legal_employer_id IN VARCHAR2
4410: ,p_si_status IN VARCHAR2) IS
4411: SELECT
4412: /* SUM(DECODE(asg_act.action_information7
4413: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
4414: , 0)) a_earnings
4415: ,SUM(DECODE(asg_act.action_information7
4416: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4417: , 0)) bl_earnings
4412: /* SUM(DECODE(asg_act.action_information7
4413: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
4414: , 0)) a_earnings
4415: ,SUM(DECODE(asg_act.action_information7
4416: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4417: , 0)) bl_earnings
4418: ,*/
4419: SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4420: FROM pay_assignment_actions paa
4415: ,SUM(DECODE(asg_act.action_information7
4416: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
4417: , 0)) bl_earnings
4418: ,*/
4419: SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
4420: FROM pay_assignment_actions paa
4421: ,pay_action_information le_lu
4422: ,pay_action_information asg_act
4423: ,pay_action_information rep_cde
4457: ,p_si_status IN VARCHAR2) IS
4458: SELECT asg_act.action_information2 legal_employer_id
4459: ,le_lu.action_information3 si_status
4460: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
4461: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
4462: FROM pay_assignment_actions paa
4463: ,pay_action_information le_lu
4464: ,pay_action_information asg_act
4465: ,pay_action_information rep_cde
4599: l_xml_element_count := l_xml_element_count + 1;
4600:
4601: -- ORID 27604 Economic Aid Received - 2007/2008 Changes
4602: g_xml_element_table(l_xml_element_count).tagname := 'ECONOMIC_AID';
4603: 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);
4604: l_xml_element_count := l_xml_element_count + 1;
4605:
4606: -- Bug#9579261 fix starts
4607: /*
4725: FETCH csr_LE_SI_BAL_SUMMARY INTO l_le_si_bal_rec;
4726: CLOSE csr_LE_SI_BAL_SUMMARY;
4727: --
4728: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE1';
4729: 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);
4730: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4731: l_xml_element_count := l_xml_element_count + 1;*/
4732: --
4733: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE2';
4730: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4731: l_xml_element_count := l_xml_element_count + 1;*/
4732: --
4733: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE2';
4734: 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);
4735: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4736: l_xml_element_count := l_xml_element_count + 1;*/
4737: --
4738: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE3';
4735: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4736: l_xml_element_count := l_xml_element_count + 1;*/
4737: --
4738: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE3';
4739: 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);
4740: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4741: l_xml_element_count := l_xml_element_count + 1;*/
4742: --
4743: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE4';
4740: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4741: l_xml_element_count := l_xml_element_count + 1;*/
4742: --
4743: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE4';
4744: 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);
4745: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4746: l_xml_element_count := l_xml_element_count + 1;*/
4747: --
4748: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE5';
4745: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4746: l_xml_element_count := l_xml_element_count + 1;*/
4747: --
4748: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_ZONE5';
4749: 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);
4750: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4751: l_xml_element_count := l_xml_element_count + 1;*/
4752: --
4753: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_TOTAL';
4750: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4751: l_xml_element_count := l_xml_element_count + 1;*/
4752: --
4753: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_TOTAL';
4754: 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);
4755: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4756: l_xml_element_count := l_xml_element_count + 1;*/
4757: --
4758: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE1';
4755: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4756: l_xml_element_count := l_xml_element_count + 1;*/
4757: --
4758: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE1';
4759: 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);
4760: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4761: l_xml_element_count := l_xml_element_count + 1;*/
4762: --
4763: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE2';
4760: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4761: l_xml_element_count := l_xml_element_count + 1;*/
4762: --
4763: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE2';
4764: 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);
4765: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4766: l_xml_element_count := l_xml_element_count + 1;*/
4767: --
4768: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE3';
4765: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4766: l_xml_element_count := l_xml_element_count + 1;*/
4767: --
4768: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE3';
4769: 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);
4770: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4771: l_xml_element_count := l_xml_element_count + 1;*/
4772: --
4773: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE4';
4770: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4771: l_xml_element_count := l_xml_element_count + 1;*/
4772: --
4773: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE4';
4774: 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);
4775: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4776: l_xml_element_count := l_xml_element_count + 1;*/
4777: --
4778: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE5';
4775: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4776: l_xml_element_count := l_xml_element_count + 1;*/
4777: --
4778: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_ZONE5';
4779: 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);
4780: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4781: l_xml_element_count := l_xml_element_count + 1;*/
4782: --
4783: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_TOTAL';
4780: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4781: l_xml_element_count := l_xml_element_count + 1;*/
4782: --
4783: /* g_xml_element_table(l_xml_element_count).tagname := 'EC_O62_TOTAL';
4784: 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);
4785: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4786: l_xml_element_count := l_xml_element_count + 1;*/
4787: --
4788: -- Total witholding Tax
4787: --
4788: -- Total witholding Tax
4789: --
4790: g_xml_element_table(l_xml_element_count).tagname := 'A_TAX';
4791: 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);
4792: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4793: l_xml_element_count := l_xml_element_count + 1;
4794:
4795: /*--Bug 14671801
4796: --
4797: -- ORID 22225 - Gross Base for Employees from USA/Canada
4798: --
4799: g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT_BASE';
4800: 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);
4801: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4802: l_xml_element_count := l_xml_element_count + 1;
4803: */
4804: --
4802: l_xml_element_count := l_xml_element_count + 1;
4803: */
4804: --
4805: /* g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT';
4806: 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);
4807: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4808: l_xml_element_count := l_xml_element_count + 1;*/
4809: --
4810: /* g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT_AMOUNT';
4807: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4808: l_xml_element_count := l_xml_element_count + 1;*/
4809: --
4810: /* g_xml_element_table(l_xml_element_count).tagname := 'FE_PCT_AMOUNT';
4811: 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);
4812: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4813: l_xml_element_count := l_xml_element_count + 1;*/
4814:
4815: /* --Bug 14671801
4832: /* --Bug 14671801
4833: --Reimbursement Base Employees From USA/Canada ORID-27612 - 2007/2008 Changes
4834: --
4835: g_xml_element_table(l_xml_element_count).tagname := 'FE_REIMBURSEMENT_BASE';
4836: 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);
4837: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4838: l_xml_element_count := l_xml_element_count + 1;
4839: -- Net Base for Employees from USA/Canada - 2007/2008 Changes
4840: l_spcl_net_base := nvl(l_le_si_bal_rec.emp_contr_spcl_pct_base,0) - nvl(l_le_si_bal_rec.emp_contr_reimb_spcl_base,0);
4842: g_xml_element_table(l_xml_element_count).tagvalue := to_char(l_spcl_net_base,lg_format_mask);
4843: l_xml_element_count := l_xml_element_count + 1;
4844: --ORID 28103 Total EC Base - 2007/2008 Changes
4845: g_xml_element_table(l_xml_element_count).tagname := 'TOT_EC_BASE';
4846: 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);
4847: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4848: l_xml_element_count := l_xml_element_count + 1;
4849: -- ORID 28104 Total Pension Base
4850: g_xml_element_table(l_xml_element_count).tagname := 'TOT_PEN_BASE';
4847: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4848: l_xml_element_count := l_xml_element_count + 1;
4849: -- ORID 28104 Total Pension Base
4850: g_xml_element_table(l_xml_element_count).tagname := 'TOT_PEN_BASE';
4851: 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);
4852: g_xml_element_table(l_xml_element_count).tagtype := 'A';
4853: l_xml_element_count := l_xml_element_count + 1;
4854: */
4855: --
5249: ,le_lu_tm.action_information5 local_unit
5250: ,le_lu_tm.action_information6 tax_municipality_id
5251: ,le_lu_tm.action_information7 tax_municipality
5252: ,le_lu_tm.action_information8 ni_zone_arc
5253: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
5254: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
5255: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
5256: FROM pay_action_information le_lu_tm
5257: WHERE le_lu_tm.action_context_type = 'PA'
5250: ,le_lu_tm.action_information6 tax_municipality_id
5251: ,le_lu_tm.action_information7 tax_municipality
5252: ,le_lu_tm.action_information8 ni_zone_arc
5253: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
5254: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
5255: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
5256: FROM pay_action_information le_lu_tm
5257: WHERE le_lu_tm.action_context_type = 'PA'
5258: AND le_lu_tm.action_context_id = l_payroll_action_id
5251: ,le_lu_tm.action_information7 tax_municipality
5252: ,le_lu_tm.action_information8 ni_zone_arc
5253: ,fnd_number.canonical_to_number(le_lu_tm.action_information9) emp_contr_bse
5254: ,fnd_number.canonical_to_number(le_lu_tm.action_information10) reimb_bse
5255: ,fnd_number.canonical_to_number(le_lu_tm.action_information11) pension_bse
5256: FROM pay_action_information le_lu_tm
5257: WHERE le_lu_tm.action_context_type = 'PA'
5258: AND le_lu_tm.action_context_id = l_payroll_action_id
5259: AND le_lu_tm.action_information_category = 'EMEA REPORT INFORMATION'
5298: CURSOR csr_LE_SI_BAL_SUMMARY
5299: (l_payroll_action_id IN NUMBER
5300: ,p_legal_employer_id IN VARCHAR2
5301: ,p_si_status IN VARCHAR2) IS
5302: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
5303: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
5304: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5299: (l_payroll_action_id IN NUMBER
5300: ,p_legal_employer_id IN VARCHAR2
5301: ,p_si_status IN VARCHAR2) IS
5302: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
5303: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
5304: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5300: ,p_legal_employer_id IN VARCHAR2
5301: ,p_si_status IN VARCHAR2) IS
5302: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
5303: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
5304: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5301: ,p_si_status IN VARCHAR2) IS
5302: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
5303: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
5304: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5302: SELECT fnd_number.canonical_to_number(le_si_bals.action_information4) emp_contr_ni_zone1
5303: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
5304: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5303: ,fnd_number.canonical_to_number(le_si_bals.action_information5) emp_contr_ni_zone2
5304: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5304: ,fnd_number.canonical_to_number(le_si_bals.action_information6) emp_contr_ni_zone3
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5305: ,fnd_number.canonical_to_number(le_si_bals.action_information7) emp_contr_ni_zone4
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5306: ,fnd_number.canonical_to_number(le_si_bals.action_information8) emp_contr_ni_zone5
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5307: ,fnd_number.canonical_to_number(le_si_bals.action_information9) emp_contr_ni_total
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5308: ,fnd_number.canonical_to_number(le_si_bals.action_information10) emp_contr_o62_ni_zone1
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5309: ,fnd_number.canonical_to_number(le_si_bals.action_information11) emp_contr_o62_ni_zone2
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5310: ,fnd_number.canonical_to_number(le_si_bals.action_information12) emp_contr_o62_ni_zone3
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5311: ,fnd_number.canonical_to_number(le_si_bals.action_information13) emp_contr_o62_ni_zone4
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5312: ,fnd_number.canonical_to_number(le_si_bals.action_information14) emp_contr_o62_ni_zone5
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5320: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
5313: ,fnd_number.canonical_to_number(le_si_bals.action_information15) emp_contr_o62_ni_total
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5320: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
5321: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
5314: ,fnd_number.canonical_to_number(le_si_bals.action_information16) tax
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5320: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
5321: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
5322: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
5315: ,fnd_number.canonical_to_number(le_si_bals.action_information17) emp_contr_spcl_pct_base
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5320: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
5321: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
5322: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
5323: FROM pay_action_information le_si_bals
5316: ,fnd_number.canonical_to_number(le_si_bals.action_information18) emp_contr_spcl_pct
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5320: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
5321: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
5322: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
5323: FROM pay_action_information le_si_bals
5324: WHERE le_si_bals.action_context_type = 'PA'
5317: ,fnd_number.canonical_to_number(le_si_bals.action_information19) emp_contr_spcl
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5320: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
5321: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
5322: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
5323: FROM pay_action_information le_si_bals
5324: WHERE le_si_bals.action_context_type = 'PA'
5325: AND le_si_bals.action_context_id = l_payroll_action_id
5318: ,fnd_number.canonical_to_number(le_si_bals.action_information20) foreign_special_percentage
5319: ,fnd_number.canonical_to_number(le_si_bals.action_information21) foreign_special_amount
5320: ,fnd_number.canonical_to_number(le_si_bals.action_information22) emp_contr_reimb_spcl_base --2007/2008 changes
5321: ,fnd_number.canonical_to_number(le_si_bals.action_information23) tot_reimb_bse --2007/2008 changes
5322: ,fnd_number.canonical_to_number(le_si_bals.action_information24) tot_pension_bse -- 2007/2008 Changes
5323: FROM pay_action_information le_si_bals
5324: WHERE le_si_bals.action_context_type = 'PA'
5325: AND le_si_bals.action_context_id = l_payroll_action_id
5326: AND le_si_bals.action_information_category = 'EMEA REPORT INFORMATION'
5333: ,p_legal_employer_id IN VARCHAR2
5334: ,p_si_status IN VARCHAR2) IS
5335: SELECT COUNT (DISTINCT asg_act.action_information5) certificates
5336: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5337: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5338: ,0)) a_zone1
5339: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5340: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5341: ,0)) a_zone2
5336: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5337: ,'1N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5338: ,0)) a_zone1
5339: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5340: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5341: ,0)) a_zone2
5342: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5343: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5344: ,0)) a_zone3
5339: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5340: ,'2N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5341: ,0)) a_zone2
5342: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5343: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5344: ,0)) a_zone3
5345: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5346: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5347: ,0)) a_zone4
5342: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5343: ,'3N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5344: ,0)) a_zone3
5345: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5346: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5347: ,0)) a_zone4
5348: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5349: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5350: ,0)) a_zone5
5345: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5346: ,'4N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5347: ,0)) a_zone4
5348: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5349: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5350: ,0)) a_zone5
5351: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5352: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5353: ,0)) bl_zone1
5348: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5349: ,'5N1', fnd_number.canonical_to_number(rep_cde.action_information3)
5350: ,0)) a_zone5
5351: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5352: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5353: ,0)) bl_zone1
5354: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5355: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5356: ,0)) bl_zone2
5351: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5352: ,'1Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5353: ,0)) bl_zone1
5354: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5355: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5356: ,0)) bl_zone2
5357: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5358: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5359: ,0)) bl_zone3
5354: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5355: ,'2Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5356: ,0)) bl_zone2
5357: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5358: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5359: ,0)) bl_zone3
5360: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5361: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5362: ,0)) bl_zone4
5357: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5358: ,'3Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5359: ,0)) bl_zone3
5360: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5361: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5362: ,0)) bl_zone4
5363: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5364: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5365: ,0)) bl_zone5
5360: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5361: ,'4Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5362: ,0)) bl_zone4
5363: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5364: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5365: ,0)) bl_zone5
5366: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5367: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
5368: ,0)) sum_zone1
5363: ,SUM(DECODE(asg_act.action_information4 || asg_act.action_information7 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5364: ,'5Y1', fnd_number.canonical_to_number(rep_cde.action_information3)
5365: ,0)) bl_zone5
5366: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5367: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
5368: ,0)) sum_zone1
5369: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5370: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
5371: ,0)) sum_zone2
5366: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5367: ,'11', fnd_number.canonical_to_number(rep_cde.action_information3)
5368: ,0)) sum_zone1
5369: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5370: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
5371: ,0)) sum_zone2
5372: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5373: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
5374: ,0)) sum_zone3
5369: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5370: ,'21', fnd_number.canonical_to_number(rep_cde.action_information3)
5371: ,0)) sum_zone2
5372: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5373: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
5374: ,0)) sum_zone3
5375: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5376: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
5377: ,0)) sum_zone4
5372: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5373: ,'31', fnd_number.canonical_to_number(rep_cde.action_information3)
5374: ,0)) sum_zone3
5375: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5376: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
5377: ,0)) sum_zone4
5378: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5379: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
5380: ,0)) sum_zone5
5375: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5376: ,'41', fnd_number.canonical_to_number(rep_cde.action_information3)
5377: ,0)) sum_zone4
5378: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5379: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
5380: ,0)) sum_zone5
5381: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5382: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
5383: ,0)) sum_totals
5378: ,SUM(DECODE(asg_act.action_information4 || TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5379: ,'51', fnd_number.canonical_to_number(rep_cde.action_information3)
5380: ,0)) sum_zone5
5381: ,SUM(DECODE(TO_CHAR(SIGN(INSTR(rep_cde.action_information2, 'A')))
5382: ,'1', fnd_number.canonical_to_number(rep_cde.action_information3)
5383: ,0)) sum_totals
5384: FROM pay_assignment_actions paa
5385: ,pay_action_information le_lu
5386: ,pay_action_information asg_act
5417: (l_payroll_action_id IN NUMBER
5418: ,p_legal_employer_id IN VARCHAR2
5419: ,p_si_status IN VARCHAR2) IS
5420: SELECT SUM(DECODE(asg_act.action_information7
5421: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
5422: , 0)) a_earnings
5423: ,SUM(DECODE(asg_act.action_information7
5424: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
5425: , 0)) bl_earnings
5420: SELECT SUM(DECODE(asg_act.action_information7
5421: ,'N', fnd_number.canonical_to_number(rep_cde.action_information3)
5422: , 0)) a_earnings
5423: ,SUM(DECODE(asg_act.action_information7
5424: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
5425: , 0)) bl_earnings
5426: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
5427: FROM pay_assignment_actions paa
5428: ,pay_action_information le_lu
5422: , 0)) a_earnings
5423: ,SUM(DECODE(asg_act.action_information7
5424: ,'Y', fnd_number.canonical_to_number(rep_cde.action_information3)
5425: , 0)) bl_earnings
5426: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) sum_earnings
5427: FROM pay_assignment_actions paa
5428: ,pay_action_information le_lu
5429: ,pay_action_information asg_act
5430: ,pay_action_information rep_cde
5463: ,p_si_status IN VARCHAR2) IS
5464: SELECT asg_act.action_information2 legal_employer_id
5465: ,le_lu.action_information3 si_status
5466: ,DECODE(cde_dtl.action_information4, 'Y', rep_cde.action_information2, 'TOTAL_OTHER_CODES') code
5467: ,SUM(fnd_number.canonical_to_number(rep_cde.action_information3)) amount
5468: FROM pay_assignment_actions paa
5469: ,pay_action_information le_lu
5470: ,pay_action_information asg_act
5471: ,pay_action_information rep_cde
5745: --
5746:
5747: if l_le_si_rec.le_economic_aid is not null then
5748: g_xml_element_table(l_xml_element_count).tagname := 'TilskuddAndreTerminoppgave-datadef-27604';
5749: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_le_si_rec.le_economic_aid));
5750: g_xml_element_table(l_xml_element_count).tagattrb := 'orid="27604"';
5751: l_xml_element_count := l_xml_element_count + 1;
5752: --
5753: end if;
6060: (l_payroll_action_id IN NUMBER
6061: ,p_legal_employer_id IN VARCHAR2
6062: ,l_person_id IN NUMBER) IS
6063: SELECT rep_cde.action_information3 code
6064: ,trunc(SUM(fnd_number.canonical_to_number(aud_smr.action_information5))) amount
6065: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
6066: FROM pay_action_information rep_cde
6067: ,pay_action_information aud_smr
6068: WHERE rep_cde.action_context_type = 'PA'
6084: (l_payroll_action_id IN NUMBER
6085: ,p_legal_employer_id IN VARCHAR2
6086: ,l_person_id IN NUMBER
6087: ,l_eoy_code IN VARCHAR2) IS
6088: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
6089: FROM pay_action_information rep_cde
6090: ,pay_action_information aud_smr
6091: WHERE rep_cde.action_context_type = 'PA'
6092: AND rep_cde.action_context_id = l_payroll_action_id
6130: (l_payroll_action_id IN NUMBER
6131: ,p_legal_employer_id IN VARCHAR2
6132: ,p_person_id IN VARCHAR2 ) IS
6133: SELECT summ_cde.action_information4 code
6134: ,trunc(fnd_number.canonical_to_number(summ_cde.action_information5)) amount
6135: ,summ_cde.action_information6 info1
6136: ,summ_cde.action_information7 info2
6137: ,summ_cde.action_information8 info3
6138: ,summ_cde.action_information9 info4
6506: l_xml_element_count := l_xml_element_count + 1;
6507: --
6508: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6509: IF l_summ_code_rec.info1_dtype IN ('M','A','N','MC') THEN
6510: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info1));
6511: ELSIF l_summ_code_rec.info1_dtype = 'D' AND l_summ_code_rec.info1 <> '0' THEN
6512: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info1));
6513: ELSE
6514: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info1;
6530: l_xml_element_count := l_xml_element_count + 1;
6531: --
6532: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6533: IF l_summ_code_rec.info2_dtype IN ('M','A','N') THEN
6534: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info2));
6535: ELSIF l_summ_code_rec.info2_dtype = 'D' AND l_summ_code_rec.info2 <> '0' THEN
6536: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info2));
6537: ELSE
6538: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info2;
6555: l_xml_element_count := l_xml_element_count + 1;
6556: --
6557: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6558: IF l_summ_code_rec.info3_dtype IN ('M','A','N') THEN
6559: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info3));
6560: ELSIF l_summ_code_rec.info3_dtype = 'D' AND l_summ_code_rec.info3 <> '0' THEN
6561: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info3));
6562: ELSE
6563: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info3;
6579: l_xml_element_count := l_xml_element_count + 1;
6580: --
6581: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6582: IF l_summ_code_rec.info4_dtype IN ('M','A','N') THEN
6583: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info4));
6584: ELSIF l_summ_code_rec.info4_dtype = 'D' AND l_summ_code_rec.info4 <> '0' THEN
6585: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info4));
6586: ELSE
6587: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info4;
6603: l_xml_element_count := l_xml_element_count + 1;
6604: --
6605: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6606: IF l_summ_code_rec.info5_dtype IN ('M','A','N') THEN
6607: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info5));
6608: ELSIF l_summ_code_rec.info5_dtype = 'D' AND l_summ_code_rec.info5 <> '0' THEN
6609: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info5));
6610: ELSE
6611: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info5;
6627: l_xml_element_count := l_xml_element_count + 1;
6628: --
6629: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6630: IF l_summ_code_rec.info6_dtype IN ('M','A','N') THEN
6631: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info6));
6632: ELSIF l_summ_code_rec.info6_dtype = 'D' AND l_summ_code_rec.info6 <> '0' THEN
6633: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info6));
6634: ELSE
6635: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info6;
6651: l_xml_element_count := l_xml_element_count + 1;
6652: --
6653: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6654: IF l_summ_code_rec.info7_dtype IN ('M','A','N') THEN
6655: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info7));
6656: ELSIF l_summ_code_rec.info7_dtype = 'D' AND l_summ_code_rec.info7 <> '0' THEN
6657: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info7));
6658: ELSE
6659: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info7;
6675: l_xml_element_count := l_xml_element_count + 1;
6676: --
6677: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6678: IF l_summ_code_rec.info8_dtype IN ('M','A','N') THEN
6679: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info8));
6680: ELSIF l_summ_code_rec.info8_dtype = 'D' AND l_summ_code_rec.info8 <> '0' THEN
6681: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info8));
6682: ELSE
6683: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info8;
6699: l_xml_element_count := l_xml_element_count + 1;
6700: --
6701: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6702: IF l_summ_code_rec.info9_dtype IN ('M','A','N') THEN
6703: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info9));
6704: ELSIF l_summ_code_rec.info9_dtype = 'D' AND l_summ_code_rec.info9 <> '0' THEN
6705: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info9));
6706: ELSE
6707: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info9;
6723: l_xml_element_count := l_xml_element_count + 1;
6724: --
6725: g_xml_element_table(l_xml_element_count).tagname := 'INFO_DTLS';
6726: IF l_summ_code_rec.info10_dtype IN ('M','A','N') THEN
6727: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_number.canonical_to_number(l_summ_code_rec.info10));
6728: ELSIF l_summ_code_rec.info10_dtype = 'D' AND l_summ_code_rec.info10 <> '0' THEN
6729: g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_displaydate(fnd_date.canonical_to_date(l_summ_code_rec.info10));
6730: ELSE
6731: g_xml_element_table(l_xml_element_count).tagvalue := l_summ_code_rec.info10;
6836: (l_payroll_action_id IN NUMBER
6837: ,p_legal_employer_id IN VARCHAR2
6838: ,l_person_id IN NUMBER) IS
6839: SELECT rep_cde.action_information3 code
6840: ,trunc(SUM(fnd_number.canonical_to_number(aud_smr.action_information5))) amount
6841: ,pay_no_eoy_archive.get_info_dtype(l_payroll_action_id, p_legal_employer_id, rep_cde.action_information3, 'INFO1') info1_dtype
6842: FROM pay_action_information rep_cde
6843: ,pay_action_information aud_smr
6844: WHERE rep_cde.action_context_type = 'PA'
6860: (l_payroll_action_id IN NUMBER
6861: ,p_legal_employer_id IN VARCHAR2
6862: ,l_person_id IN NUMBER
6863: ,l_eoy_code IN VARCHAR2) IS
6864: SELECT SUM(fnd_number.canonical_to_number(aud_smr.action_information6)) info1
6865: FROM pay_action_information rep_cde
6866: ,pay_action_information aud_smr
6867: WHERE rep_cde.action_context_type = 'PA'
6868: AND rep_cde.action_context_id = l_payroll_action_id
6906: (l_payroll_action_id IN NUMBER
6907: ,p_legal_employer_id IN VARCHAR2
6908: ,p_person_id IN VARCHAR2 ) IS
6909: SELECT summ_cde.action_information4 code
6910: ,trunc(fnd_number.canonical_to_number(summ_cde.action_information5)) amount
6911: ,summ_cde.action_information6 info1
6912: ,summ_cde.action_information7 info2
6913: ,summ_cde.action_information8 info3
6914: ,summ_cde.action_information9 info4
7795: FOR l_summ_var IN 1..6 LOOP
7796: IF g_summary_code_orid(l_summ_var).orid_value = '25438' THEN
7797: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop2-datadef-25438';
7798: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7799: 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));
7800: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7801: g_xml_element_table(l_xml_element_count).tagvalue :=to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7802: ELSE
7803: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7813: FOR l_summ_var IN 1..6 LOOP
7814: IF g_summary_code_orid(l_summ_var).orid_value = '25439' THEN
7815: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAntall-datadef-25439';
7816: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7817: 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);
7818: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7819: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7820: ELSE
7821: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7832: FOR l_summ_var IN 1..6 LOOP
7833: IF g_summary_code_orid(l_summ_var).orid_value = '25440' THEN
7834: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode1-datadef-25440';
7835: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7836: 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);
7837: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7838: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7839: ELSE
7840: -- open csr_country_code(g_summary_code_orid(l_summ_var).info_data);
7858: FOR l_summ_var IN 1..6 LOOP
7859: IF g_summary_code_orid(l_summ_var).orid_value = '25441' THEN
7860: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettLandkode2-datadef-25441';
7861: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7862: 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);
7863: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7864: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7865: ELSE
7866: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7876: FOR l_summ_var IN 1..6 LOOP
7877: IF g_summary_code_orid(l_summ_var).orid_value = '25442' THEN
7878: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAr-datadef-25442';
7879: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7880: 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);
7881: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7882: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7883: ELSE
7884: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7895: FOR l_summ_var IN 1..6 LOOP
7896: IF g_summary_code_orid(l_summ_var).orid_value = '25443' THEN
7897: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop3-datadef-25443 ';
7898: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7899: 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));
7900: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7901: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7902: ELSE
7903: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7914: FOR l_summ_var IN 1..6 LOOP
7915: IF g_summary_code_orid(l_summ_var).orid_value = '25444' THEN
7916: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettFraDato-datadef-25444';
7917: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7918: 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));
7919: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7920:
7921: -- g_xml_element_table(l_xml_element_count).tagvalue := to_date(g_summary_code_orid(l_summ_var).info_data);
7922: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7935: FOR l_summ_var IN 1..6 LOOP
7936: IF g_summary_code_orid(l_summ_var).orid_value = '25445' THEN
7937: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettTilDato-datadef-25445';
7938: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7939: 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));
7940: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7941: -- g_xml_element_table(l_xml_element_count).tagvalue := fnd_date.date_to_canonical(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data));
7942: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7943: ELSE
7955: FOR l_summ_var IN 1..6 LOOP
7956: IF g_summary_code_orid(l_summ_var).orid_value = '25446' THEN
7957: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop4-datadef-25446';
7958: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7959: 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));
7960: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7961: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7962: ELSE
7963: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7974: FOR l_summ_var IN 1..6 LOOP
7975: IF g_summary_code_orid(l_summ_var).orid_value = '25447' THEN
7976: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettBelop5-datadef-25447';
7977: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7978: 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));
7979: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7980: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
7981: ELSE
7982: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
7993: FOR l_summ_var IN 1..6 LOOP
7994: IF g_summary_code_orid(l_summ_var).orid_value = '25448' THEN
7995: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning1-datadef-25448';
7996: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
7997: 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));
7998: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
7999: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
8000: ELSE
8001: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
8012: FOR l_summ_var IN 1..6 LOOP
8013: IF g_summary_code_orid(l_summ_var).orid_value = '25449' THEN
8014: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning2-datadef-25449';
8015: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
8016: 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));
8017: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
8018: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
8019: ELSE
8020: g_xml_element_table(l_xml_element_count).tagvalue := g_summary_code_orid(l_summ_var).info_data;
8030: FOR l_summ_var IN 1..6 LOOP
8031: IF g_summary_code_orid(l_summ_var).orid_value = '25450' THEN
8032: g_xml_element_table(l_xml_element_count).tagname := 'LonnsoppgaveTabelloppsettAnnenOpplysning3-datadef-25450';
8033: IF g_summary_code_orid(l_summ_var).info_datatype IN ('M','A','N','MC') THEN
8034: 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));
8035: ELSIF g_summary_code_orid(l_summ_var).info_datatype = 'D' AND g_summary_code_orid(l_summ_var).info_data <> '0' THEN
8036: g_xml_element_table(l_xml_element_count).tagvalue := to_char(fnd_date.canonical_to_date(g_summary_code_orid(l_summ_var).info_data),'yyyy-mm-dd');
8037: ELSE
8038: g_xml_element_table(l_xml_element_count).tagvalue := NVL(g_summary_code_orid(l_summ_var).info_data,'0');