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

APPS.PAY_NO_ARC_RSEA_07 dependencies on FND_NUMBER

Line 531: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id

527: l_start_date DATE,
528: l_end_date DATE,
529: p_local_unit_id NUMBER,
530: p_legal_employer_id NUMBER) IS
531: SELECT fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) asg_action_id
532: FROM pay_assignment_actions paa,
533: pay_payroll_actions ppa,
534: per_all_assignments_f paaf,
535: hr_soft_coding_keyflex hsck

Line 911: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)

907: ,p_action_information14 => null -- for Tax unit details
908: ,p_action_information15 => null -- for Tax unit details
909: ,p_action_information16 => null -- for Tax unit details
910: ,p_action_information17 => l_industry_status
911: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)
912: ,p_action_information19 => l_nace_code
913: ,p_action_information20 => rg_LE_addr.address_line_3
914: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term
915: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term

Line 914: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term

910: ,p_action_information17 => l_industry_status
911: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)
912: ,p_action_information19 => l_nace_code
913: ,p_action_information20 => rg_LE_addr.address_line_3
914: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term
915: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term
916: ,p_action_information23 => l_report_type -- Bug#9579261 fix
917: ,p_action_information24 => fnd_number.number_to_canonical(NVL(l_fe_fm_amount,0)) -- Bug#9579261 fix
918: ,p_action_information25 => rg_get_mun_dtls1.municipal_name --14260836

Line 915: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term

911: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)
912: ,p_action_information19 => l_nace_code
913: ,p_action_information20 => rg_LE_addr.address_line_3
914: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term
915: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term
916: ,p_action_information23 => l_report_type -- Bug#9579261 fix
917: ,p_action_information24 => fnd_number.number_to_canonical(NVL(l_fe_fm_amount,0)) -- Bug#9579261 fix
918: ,p_action_information25 => rg_get_mun_dtls1.municipal_name --14260836
919: );

Line 917: ,p_action_information24 => fnd_number.number_to_canonical(NVL(l_fe_fm_amount,0)) -- Bug#9579261 fix

913: ,p_action_information20 => rg_LE_addr.address_line_3
914: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term
915: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term
916: ,p_action_information23 => l_report_type -- Bug#9579261 fix
917: ,p_action_information24 => fnd_number.number_to_canonical(NVL(l_fe_fm_amount,0)) -- Bug#9579261 fix
918: ,p_action_information25 => rg_get_mun_dtls1.municipal_name --14260836
919: );
920: --
921: /* Inserting the selection criteria for generating the report*/

Line 1123: ,p_action_information4 => fnd_number.number_to_canonical(NVL(l_sum_tax_value,0))

1119: ,p_action_information_category => 'EMEA REPORT INFORMATION'
1120: ,p_action_information1 => 'PYNORSEA-WT'
1121: ,p_action_information2 => l_municipal_no
1122: ,p_action_information3 => l_municipal_name
1123: ,p_action_information4 => fnd_number.number_to_canonical(NVL(l_sum_tax_value,0))
1124: ,p_action_information5 => fnd_number.number_to_canonical(NVL(l_sum_tax_value_rep,0))
1125: );
1126: --
1127: l_municipal_no:=NULL;

Line 1124: ,p_action_information5 => fnd_number.number_to_canonical(NVL(l_sum_tax_value_rep,0))

1120: ,p_action_information1 => 'PYNORSEA-WT'
1121: ,p_action_information2 => l_municipal_no
1122: ,p_action_information3 => l_municipal_name
1123: ,p_action_information4 => fnd_number.number_to_canonical(NVL(l_sum_tax_value,0))
1124: ,p_action_information5 => fnd_number.number_to_canonical(NVL(l_sum_tax_value_rep,0))
1125: );
1126: --
1127: l_municipal_no:=NULL;
1128: --

Line 1222: l_rate := fnd_number.canonical_to_number

1218: l_def_bal_id := get_defined_balance_id('Employers Pension Premium','_TU_LU_BIMONTH') ;
1219: l_pension_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, NULL, FALSE)); --14260836
1220: --
1221: --14260836
1222: l_rate := fnd_number.canonical_to_number
1223: (hruserdt.get_table_value
1224: (l_business_group_id,
1225: 'NO_NIS_ZONE_RATES',
1226: 'NIS Rates',

Line 1251: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))

1247: ,p_action_information4 => rg_LU_Details.org_num
1248: ,p_action_information5 => rg_LU_Details.municipal_no
1249: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1250: ,p_action_information7 => rg_get_mun_dtls.zone
1251: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1252: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))

Line 1252: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))

1248: ,p_action_information5 => rg_LU_Details.municipal_no
1249: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1250: ,p_action_information7 => rg_get_mun_dtls.zone
1251: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1252: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))

Line 1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836

1249: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1250: ,p_action_information7 => rg_get_mun_dtls.zone
1251: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1252: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836

Line 1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))

1250: ,p_action_information7 => rg_get_mun_dtls.zone
1251: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1252: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))

Line 1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))

1251: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1252: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))

Line 1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))

1252: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))

Line 1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836

1253: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))

Line 1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))

1254: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1262: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount) --0 --place for pension amount --14260836

Line 1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))

1255: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1262: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount) --0 --place for pension amount --14260836
1263: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836

Line 1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))

1256: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1262: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount) --0 --place for pension amount --14260836
1263: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1264: );

Line 1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))

1257: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1262: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount) --0 --place for pension amount --14260836
1263: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1264: );
1265: --

Line 1262: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount) --0 --place for pension amount --14260836

1258: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1262: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount) --0 --place for pension amount --14260836
1263: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1264: );
1265: --
1266: END LOOP;

Line 1263: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836

1259: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1260: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1261: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1262: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount) --0 --place for pension amount --14260836
1263: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1264: );
1265: --
1266: END LOOP;
1267: --

Line 1346: l_rate := fnd_number.canonical_to_number

1342: l_def_bal_id := get_defined_balance_id('Employers Pension Premium',l_bal_dim) ; --14260836
1343: l_pension_base := FLOOR(pay_balance_pkg.get_value(l_def_bal_id, l_assignment_action, FALSE)); --14260836
1344: --
1345: --14260836
1346: l_rate := fnd_number.canonical_to_number
1347: (hruserdt.get_table_value
1348: (l_business_group_id,
1349: 'NO_NIS_ZONE_RATES',
1350: 'NIS Rates',

Line 1375: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))

1371: ,p_action_information4 => rg_LU_Details.org_num
1372: ,p_action_information5 => rg_LU_Details.municipal_no
1373: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1374: ,p_action_information7 => rg_get_mun_dtls.zone
1375: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1376: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))

Line 1376: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))

1372: ,p_action_information5 => rg_LU_Details.municipal_no
1373: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1374: ,p_action_information7 => rg_get_mun_dtls.zone
1375: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1376: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))

Line 1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836

1373: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1374: ,p_action_information7 => rg_get_mun_dtls.zone
1375: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1376: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836

Line 1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))

1374: ,p_action_information7 => rg_get_mun_dtls.zone
1375: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1376: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))

Line 1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))

1375: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base-l_pension_base,0))
1376: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))

Line 1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))

1376: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))

Line 1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836

1377: ,p_action_information10 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_base,0)) --14260836
1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))

Line 1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))

1378: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1386: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount)--0 --place for pension amount --14260836

Line 1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))

1379: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1386: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount)--0 --place for pension amount --14260836
1387: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836

Line 1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))

1380: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1386: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount)--0 --place for pension amount --14260836
1387: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1388: ,p_action_information30 => l_employee_id --14260836

Line 1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))

1381: ,p_action_information14 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_base,0)) --14260836
1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1386: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount)--0 --place for pension amount --14260836
1387: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1388: ,p_action_information30 => l_employee_id --14260836
1389: );

Line 1386: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount)--0 --place for pension amount --14260836

1382: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1386: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount)--0 --place for pension amount --14260836
1387: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1388: ,p_action_information30 => l_employee_id --14260836
1389: );
1390: --

Line 1387: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836

1383: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1384: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1385: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1386: ,p_action_information19 => fnd_number.number_to_canonical(l_pension_amount)--0 --place for pension amount --14260836
1387: ,p_action_information20 => fnd_number.number_to_canonical(l_rate) --14260836
1388: ,p_action_information30 => l_employee_id --14260836
1389: );
1390: --
1391: END IF; -- LU specified

Line 1500: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit

1496: ,leg_emp.action_information10 post_off
1497: ,leg_emp.action_information11 email
1498: ,leg_emp.action_information12 phone
1499: ,leg_emp.action_information17 industry_status
1500: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1501: ,leg_emp.action_information19 nace_code
1502: ,leg_emp.action_information20 ada_line3
1503: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1504: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after

Line 1503: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev

1499: ,leg_emp.action_information17 industry_status
1500: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1501: ,leg_emp.action_information19 nace_code
1502: ,leg_emp.action_information20 ada_line3
1503: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1504: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1505: ,leg_emp.action_information23 report_type -- Bug#9579261 fix
1506: ,leg_emp.action_information25 municipal_name --14260836
1507: FROM pay_action_information leg_emp

Line 1504: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after

1500: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1501: ,leg_emp.action_information19 nace_code
1502: ,leg_emp.action_information20 ada_line3
1503: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1504: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1505: ,leg_emp.action_information23 report_type -- Bug#9579261 fix
1506: ,leg_emp.action_information25 municipal_name --14260836
1507: FROM pay_action_information leg_emp
1508: WHERE leg_emp.action_context_type = 'PA'

Line 1521: ,fnd_number.canonical_to_number(lu.action_information8) ec_base

1517: SELECT lu.action_information4 lu_org_num
1518: ,lu.action_information5 lu_municipal_num
1519: ,lu.action_information6 lu_municipal_name
1520: ,lu.action_information7 lu_zone
1521: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1522: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base

Line 1522: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt

1518: ,lu.action_information5 lu_municipal_num
1519: ,lu.action_information6 lu_municipal_name
1520: ,lu.action_information7 lu_zone
1521: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1522: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt

Line 1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base

1519: ,lu.action_information6 lu_municipal_name
1520: ,lu.action_information7 lu_zone
1521: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1522: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base

Line 1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt

1520: ,lu.action_information7 lu_zone
1521: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1522: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt

Line 1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base

1521: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1522: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base

Line 1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt

1522: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt

Line 1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base

1523: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base

Line 1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt

1524: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836

Line 1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base

1525: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836
1533: ,fnd_number.canonical_to_number(lu.action_information20) rate --14260836

Line 1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt

1526: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836
1533: ,fnd_number.canonical_to_number(lu.action_information20) rate --14260836
1534: FROM pay_action_information lu

Line 1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base

1527: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836
1533: ,fnd_number.canonical_to_number(lu.action_information20) rate --14260836
1534: FROM pay_action_information lu
1535: WHERE lu.action_context_type = 'PA'

Line 1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836

1528: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836
1533: ,fnd_number.canonical_to_number(lu.action_information20) rate --14260836
1534: FROM pay_action_information lu
1535: WHERE lu.action_context_type = 'PA'
1536: AND lu.action_context_id = l_payroll_action_id

Line 1533: ,fnd_number.canonical_to_number(lu.action_information20) rate --14260836

1529: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1530: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1531: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1532: ,fnd_number.canonical_to_number(lu.action_information19) pension_amt --14260836
1533: ,fnd_number.canonical_to_number(lu.action_information20) rate --14260836
1534: FROM pay_action_information lu
1535: WHERE lu.action_context_type = 'PA'
1536: AND lu.action_context_id = l_payroll_action_id
1537: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 1546: ,fnd_number.canonical_to_number(wt.action_information5) wt_tax_value --14260836

1542: --
1543: CURSOR csr_TAX (l_payroll_action_id IN NUMBER) IS
1544: SELECT wt.action_information2 wt_municipal_num
1545: ,wt.action_information3 wt_municipal_name
1546: ,fnd_number.canonical_to_number(wt.action_information5) wt_tax_value --14260836
1547: FROM pay_action_information wt
1548: WHERE wt.action_context_type = 'PA'
1549: AND wt.action_context_id = l_payroll_action_id
1550: AND wt.action_information_category = 'EMEA REPORT INFORMATION'

Line 1571: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+

1567: p_lu_municipal_num VARCHAR2) IS
1568: SELECT
1569: lu.action_information4 lu_org_num
1570: ,lu.action_information5 lu_municipal_num
1571: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
1572: fnd_number.canonical_to_number(lu.action_information11)+
1573: fnd_number.canonical_to_number(lu.action_information13)+
1574: fnd_number.canonical_to_number(lu.action_information15)+
1575: fnd_number.canonical_to_number(lu.action_information17)+

Line 1572: fnd_number.canonical_to_number(lu.action_information11)+

1568: SELECT
1569: lu.action_information4 lu_org_num
1570: ,lu.action_information5 lu_municipal_num
1571: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
1572: fnd_number.canonical_to_number(lu.action_information11)+
1573: fnd_number.canonical_to_number(lu.action_information13)+
1574: fnd_number.canonical_to_number(lu.action_information15)+
1575: fnd_number.canonical_to_number(lu.action_information17)+
1576: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt

Line 1573: fnd_number.canonical_to_number(lu.action_information13)+

1569: lu.action_information4 lu_org_num
1570: ,lu.action_information5 lu_municipal_num
1571: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
1572: fnd_number.canonical_to_number(lu.action_information11)+
1573: fnd_number.canonical_to_number(lu.action_information13)+
1574: fnd_number.canonical_to_number(lu.action_information15)+
1575: fnd_number.canonical_to_number(lu.action_information17)+
1576: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
1577: FROM pay_action_information lu

Line 1574: fnd_number.canonical_to_number(lu.action_information15)+

1570: ,lu.action_information5 lu_municipal_num
1571: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
1572: fnd_number.canonical_to_number(lu.action_information11)+
1573: fnd_number.canonical_to_number(lu.action_information13)+
1574: fnd_number.canonical_to_number(lu.action_information15)+
1575: fnd_number.canonical_to_number(lu.action_information17)+
1576: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
1577: FROM pay_action_information lu
1578: WHERE lu.action_context_type = 'PA'

Line 1575: fnd_number.canonical_to_number(lu.action_information17)+

1571: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
1572: fnd_number.canonical_to_number(lu.action_information11)+
1573: fnd_number.canonical_to_number(lu.action_information13)+
1574: fnd_number.canonical_to_number(lu.action_information15)+
1575: fnd_number.canonical_to_number(lu.action_information17)+
1576: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
1577: FROM pay_action_information lu
1578: WHERE lu.action_context_type = 'PA'
1579: AND lu.action_context_id = l_payroll_action_id

Line 1576: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt

1572: fnd_number.canonical_to_number(lu.action_information11)+
1573: fnd_number.canonical_to_number(lu.action_information13)+
1574: fnd_number.canonical_to_number(lu.action_information15)+
1575: fnd_number.canonical_to_number(lu.action_information17)+
1576: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
1577: FROM pay_action_information lu
1578: WHERE lu.action_context_type = 'PA'
1579: AND lu.action_context_id = l_payroll_action_id
1580: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 2110: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit

2106: ,leg_emp.action_information8 add_line2
2107: ,leg_emp.action_information9 post_code
2108: ,leg_emp.action_information10 post_off
2109: ,leg_emp.action_information17 industry_status
2110: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
2111: ,leg_emp.action_information19 nace_code
2112: ,leg_emp.action_information20 add_line3
2113: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
2114: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after

Line 2113: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev

2109: ,leg_emp.action_information17 industry_status
2110: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
2111: ,leg_emp.action_information19 nace_code
2112: ,leg_emp.action_information20 add_line3
2113: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
2114: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
2115: ,leg_emp.action_information23 report_type -- Bug#9579261 fix
2116: ,fnd_number.canonical_to_number(leg_emp.action_information24) utl2_base -- Bug#9579261 fix
2117: FROM pay_action_information leg_emp

Line 2114: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after

2110: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
2111: ,leg_emp.action_information19 nace_code
2112: ,leg_emp.action_information20 add_line3
2113: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
2114: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
2115: ,leg_emp.action_information23 report_type -- Bug#9579261 fix
2116: ,fnd_number.canonical_to_number(leg_emp.action_information24) utl2_base -- Bug#9579261 fix
2117: FROM pay_action_information leg_emp
2118: WHERE leg_emp.action_context_type = 'PA'

Line 2116: ,fnd_number.canonical_to_number(leg_emp.action_information24) utl2_base -- Bug#9579261 fix

2112: ,leg_emp.action_information20 add_line3
2113: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
2114: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
2115: ,leg_emp.action_information23 report_type -- Bug#9579261 fix
2116: ,fnd_number.canonical_to_number(leg_emp.action_information24) utl2_base -- Bug#9579261 fix
2117: FROM pay_action_information leg_emp
2118: WHERE leg_emp.action_context_type = 'PA'
2119: AND leg_emp.action_context_id = l_payroll_action_id
2120: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'

Line 2127: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum

2123: rec_LEGEMP csr_LEGEMP%ROWTYPE;
2124: --
2125: CURSOR csr_sum_LU
2126: (l_payroll_action_id IN NUMBER) IS
2127: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2128: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum

Line 2128: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum

2124: --
2125: CURSOR csr_sum_LU
2126: (l_payroll_action_id IN NUMBER) IS
2127: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2128: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))

Line 2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum

2125: CURSOR csr_sum_LU
2126: (l_payroll_action_id IN NUMBER) IS
2127: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2128: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))

Line 2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum

2126: (l_payroll_action_id IN NUMBER) IS
2127: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2128: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))

Line 2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum

2127: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2128: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))

Line 2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))

2128: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))

Line 2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))

2129: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2137: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum

Line 2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))

2130: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2137: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2138: FROM pay_action_information lu

Line 2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))

2131: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2137: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2138: FROM pay_action_information lu
2139: WHERE lu.action_context_type = 'PA'

Line 2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))

2132: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2137: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2138: FROM pay_action_information lu
2139: WHERE lu.action_context_type = 'PA'
2140: AND lu.action_context_id = l_payroll_action_id

Line 2137: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum

2133: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2134: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2135: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2136: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2137: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2138: FROM pay_action_information lu
2139: WHERE lu.action_context_type = 'PA'
2140: AND lu.action_context_id = l_payroll_action_id
2141: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 2150: ,fnd_number.canonical_to_number(lu.action_information8) ec_base

2146: CURSOR csr_LU
2147: (l_payroll_action_id IN NUMBER) IS
2148: SELECT lu.action_information4 lu_org_num
2149: ,lu.action_information5 lu_municipal_num
2150: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
2151: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
2152: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
2153: FROM pay_action_information lu
2154: WHERE lu.action_context_type = 'PA'

Line 2151: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base

2147: (l_payroll_action_id IN NUMBER) IS
2148: SELECT lu.action_information4 lu_org_num
2149: ,lu.action_information5 lu_municipal_num
2150: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
2151: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
2152: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
2153: FROM pay_action_information lu
2154: WHERE lu.action_context_type = 'PA'
2155: AND lu.action_context_id = l_payroll_action_id

Line 2152: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum

2148: SELECT lu.action_information4 lu_org_num
2149: ,lu.action_information5 lu_municipal_num
2150: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
2151: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
2152: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
2153: FROM pay_action_information lu
2154: WHERE lu.action_context_type = 'PA'
2155: AND lu.action_context_id = l_payroll_action_id
2156: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 2165: ,fnd_number.canonical_to_number(wt.action_information5) wt_tax_value --14260836

2161: --
2162: CURSOR csr_TAX
2163: (l_payroll_action_id IN NUMBER) IS
2164: SELECT wt.action_information2 wt_municipal_num
2165: ,fnd_number.canonical_to_number(wt.action_information5) wt_tax_value --14260836
2166: FROM pay_action_information wt
2167: WHERE wt.action_context_type = 'PA'
2168: AND wt.action_context_id = l_payroll_action_id
2169: AND wt.action_information_category = 'EMEA REPORT INFORMATION'

Line 2202: ,SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum

2198: decode(sign(AMT_SUM),-1,0, Pension_base_sum) Pension_base_sum,
2199: decode(sign(AMT_SUM),-1,0, amt_sum) amt_sum
2200: from
2201: ( select lu.action_information4 lu_org_num, lu.action_information5 lu_municipal_num
2202: ,SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2203: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum

Line 2203: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum

2199: decode(sign(AMT_SUM),-1,0, amt_sum) amt_sum
2200: from
2201: ( select lu.action_information4 lu_org_num, lu.action_information5 lu_municipal_num
2202: ,SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2203: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum

Line 2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum

2200: from
2201: ( select lu.action_information4 lu_org_num, lu.action_information5 lu_municipal_num
2202: ,SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2203: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))

Line 2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum

2201: ( select lu.action_information4 lu_org_num, lu.action_information5 lu_municipal_num
2202: ,SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2203: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))

Line 2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum

2202: ,SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
2203: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))

Line 2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum

2203: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))

Line 2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))

2204: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))

Line 2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))

2205: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2213: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum

Line 2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))

2206: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2213: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2214: FROM pay_action_information lu

Line 2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))

2207: ,SUM(fnd_number.canonical_to_number(lu.action_information18)) Pension_base_sum
2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2213: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2214: FROM pay_action_information lu
2215: WHERE lu.action_context_type = 'PA'

Line 2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))

2208: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2213: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2214: FROM pay_action_information lu
2215: WHERE lu.action_context_type = 'PA'
2216: AND lu.action_context_id = l_payroll_action_id

Line 2213: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum

2209: + SUM(fnd_number.canonical_to_number(lu.action_information11))
2210: + SUM(fnd_number.canonical_to_number(lu.action_information13))
2211: + SUM(fnd_number.canonical_to_number(lu.action_information15))
2212: + SUM(fnd_number.canonical_to_number(lu.action_information17))
2213: + SUM(fnd_number.canonical_to_number(lu.action_information19))amt_sum
2214: FROM pay_action_information lu
2215: WHERE lu.action_context_type = 'PA'
2216: AND lu.action_context_id = l_payroll_action_id
2217: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 2231: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+

2227: p_lu_municipal_num VARCHAR2) IS
2228: SELECT
2229: lu.action_information4 lu_org_num
2230: ,lu.action_information5 lu_municipal_num
2231: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
2232: fnd_number.canonical_to_number(lu.action_information11)+
2233: fnd_number.canonical_to_number(lu.action_information13)+
2234: fnd_number.canonical_to_number(lu.action_information15)+
2235: fnd_number.canonical_to_number(lu.action_information17)+

Line 2232: fnd_number.canonical_to_number(lu.action_information11)+

2228: SELECT
2229: lu.action_information4 lu_org_num
2230: ,lu.action_information5 lu_municipal_num
2231: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
2232: fnd_number.canonical_to_number(lu.action_information11)+
2233: fnd_number.canonical_to_number(lu.action_information13)+
2234: fnd_number.canonical_to_number(lu.action_information15)+
2235: fnd_number.canonical_to_number(lu.action_information17)+
2236: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt

Line 2233: fnd_number.canonical_to_number(lu.action_information13)+

2229: lu.action_information4 lu_org_num
2230: ,lu.action_information5 lu_municipal_num
2231: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
2232: fnd_number.canonical_to_number(lu.action_information11)+
2233: fnd_number.canonical_to_number(lu.action_information13)+
2234: fnd_number.canonical_to_number(lu.action_information15)+
2235: fnd_number.canonical_to_number(lu.action_information17)+
2236: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
2237: FROM pay_action_information lu

Line 2234: fnd_number.canonical_to_number(lu.action_information15)+

2230: ,lu.action_information5 lu_municipal_num
2231: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
2232: fnd_number.canonical_to_number(lu.action_information11)+
2233: fnd_number.canonical_to_number(lu.action_information13)+
2234: fnd_number.canonical_to_number(lu.action_information15)+
2235: fnd_number.canonical_to_number(lu.action_information17)+
2236: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
2237: FROM pay_action_information lu
2238: WHERE lu.action_context_type = 'PA'

Line 2235: fnd_number.canonical_to_number(lu.action_information17)+

2231: ,SUM(fnd_number.canonical_to_number(lu.action_information9)+
2232: fnd_number.canonical_to_number(lu.action_information11)+
2233: fnd_number.canonical_to_number(lu.action_information13)+
2234: fnd_number.canonical_to_number(lu.action_information15)+
2235: fnd_number.canonical_to_number(lu.action_information17)+
2236: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
2237: FROM pay_action_information lu
2238: WHERE lu.action_context_type = 'PA'
2239: AND lu.action_context_id = l_payroll_action_id

Line 2236: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt

2232: fnd_number.canonical_to_number(lu.action_information11)+
2233: fnd_number.canonical_to_number(lu.action_information13)+
2234: fnd_number.canonical_to_number(lu.action_information15)+
2235: fnd_number.canonical_to_number(lu.action_information17)+
2236: fnd_number.canonical_to_number(lu.action_information19)) org_muno_grp_amt
2237: FROM pay_action_information lu
2238: WHERE lu.action_context_type = 'PA'
2239: AND lu.action_context_id = l_payroll_action_id
2240: AND lu.action_information_category = 'EMEA REPORT INFORMATION'