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 832: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)

828: ,p_action_information14 => null -- for Tax unit details
829: ,p_action_information15 => null -- for Tax unit details
830: ,p_action_information16 => null -- for Tax unit details
831: ,p_action_information17 => l_industry_status
832: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)
833: ,p_action_information19 => l_nace_code
834: ,p_action_information20 => rg_LE_addr.address_line_3
835: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term
836: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term

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

831: ,p_action_information17 => l_industry_status
832: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)
833: ,p_action_information19 => l_nace_code
834: ,p_action_information20 => rg_LE_addr.address_line_3
835: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term
836: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term
837: );
838: --
839: /* Inserting the selection criteria for generating the report*/

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

832: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_el,0)) -- Other economic support (Economic Aid)
833: ,p_action_information19 => l_nace_code
834: ,p_action_information20 => rg_LE_addr.address_line_3
835: ,p_action_information21 => fnd_number.number_to_canonical(NVL(l_el_b,0)) -- remaining exemption limit prev rep term
836: ,p_action_information22 => fnd_number.number_to_canonical(NVL(l_el_a,0)) -- remaining exemption limit after rep term
837: );
838: --
839: /* Inserting the selection criteria for generating the report*/
840: pay_action_information_api.create_action_information (

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

1033: ,p_action_information_category => 'EMEA REPORT INFORMATION'
1034: ,p_action_information1 => 'PYNORSEA-WT'
1035: ,p_action_information2 => l_municipal_no
1036: ,p_action_information3 => l_municipal_name
1037: ,p_action_information4 => fnd_number.number_to_canonical(NVL(l_sum_tax_value,0)) );
1038: --
1039: l_municipal_no:=NULL;
1040: --
1041: END IF;

Line 1151: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base,0))

1147: ,p_action_information4 => rg_LU_Details.org_num
1148: ,p_action_information5 => rg_LU_Details.municipal_no
1149: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1150: ,p_action_information7 => rg_get_mun_dtls.zone
1151: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base,0))
1152: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))
1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))

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

1148: ,p_action_information5 => rg_LU_Details.municipal_no
1149: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1150: ,p_action_information7 => rg_get_mun_dtls.zone
1151: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base,0))
1152: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))
1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))

Line 1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))

1149: ,p_action_information6 => rg_get_mun_dtls.municipal_name
1150: ,p_action_information7 => rg_get_mun_dtls.zone
1151: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base,0))
1152: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))
1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))

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

1150: ,p_action_information7 => rg_get_mun_dtls.zone
1151: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base,0))
1152: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))
1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))

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

1151: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base,0))
1152: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))
1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1159: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))

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

1152: ,p_action_information9 => fnd_number.number_to_canonical(NVL(l_base_amt,0))
1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))
1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1159: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1160: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))

Line 1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))

1153: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))
1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1159: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1160: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1161: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))

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

1154: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1159: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1160: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1161: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1162: );

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

1155: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1159: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1160: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1161: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1162: );
1163: --

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

1156: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1159: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1160: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1161: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1162: );
1163: --
1164: END LOOP;

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

1157: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1158: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1159: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1160: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1161: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1162: );
1163: --
1164: END LOOP;
1165: --

Line 1254: ,p_action_information8 => fnd_number.number_to_canonical(NVL(l_base_base,0))

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

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

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

Line 1256: ,p_action_information10 => fnd_number.number_to_canonical(NVL(l_reimb_base,0))

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

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

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

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

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

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

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

Line 1260: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))

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

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

1257: ,p_action_information11 => fnd_number.number_to_canonical(-1 * NVL(l_reimb_amt,0))
1258: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1259: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1260: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1261: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1262: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1263: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1264: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1265: );

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

1258: ,p_action_information12 => fnd_number.number_to_canonical(NVL(l_utl1_base,0))
1259: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1260: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1261: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1262: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1263: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1264: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1265: );
1266: --

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

1259: ,p_action_information13 => fnd_number.number_to_canonical(NVL(l_utl1_amt,0))
1260: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1261: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1262: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1263: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1264: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1265: );
1266: --
1267: END IF; -- LU specified

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

1260: ,p_action_information14 => fnd_number.number_to_canonical(NVL(l_utr1_base,0))
1261: ,p_action_information15 => fnd_number.number_to_canonical(-1 * NVL(l_utr1_amt,0))
1262: ,p_action_information16 => fnd_number.number_to_canonical(NVL(l_utl2_base,0))
1263: ,p_action_information17 => fnd_number.number_to_canonical(NVL(l_utl2_amt,0))
1264: ,p_action_information18 => fnd_number.number_to_canonical(NVL(l_pension_base,0))
1265: );
1266: --
1267: END IF; -- LU specified
1268: --

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

1372: ,leg_emp.action_information10 post_off
1373: ,leg_emp.action_information11 email
1374: ,leg_emp.action_information12 phone
1375: ,leg_emp.action_information17 industry_status
1376: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1377: ,leg_emp.action_information19 nace_code
1378: ,leg_emp.action_information20 ada_line3
1379: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1380: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after

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

1375: ,leg_emp.action_information17 industry_status
1376: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1377: ,leg_emp.action_information19 nace_code
1378: ,leg_emp.action_information20 ada_line3
1379: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1380: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1381: FROM pay_action_information leg_emp
1382: WHERE leg_emp.action_context_type = 'PA'
1383: AND leg_emp.action_context_id = l_payroll_action_id

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

1376: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1377: ,leg_emp.action_information19 nace_code
1378: ,leg_emp.action_information20 ada_line3
1379: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1380: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1381: FROM pay_action_information leg_emp
1382: WHERE leg_emp.action_context_type = 'PA'
1383: AND leg_emp.action_context_id = l_payroll_action_id
1384: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'

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

1391: SELECT lu.action_information4 lu_org_num
1392: ,lu.action_information5 lu_municipal_num
1393: ,lu.action_information6 lu_municipal_name
1394: ,lu.action_information7 lu_zone
1395: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1396: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1397: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base

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

1392: ,lu.action_information5 lu_municipal_num
1393: ,lu.action_information6 lu_municipal_name
1394: ,lu.action_information7 lu_zone
1395: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1396: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1397: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt

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

1393: ,lu.action_information6 lu_municipal_name
1394: ,lu.action_information7 lu_zone
1395: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1396: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1397: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base

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

1394: ,lu.action_information7 lu_zone
1395: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1396: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1397: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt

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

1395: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1396: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1397: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base

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

1396: ,fnd_number.canonical_to_number(lu.action_information9) ec_amt
1397: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1404: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt

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

1397: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1404: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1405: ,fnd_number.canonical_to_number(lu.action_information18) pension_base

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

1398: ,fnd_number.canonical_to_number(lu.action_information11) reimburse_amt
1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1404: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1405: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1406: FROM pay_action_information lu

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

1399: ,fnd_number.canonical_to_number(lu.action_information12) UTL1_base
1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1404: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1405: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1406: FROM pay_action_information lu
1407: WHERE lu.action_context_type = 'PA'

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

1400: ,fnd_number.canonical_to_number(lu.action_information13) UTL1_amt
1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1404: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1405: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1406: FROM pay_action_information lu
1407: WHERE lu.action_context_type = 'PA'
1408: AND lu.action_context_id = l_payroll_action_id

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

1401: ,fnd_number.canonical_to_number(lu.action_information14) UTR1_base
1402: ,fnd_number.canonical_to_number(lu.action_information15) UTR1_amt
1403: ,fnd_number.canonical_to_number(lu.action_information16) UTL2_base
1404: ,fnd_number.canonical_to_number(lu.action_information17) UTL2_amt
1405: ,fnd_number.canonical_to_number(lu.action_information18) pension_base
1406: FROM pay_action_information lu
1407: WHERE lu.action_context_type = 'PA'
1408: AND lu.action_context_id = l_payroll_action_id
1409: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 1418: ,fnd_number.canonical_to_number(wt.action_information4) wt_tax_value

1414: --
1415: CURSOR csr_TAX (l_payroll_action_id IN NUMBER) IS
1416: SELECT wt.action_information2 wt_municipal_num
1417: ,wt.action_information3 wt_municipal_name
1418: ,fnd_number.canonical_to_number(wt.action_information4) wt_tax_value
1419: FROM pay_action_information wt
1420: WHERE wt.action_context_type = 'PA'
1421: AND wt.action_context_id = l_payroll_action_id
1422: AND wt.action_information_category = 'EMEA REPORT INFORMATION'

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

1878: ,leg_emp.action_information8 add_line2
1879: ,leg_emp.action_information9 post_code
1880: ,leg_emp.action_information10 post_off
1881: ,leg_emp.action_information17 industry_status
1882: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1883: ,leg_emp.action_information19 nace_code
1884: ,leg_emp.action_information20 add_line3
1885: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1886: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after

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

1881: ,leg_emp.action_information17 industry_status
1882: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1883: ,leg_emp.action_information19 nace_code
1884: ,leg_emp.action_information20 add_line3
1885: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1886: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1887: FROM pay_action_information leg_emp
1888: WHERE leg_emp.action_context_type = 'PA'
1889: AND leg_emp.action_context_id = l_payroll_action_id

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

1882: ,fnd_number.canonical_to_number(leg_emp.action_information18) exempt_limit
1883: ,leg_emp.action_information19 nace_code
1884: ,leg_emp.action_information20 add_line3
1885: ,fnd_number.canonical_to_number(leg_emp.action_information21) exempt_limit_prev
1886: ,fnd_number.canonical_to_number(leg_emp.action_information22) exempt_limit_after
1887: FROM pay_action_information leg_emp
1888: WHERE leg_emp.action_context_type = 'PA'
1889: AND leg_emp.action_context_id = l_payroll_action_id
1890: AND leg_emp.action_information_category = 'EMEA REPORT INFORMATION'

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

1893: rec_LEGEMP csr_LEGEMP%ROWTYPE;
1894: --
1895: CURSOR csr_sum_LU
1896: (l_payroll_action_id IN NUMBER) IS
1897: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
1898: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
1899: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum

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

1894: --
1895: CURSOR csr_sum_LU
1896: (l_payroll_action_id IN NUMBER) IS
1897: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
1898: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
1899: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))

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

1895: CURSOR csr_sum_LU
1896: (l_payroll_action_id IN NUMBER) IS
1897: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
1898: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
1899: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))

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

1896: (l_payroll_action_id IN NUMBER) IS
1897: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
1898: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
1899: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))

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

1897: SELECT SUM(fnd_number.canonical_to_number(lu.action_information8)) EC_base_sum
1898: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
1899: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))
1905: + SUM(fnd_number.canonical_to_number(lu.action_information15))

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

1898: ,SUM(fnd_number.canonical_to_number(lu.action_information10)) REIM_base_sum
1899: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))
1905: + SUM(fnd_number.canonical_to_number(lu.action_information15))
1906: + SUM(fnd_number.canonical_to_number(lu.action_information17)) amt_sum

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

1899: ,SUM(fnd_number.canonical_to_number(lu.action_information12)) UTL1_base_sum
1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))
1905: + SUM(fnd_number.canonical_to_number(lu.action_information15))
1906: + SUM(fnd_number.canonical_to_number(lu.action_information17)) amt_sum
1907: FROM pay_action_information lu

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

1900: ,SUM(fnd_number.canonical_to_number(lu.action_information14)) UTR1_base_sum
1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))
1905: + SUM(fnd_number.canonical_to_number(lu.action_information15))
1906: + SUM(fnd_number.canonical_to_number(lu.action_information17)) amt_sum
1907: FROM pay_action_information lu
1908: WHERE lu.action_context_type = 'PA'

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

1901: ,SUM(fnd_number.canonical_to_number(lu.action_information16)) UTL2_base_sum
1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))
1905: + SUM(fnd_number.canonical_to_number(lu.action_information15))
1906: + SUM(fnd_number.canonical_to_number(lu.action_information17)) amt_sum
1907: FROM pay_action_information lu
1908: WHERE lu.action_context_type = 'PA'
1909: AND lu.action_context_id = l_payroll_action_id

Line 1906: + SUM(fnd_number.canonical_to_number(lu.action_information17)) amt_sum

1902: ,SUM(fnd_number.canonical_to_number(lu.action_information9))
1903: + SUM(fnd_number.canonical_to_number(lu.action_information11))
1904: + SUM(fnd_number.canonical_to_number(lu.action_information13))
1905: + SUM(fnd_number.canonical_to_number(lu.action_information15))
1906: + SUM(fnd_number.canonical_to_number(lu.action_information17)) amt_sum
1907: FROM pay_action_information lu
1908: WHERE lu.action_context_type = 'PA'
1909: AND lu.action_context_id = l_payroll_action_id
1910: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

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

1915: CURSOR csr_LU
1916: (l_payroll_action_id IN NUMBER) IS
1917: SELECT lu.action_information4 lu_org_num
1918: ,lu.action_information5 lu_municipal_num
1919: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1920: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1921: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
1922: FROM pay_action_information lu
1923: WHERE lu.action_context_type = 'PA'

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

1916: (l_payroll_action_id IN NUMBER) IS
1917: SELECT lu.action_information4 lu_org_num
1918: ,lu.action_information5 lu_municipal_num
1919: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1920: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1921: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
1922: FROM pay_action_information lu
1923: WHERE lu.action_context_type = 'PA'
1924: AND lu.action_context_id = l_payroll_action_id

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

1917: SELECT lu.action_information4 lu_org_num
1918: ,lu.action_information5 lu_municipal_num
1919: ,fnd_number.canonical_to_number(lu.action_information8) ec_base
1920: ,fnd_number.canonical_to_number(lu.action_information10) reimburse_base
1921: ,fnd_number.canonical_to_number(lu.action_information18) pension_base_sum
1922: FROM pay_action_information lu
1923: WHERE lu.action_context_type = 'PA'
1924: AND lu.action_context_id = l_payroll_action_id
1925: AND lu.action_information_category = 'EMEA REPORT INFORMATION'

Line 1934: ,fnd_number.canonical_to_number(wt.action_information4) wt_tax_value

1930: --
1931: CURSOR csr_TAX
1932: (l_payroll_action_id IN NUMBER) IS
1933: SELECT wt.action_information2 wt_municipal_num
1934: ,fnd_number.canonical_to_number(wt.action_information4) wt_tax_value
1935: FROM pay_action_information wt
1936: WHERE wt.action_context_type = 'PA'
1937: AND wt.action_context_id = l_payroll_action_id
1938: AND wt.action_information_category = 'EMEA REPORT INFORMATION'