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

Line 125: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value

121: AND fs.effective_date BETWEEN pee.effective_start_date AND pee.effective_end_date;
122: -- bug#8752864 fix ends
123:
124: CURSOR get_details_support_order(p_asg_act_id NUMBER ) IS
125: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
126: FROM per_all_assignments_f asg1
127: ,per_all_assignments_f asg2
128: ,per_all_people_f per
129: ,pay_element_links_f el

Line 172: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value

168: AND pac.assignment_action_id = p_asg_act_id
169: AND asg1.assignment_id = pac.assignment_id;
170:
171: CURSOR get_details_tax_levy(p_asg_act_id NUMBER ) IS
172: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
173: FROM per_all_assignments_f asg1
174: ,per_all_assignments_f asg2
175: ,per_all_people_f per
176: ,pay_element_links_f el

Line 221: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value

217: AND asg1.assignment_id = pac.assignment_id;
218:
219: --Added for bug fix 4372257
220: CURSOR get_details_union_dues(p_asg_act_id NUMBER ) IS
221: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
222: FROM per_all_assignments_f asg1
223: ,per_all_assignments_f asg2
224: ,per_all_people_f per
225: ,pay_element_links_f el

Line 267: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value

263: AND pac.assignment_action_id = p_asg_act_id
264: AND asg1.assignment_id = pac.assignment_id;
265:
266: CURSOR get_details_pension_element(p_asg_act_id NUMBER,p_element_name VARCHAR2 ) IS
267: SELECT fnd_number.canonical_to_number(eev1.screen_entry_value) screen_entry_value
268: FROM per_all_assignments_f asg1
269: ,per_all_assignments_f asg2
270: ,per_all_people_f per
271: ,pay_element_links_f el

Line 826: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8); -- Added FOR Bug - 8345827

822: and pai.action_context_id = paa.payroll_action_id
823: and pai1.action_context_id = paa.assignment_action_id
824: and paa.assignment_action_id = p_action_context_id -- New Added
825: -- ORDER BY pai.action_information5,pai1.action_information8 DESC; -- Tuned Cursor FOR Bug - 8345827
826: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8); -- Added FOR Bug - 8345827
827:
828: /*
829: ----- cursor to get the element information for additional elements ----------------
830:

Line 915: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8); -- Added FOR Bug - 8345827

911: and pai.action_context_id = paa.payroll_action_id
912: and pai1.action_context_id = paa.assignment_action_id
913: and paa.assignment_action_id = p_action_context_id
914: --ORDER BY pai.action_information5,pai1.action_information8 DESC; Changed to below -- Tuned Cursor FOR Bug - 8345827
915: ORDER BY pai.action_information5 DESC,fnd_number.canonical_to_number(pai1.action_information8); -- Added FOR Bug - 8345827
916:
917:
918: -------- cursor to get the payroll information -----------------------------
919:

Line 1057: -- Bug Fix : 5909587, using fnd_number.canonical_to_number before summing up values for payslip.

1053: END IF ;
1054:
1055: */
1056:
1057: -- Bug Fix : 5909587, using fnd_number.canonical_to_number before summing up values for payslip.
1058:
1059: IF ( csr_element_info_rec.value IS NOT NULL ) THEN
1060:
1061: IF csr_element_info_rec.type = 'S' THEN -- Total Salary

Line 1063: l_total_salary_ptd := l_total_salary_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;

1059: IF ( csr_element_info_rec.value IS NOT NULL ) THEN
1060:
1061: IF csr_element_info_rec.type = 'S' THEN -- Total Salary
1062: -- l_total_salary_ptd := l_total_salary_ptd + csr_element_info_rec.value ;
1063: l_total_salary_ptd := l_total_salary_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;
1064:
1065: ELSIF csr_element_info_rec.type = 'OR' THEN -- Total Othere Remuneration/reimbursements
1066: -- l_total_oth_rem_ptd := l_total_oth_rem_ptd + csr_element_info_rec.value ;
1067: l_total_oth_rem_ptd := l_total_oth_rem_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;

Line 1067: l_total_oth_rem_ptd := l_total_oth_rem_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;

1063: l_total_salary_ptd := l_total_salary_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;
1064:
1065: ELSIF csr_element_info_rec.type = 'OR' THEN -- Total Othere Remuneration/reimbursements
1066: -- l_total_oth_rem_ptd := l_total_oth_rem_ptd + csr_element_info_rec.value ;
1067: l_total_oth_rem_ptd := l_total_oth_rem_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;
1068:
1069: ELSIF csr_element_info_rec.type = 'OD' THEN -- Total Other Deductions
1070: -- l_total_oth_dedn_ptd := l_total_oth_dedn_ptd + csr_element_info_rec.value ;
1071: l_total_oth_dedn_ptd := l_total_oth_dedn_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;

Line 1071: l_total_oth_dedn_ptd := l_total_oth_dedn_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;

1067: l_total_oth_rem_ptd := l_total_oth_rem_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;
1068:
1069: ELSIF csr_element_info_rec.type = 'OD' THEN -- Total Other Deductions
1070: -- l_total_oth_dedn_ptd := l_total_oth_dedn_ptd + csr_element_info_rec.value ;
1071: l_total_oth_dedn_ptd := l_total_oth_dedn_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;
1072:
1073: ELSIF csr_element_info_rec.type = 'WT' THEN -- Total Withholding Tax
1074: -- l_total_with_tax_ptd := l_total_with_tax_ptd + csr_element_info_rec.value ;
1075: l_total_with_tax_ptd := l_total_with_tax_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;

Line 1075: l_total_with_tax_ptd := l_total_with_tax_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;

1071: l_total_oth_dedn_ptd := l_total_oth_dedn_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;
1072:
1073: ELSIF csr_element_info_rec.type = 'WT' THEN -- Total Withholding Tax
1074: -- l_total_with_tax_ptd := l_total_with_tax_ptd + csr_element_info_rec.value ;
1075: l_total_with_tax_ptd := l_total_with_tax_ptd + fnd_number.canonical_to_number (csr_element_info_rec.value) ;
1076:
1077: END IF ;
1078:
1079: END IF ;

Line 1085: l_total_salary_ytd := l_total_salary_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;

1081: IF ( csr_element_info_rec.bal_val_ytd IS NOT NULL ) THEN
1082:
1083: IF csr_element_info_rec.type = 'S' THEN -- Total Salary
1084: -- l_total_salary_ytd := l_total_salary_ytd + csr_element_info_rec.bal_val_ytd ;
1085: l_total_salary_ytd := l_total_salary_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;
1086:
1087: ELSIF csr_element_info_rec.type = 'OR' THEN -- Total Othere Remuneration/reimbursements
1088: -- l_total_oth_rem_ytd := l_total_oth_rem_ytd + csr_element_info_rec.bal_val_ytd ;
1089: l_total_oth_rem_ytd := l_total_oth_rem_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;

Line 1089: l_total_oth_rem_ytd := l_total_oth_rem_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;

1085: l_total_salary_ytd := l_total_salary_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;
1086:
1087: ELSIF csr_element_info_rec.type = 'OR' THEN -- Total Othere Remuneration/reimbursements
1088: -- l_total_oth_rem_ytd := l_total_oth_rem_ytd + csr_element_info_rec.bal_val_ytd ;
1089: l_total_oth_rem_ytd := l_total_oth_rem_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;
1090:
1091: ELSIF csr_element_info_rec.type = 'OD' THEN -- Total Other Deductions
1092: -- l_total_oth_dedn_ytd := l_total_oth_dedn_ytd + csr_element_info_rec.bal_val_ytd ;
1093: l_total_oth_dedn_ytd := l_total_oth_dedn_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;

Line 1093: l_total_oth_dedn_ytd := l_total_oth_dedn_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;

1089: l_total_oth_rem_ytd := l_total_oth_rem_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;
1090:
1091: ELSIF csr_element_info_rec.type = 'OD' THEN -- Total Other Deductions
1092: -- l_total_oth_dedn_ytd := l_total_oth_dedn_ytd + csr_element_info_rec.bal_val_ytd ;
1093: l_total_oth_dedn_ytd := l_total_oth_dedn_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;
1094:
1095: ELSIF csr_element_info_rec.type = 'WT' THEN -- Total Withholding Tax
1096: -- l_total_with_tax_ytd := l_total_with_tax_ytd + csr_element_info_rec.bal_val_ytd ;
1097: l_total_with_tax_ytd := l_total_with_tax_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;

Line 1097: l_total_with_tax_ytd := l_total_with_tax_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;

1093: l_total_oth_dedn_ytd := l_total_oth_dedn_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;
1094:
1095: ELSIF csr_element_info_rec.type = 'WT' THEN -- Total Withholding Tax
1096: -- l_total_with_tax_ytd := l_total_with_tax_ytd + csr_element_info_rec.bal_val_ytd ;
1097: l_total_with_tax_ytd := l_total_with_tax_ytd + fnd_number.canonical_to_number (csr_element_info_rec.bal_val_ytd) ;
1098:
1099: END IF ;
1100:
1101: END IF ;

Line 1124: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION4',fnd_number.canonical_to_number(csr_element_info_rec.value) );

1120: --pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1121: -- load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION4',csr_element_info_rec.value );
1122:
1123: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1124: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION4',fnd_number.canonical_to_number(csr_element_info_rec.value) );
1125:
1126:
1127: ---- new additions
1128:

Line 1136: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION12',fnd_number.canonical_to_number(csr_element_info_rec.bal_val_ytd ));

1132: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1133: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION14',csr_element_info_rec.payslip_info );
1134:
1135: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1136: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION12',fnd_number.canonical_to_number(csr_element_info_rec.bal_val_ytd ));
1137:
1138:
1139: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1140: load_xml('D', 'NO ELEMENT DEFINITION', 'ACTION_INFORMATION10',csr_element_info_rec.hol_basis_text );

Line 1196: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION12',fnd_number.canonical_to_number(csr_element_info_rec.bal_val_ytd ));

1192: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1193: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION14',csr_element_info_rec.payslip_info );
1194:
1195: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1196: load_xml('D', 'NO ELEMENT INFO', 'ACTION_INFORMATION12',fnd_number.canonical_to_number(csr_element_info_rec.bal_val_ytd ));
1197:
1198:
1199: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1200: load_xml('D', 'NO ELEMENT DEFINITION', 'ACTION_INFORMATION10',csr_element_info_rec.hol_basis_text );

Line 1269: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );

1265: load_xml('CS', NULL, 'SUMMARY_OF_PAYMENTS', NULL);
1266: --
1267: /*
1268: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1269: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
1270: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1271: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
1272: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1273: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );

Line 1271: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );

1267: /*
1268: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1269: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
1270: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1271: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
1272: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1273: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );
1274:
1275: */

Line 1273: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );

1269: load_xml('D', NULL, 'TOTAL_EARNINGS', fnd_number.canonical_to_number(l_total_earnings) );
1270: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1271: load_xml('D', NULL, 'TOTAL_DEDUCTIONS', fnd_number.canonical_to_number(l_total_deductions) );
1272: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1273: load_xml('D', NULL, 'TOTAL_PAY', fnd_number.canonical_to_number(l_total_pay) );
1274:
1275: */
1276:
1277: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1278: load_xml('D', NULL, 'TOTAL_SALARY_PTD', fnd_number.canonical_to_number(l_total_salary_ptd) );

1274:
1275: */
1276:
1277: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1278: load_xml('D', NULL, 'TOTAL_SALARY_PTD', fnd_number.canonical_to_number(l_total_salary_ptd) );
1279:
1280: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1281: load_xml('D', NULL, 'TOTAL_SALARY_YTD', fnd_number.canonical_to_number(l_total_salary_ytd) );
1282:

Line 1281: load_xml('D', NULL, 'TOTAL_SALARY_YTD', fnd_number.canonical_to_number(l_total_salary_ytd) );

1277: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1278: load_xml('D', NULL, 'TOTAL_SALARY_PTD', fnd_number.canonical_to_number(l_total_salary_ptd) );
1279:
1280: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1281: load_xml('D', NULL, 'TOTAL_SALARY_YTD', fnd_number.canonical_to_number(l_total_salary_ytd) );
1282:
1283:
1284:
1285: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1286: load_xml('D', NULL, 'TOTAL_OTH_REM_PTD', fnd_number.canonical_to_number(l_total_oth_rem_ptd) );

1282:
1283:
1284:
1285: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1286: load_xml('D', NULL, 'TOTAL_OTH_REM_PTD', fnd_number.canonical_to_number(l_total_oth_rem_ptd) );
1287:
1288: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1289: load_xml('D', NULL, 'TOTAL_OTH_REM_YTD', fnd_number.canonical_to_number(l_total_oth_rem_ytd) );
1290:

Line 1289: load_xml('D', NULL, 'TOTAL_OTH_REM_YTD', fnd_number.canonical_to_number(l_total_oth_rem_ytd) );

1285: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1286: load_xml('D', NULL, 'TOTAL_OTH_REM_PTD', fnd_number.canonical_to_number(l_total_oth_rem_ptd) );
1287:
1288: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1289: load_xml('D', NULL, 'TOTAL_OTH_REM_YTD', fnd_number.canonical_to_number(l_total_oth_rem_ytd) );
1290:
1291:
1292:
1293: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1294: load_xml('D', NULL, 'TOTAL_OTH_DEDN_PTD', fnd_number.canonical_to_number(l_total_oth_dedn_ptd) );

1290:
1291:
1292:
1293: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1294: load_xml('D', NULL, 'TOTAL_OTH_DEDN_PTD', fnd_number.canonical_to_number(l_total_oth_dedn_ptd) );
1295:
1296: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1297: load_xml('D', NULL, 'TOTAL_OTH_DEDN_YTD', fnd_number.canonical_to_number(l_total_oth_dedn_ytd) );
1298:

Line 1297: load_xml('D', NULL, 'TOTAL_OTH_DEDN_YTD', fnd_number.canonical_to_number(l_total_oth_dedn_ytd) );

1293: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1294: load_xml('D', NULL, 'TOTAL_OTH_DEDN_PTD', fnd_number.canonical_to_number(l_total_oth_dedn_ptd) );
1295:
1296: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1297: load_xml('D', NULL, 'TOTAL_OTH_DEDN_YTD', fnd_number.canonical_to_number(l_total_oth_dedn_ytd) );
1298:
1299:
1300:
1301: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=

Line 1302: load_xml('D', NULL, 'TOTAL_WITHHOLDING_TAX_PTD', fnd_number.canonical_to_number(l_total_with_tax_ptd) );

1298:
1299:
1300:
1301: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1302: load_xml('D', NULL, 'TOTAL_WITHHOLDING_TAX_PTD', fnd_number.canonical_to_number(l_total_with_tax_ptd) );
1303:
1304: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1305: load_xml('D', NULL, 'TOTAL_WITHHOLDING_TAX_YTD', fnd_number.canonical_to_number(l_total_with_tax_ytd) );
1306:

Line 1305: load_xml('D', NULL, 'TOTAL_WITHHOLDING_TAX_YTD', fnd_number.canonical_to_number(l_total_with_tax_ytd) );

1301: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1302: load_xml('D', NULL, 'TOTAL_WITHHOLDING_TAX_PTD', fnd_number.canonical_to_number(l_total_with_tax_ptd) );
1303:
1304: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1305: load_xml('D', NULL, 'TOTAL_WITHHOLDING_TAX_YTD', fnd_number.canonical_to_number(l_total_with_tax_ytd) );
1306:
1307: --
1308: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()+1) :=
1309: load_xml('CE', NULL, 'SUMMARY_OF_PAYMENTS', NULL);