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

Line 346: --AND fnd_number.canonical_to_number(prrv.result_value) <> 0)

342: AND pet.element_name <> 'Loan Recovery'
343: AND prr.status IN ('P', 'PA')
344: AND prr.run_result_id = prrv.run_result_id
345: AND prrv.input_value_id = piv.input_value_id
346: --AND fnd_number.canonical_to_number(prrv.result_value) <> 0)
347: AND prrv.result_value <> '0'
348: AND ppos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
349: AND ppos.actual_termination_date BETWEEN paf.effective_start_date AND paf.effective_end_date
350: AND ppos.actual_termination_date BETWEEN pet.effective_start_date AND pet.effective_end_date

Line 546: AND ((piv.name = 'Pay Value' ) --AND fnd_number.canonical_to_number(prrv.result_value) < 0)

542: AND pel.element_link_id = pee.element_link_id
543: AND pel.business_group_id = paf.business_group_id
544: AND (pel.payroll_id = paf.payroll_id OR pel.link_to_all_payrolls_flag IS NOT NULL)
545: AND piv.element_type_id = pet.element_type_id
546: AND ((piv.name = 'Pay Value' ) --AND fnd_number.canonical_to_number(prrv.result_value) < 0)
547: OR piv.name = 'Loan Type')
548: AND paa.source_action_id = p_asg_action_id
549: AND prr.assignment_action_id = paa.assignment_action_id
550: AND ppa.payroll_action_id = paa.payroll_action_id

Line 705: AND ((piv.name = 'Pay Value') --AND fnd_number.canonical_to_number(prrv.result_value) > 0

701: AND pec.classification_name = 'Termination Payments'
702: AND pet.legislation_code = 'IN'
703: AND pec.classification_id = pet.classification_id
704: AND pec.legislation_code = 'IN'
705: AND ((piv.name = 'Pay Value') --AND fnd_number.canonical_to_number(prrv.result_value) > 0
706: OR piv.name IN ('Taxable Amount'
707: , 'Non Taxable Amount'))
708: AND piv.element_type_id = pet.element_type_id
709: AND paa.source_action_id = p_max_asg_id

Line 807: -- AND fnd_number.canonical_to_number(prrv.result_value) > 0

803: AND (pet.business_group_id = ppf.business_group_id OR pet.legislation_code = 'IN')
804: AND pec.classification_id = pet.classification_id
805: AND pec.legislation_code = 'IN'
806: AND piv.name = 'Pay Value'
807: -- AND fnd_number.canonical_to_number(prrv.result_value) > 0
808: AND piv.element_type_id = pet.element_type_id
809: AND paa.source_action_id = p_max_asg_id
810: AND paa.assignment_id = paf.assignment_id
811: AND prr.assignment_action_id = paa.assignment_action_id

Line 849: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount

845: ,p_bus_grp_id NUMBER
846: ,p_max_asg_id NUMBER)
847: IS
848: SELECT /*+ ORDERED */
849: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount
850: FROM per_assignments_f paf
851: ,per_people_f ppf
852: ,pay_element_types_f pet
853: ,pay_input_values_f piv

Line 866: , 'Earnings') AND fnd_number.canonical_to_number(prrv.result_value) < 0)

862: AND ppf.person_id = paf.person_id
863: AND paf.period_of_service_id = ppos.period_of_service_id
864: AND ppf.person_id = ppos.person_id
865: AND ((pec.classification_name IN ( 'Termination Payments'
866: , 'Earnings') AND fnd_number.canonical_to_number(prrv.result_value) < 0)
867: OR (pec.classification_name IN ( 'Tax Deductions') AND fnd_number.canonical_to_number(prrv.result_value) > 0))
868: AND (pet.business_group_id = paf.business_group_id OR pet.legislation_code = 'IN')
869: AND pec.classification_id = pet.classification_id
870: AND pec.legislation_code = 'IN'

Line 867: OR (pec.classification_name IN ( 'Tax Deductions') AND fnd_number.canonical_to_number(prrv.result_value) > 0))

863: AND paf.period_of_service_id = ppos.period_of_service_id
864: AND ppf.person_id = ppos.person_id
865: AND ((pec.classification_name IN ( 'Termination Payments'
866: , 'Earnings') AND fnd_number.canonical_to_number(prrv.result_value) < 0)
867: OR (pec.classification_name IN ( 'Tax Deductions') AND fnd_number.canonical_to_number(prrv.result_value) > 0))
868: AND (pet.business_group_id = paf.business_group_id OR pet.legislation_code = 'IN')
869: AND pec.classification_id = pet.classification_id
870: AND pec.legislation_code = 'IN'
871: AND piv.name = 'Pay Value'

Line 1162: ,abs(fnd_number.canonical_to_number(c_rec_run_results.amount)));

1158: --
1159: l_count := 1;
1160: gXMLTable(l_count).Name := c_rec_run_results.description;
1161: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1162: ,abs(fnd_number.canonical_to_number(c_rec_run_results.amount)));
1163: --
1164: IF c_rec_run_results.classification = 'Earnings'
1165: or c_rec_run_results.classification = 'Allowances' THEN
1166: twoColumnar('t_earnings'

Line 1169: l_total_earnings := l_total_earnings + fnd_number.canonical_to_number(c_rec_run_results.amount);

1165: or c_rec_run_results.classification = 'Allowances' THEN
1166: twoColumnar('t_earnings'
1167: ,gXMLTable
1168: ,l_count);
1169: l_total_earnings := l_total_earnings + fnd_number.canonical_to_number(c_rec_run_results.amount);
1170: --
1171: ELSIF c_rec_run_results.classification = 'Deductions'
1172: or c_rec_run_results.classification = 'Involuntary Deductions'
1173: or c_rec_run_results.classification = 'Voluntary Deductions'

Line 1179: l_total_deductions := l_total_deductions + fnd_number.canonical_to_number(c_rec_run_results.amount);

1175: or c_rec_run_results.classification = 'Tax Deductions' THEN
1176: twoColumnar('t_deductions'
1177: ,gXMLTable
1178: ,l_count);
1179: l_total_deductions := l_total_deductions + fnd_number.canonical_to_number(c_rec_run_results.amount);
1180: --
1181: ELSIF c_rec_run_results.classification = 'Employer Charges' THEN
1182: twoColumnar('t_er_charges'
1183: ,gXMLTable

Line 1185: l_total_employer_charges := l_total_employer_charges + fnd_number.canonical_to_number(c_rec_run_results.amount);

1181: ELSIF c_rec_run_results.classification = 'Employer Charges' THEN
1182: twoColumnar('t_er_charges'
1183: ,gXMLTable
1184: ,l_count);
1185: l_total_employer_charges := l_total_employer_charges + fnd_number.canonical_to_number(c_rec_run_results.amount);
1186: --
1187: ELSIF c_rec_run_results.classification = 'Perquisites' THEN
1188: twoColumnar('t_perquisites'
1189: ,gXMLTable

Line 1191: l_total_perquisites := l_total_perquisites + fnd_number.canonical_to_number(c_rec_run_results.amount);

1187: ELSIF c_rec_run_results.classification = 'Perquisites' THEN
1188: twoColumnar('t_perquisites'
1189: ,gXMLTable
1190: ,l_count);
1191: l_total_perquisites := l_total_perquisites + fnd_number.canonical_to_number(c_rec_run_results.amount);
1192: --
1193: ELSIF c_rec_run_results.classification = 'Termination Payments'
1194: AND fnd_number.canonical_to_number(c_rec_run_results.amount) < 0 THEN
1195: twoColumnar('t_other_deductions'

Line 1194: AND fnd_number.canonical_to_number(c_rec_run_results.amount) < 0 THEN

1190: ,l_count);
1191: l_total_perquisites := l_total_perquisites + fnd_number.canonical_to_number(c_rec_run_results.amount);
1192: --
1193: ELSIF c_rec_run_results.classification = 'Termination Payments'
1194: AND fnd_number.canonical_to_number(c_rec_run_results.amount) < 0 THEN
1195: twoColumnar('t_other_deductions'
1196: ,gXMLTable
1197: ,l_count);
1198: l_total_other_deductions := l_total_other_deductions

Line 1199: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));

1195: twoColumnar('t_other_deductions'
1196: ,gXMLTable
1197: ,l_count);
1198: l_total_other_deductions := l_total_other_deductions
1199: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));
1200: -- /*Added code for bug fix 6660147*/
1201: ELSIF c_rec_run_results.classification = 'Advances' THEN
1202: twoColumnar('t_advances'
1203: ,gXMLTable

Line 1206: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));

1202: twoColumnar('t_advances'
1203: ,gXMLTable
1204: ,l_count);
1205: l_total_advance := l_total_advance
1206: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));
1207: --
1208: ELSIF c_rec_run_results.classification = 'Fringe Benefits' THEN
1209: twoColumnar('t_fringe_benefits'
1210: ,gXMLTable

Line 1213: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));

1209: twoColumnar('t_fringe_benefits'
1210: ,gXMLTable
1211: ,l_count);
1212: l_total_fringe_benefit := l_total_fringe_benefit
1213: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));
1214: --
1215: END IF;
1216: --
1217: END LOOP;

Line 1271: ,abs(fnd_number.canonical_to_number(l_total_other_deductions))));

1267: END IF;
1268:
1269: IF l_total_other_deductions <> 0 THEN
1270: l_tag := getTag('c_total_other_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1271: ,abs(fnd_number.canonical_to_number(l_total_other_deductions))));
1272: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1273: ELSE
1274: gXMLTable(1).Name := 'No Data Exists.';
1275: gXMLTable(1).Value := ' ';

Line 1284: ,abs(fnd_number.canonical_to_number(l_total_advance))));

1280: -- /*Added code for bug fix 6660147*/
1281: --Bugfix 66660147 start
1282: IF l_total_advance <> 0 THEN
1283: l_tag := getTag('c_total_advance', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1284: ,abs(fnd_number.canonical_to_number(l_total_advance))));
1285: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1286: ELSE
1287: gXMLTable(1).Name := 'No Data Exists.';
1288: gXMLTable(1).Value := ' ';

Line 1296: ,abs(fnd_number.canonical_to_number(l_total_fringe_benefit))));

1292: END IF;
1293:
1294: IF l_total_fringe_benefit <> 0 THEN
1295: l_tag := getTag('c_total_fringe_benefit', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1296: ,abs(fnd_number.canonical_to_number(l_total_fringe_benefit))));
1297: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1298: ELSE
1299: gXMLTable(1).Name := 'No Data Exists.';
1300: gXMLTable(1).Value := ' ';

Line 1333: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN

1329: IF c_rec_loan.description = 'Loan Type' THEN
1330: --
1331: gXMLTable(l_count).Name := c_rec_loan.loan_type;
1332: --
1333: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1334: --
1335: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1336: ,abs(fnd_number.canonical_to_number(c_rec_loan.amount)));
1337: l_total_loan_recovery := l_total_loan_recovery + abs(fnd_number.canonical_to_number(c_rec_loan.amount));

Line 1336: ,abs(fnd_number.canonical_to_number(c_rec_loan.amount)));

1332: --
1333: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1334: --
1335: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1336: ,abs(fnd_number.canonical_to_number(c_rec_loan.amount)));
1337: l_total_loan_recovery := l_total_loan_recovery + abs(fnd_number.canonical_to_number(c_rec_loan.amount));
1338: l_count := l_count + 1;
1339: --
1340: END IF;

Line 1337: l_total_loan_recovery := l_total_loan_recovery + abs(fnd_number.canonical_to_number(c_rec_loan.amount));

1333: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1334: --
1335: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1336: ,abs(fnd_number.canonical_to_number(c_rec_loan.amount)));
1337: l_total_loan_recovery := l_total_loan_recovery + abs(fnd_number.canonical_to_number(c_rec_loan.amount));
1338: l_count := l_count + 1;
1339: --
1340: END IF;
1341: --

Line 1355: ,fnd_number.canonical_to_number(l_total_loan_recovery)));

1351: -- If there is no data then 'No Data Exists.' is printed
1352: --
1353: IF l_total_loan_recovery <> 0 THEN
1354: l_tag := getTag('c_total_perquisites_loan_recovery', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1355: ,fnd_number.canonical_to_number(l_total_loan_recovery)));
1356: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1357: ELSE
1358: gXMLTable(1).Name := 'No Data Exists.';
1359: gXMLTable(1).Value := ' ';

Line 1399: ,nvl(fnd_number.canonical_to_number(c_rec_leave_encashment.amount),0));

1395: --
1396: ELSIF c_rec_leave_encashment.description = 'Encashment Amount' THEN
1397: gXMLTable(l_count).Name := 'c_amount';
1398: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1399: ,nvl(fnd_number.canonical_to_number(c_rec_leave_encashment.amount),0));
1400: END IF;
1401: l_count := l_count + 1;
1402: --
1403: IF l_count = 5 THEN

Line 1405: gXMLTable(l_count).Value := to_char(fnd_number.canonical_to_number(gXMLTable(2).Value) - fnd_number.canonical_to_number(gXMLTable(3).Value)) ;

1401: l_count := l_count + 1;
1402: --
1403: IF l_count = 5 THEN
1404: gXMLTable(l_count).Name := 'c_remaining_leave_balance';
1405: gXMLTable(l_count).Value := to_char(fnd_number.canonical_to_number(gXMLTable(2).Value) - fnd_number.canonical_to_number(gXMLTable(3).Value)) ;
1406: multiColumnar('t_leave_encashment'
1407: ,gXMLTable
1408: ,l_count);
1409: l_count := 1;

Line 1452: l_grat_elig_sal := fnd_number.canonical_to_number(c_rec_gratuity_payment.amount);

1448: LOOP
1449: l_grat_elig_sal := c_rec_grat_elig_sal.amount;
1450: END LOOP;
1451: ELSE
1452: l_grat_elig_sal := fnd_number.canonical_to_number(c_rec_gratuity_payment.amount);
1453: END IF;
1454: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1455: ,(l_grat_elig_sal));
1456: --

Line 1464: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));

1460: --
1461: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Amount' THEN
1462: gXMLTable(l_count).Name := 'c_forfeiture_amount';
1463: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1464: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1465: --
1466: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Reason' THEN
1467: gXMLTable(l_count).Name := 'c_forfeiture_reason';
1468: gXMLTable(l_count).Value := hr_general.decode_lookup('IN_GRATUITY_FORFEITURE_REASON',c_rec_gratuity_payment.amount);

Line 1473: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));

1469: --
1470: ELSIF c_rec_gratuity_payment.description = 'Pay Value' THEN
1471: gXMLTable(l_count).Name := 'c_gratuity_amount';
1472: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1473: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1474: --
1475: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1476: gXMLTable(l_count).Name := 'c_calculated_amount';
1477: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

Line 1478: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));

1474: --
1475: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1476: gXMLTable(l_count).Name := 'c_calculated_amount';
1477: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1478: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1479: --
1480: END IF;
1481: --
1482: l_count := l_count + 1;

Line 1531: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));

1527: --
1528: IF c_rec_employee_dues.description = 'Non Taxable Amount' THEN
1529: gXMLTable(l_count).Name := 'c_amount_exempted';
1530: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1531: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1532: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1533: --
1534: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1535:

Line 1532: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));

1528: IF c_rec_employee_dues.description = 'Non Taxable Amount' THEN
1529: gXMLTable(l_count).Name := 'c_amount_exempted';
1530: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1531: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1532: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1533: --
1534: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1535:
1536: gXMLTable(l_count).Name := 'c_amount_paid';

Line 1534: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN

1530: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1531: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1532: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1533: --
1534: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1535:
1536: gXMLTable(l_count).Name := 'c_amount_paid';
1537: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1538: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));

Line 1538: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));

1534: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1535:
1536: gXMLTable(l_count).Name := 'c_amount_paid';
1537: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1538: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1539: l_paid := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1540: --
1541: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN
1542: --

Line 1539: l_paid := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));

1535:
1536: gXMLTable(l_count).Name := 'c_amount_paid';
1537: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1538: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1539: l_paid := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1540: --
1541: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN
1542: --
1543: IF l_count = 3 THEN

Line 1552: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));

1548: END IF;
1549: --
1550: gXMLTable(l_count).Name := 'c_taxable_amount';
1551: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1552: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1553: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1554: END IF;
1555: --
1556: l_count := l_count + 1;

Line 1553: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));

1549: --
1550: gXMLTable(l_count).Name := 'c_taxable_amount';
1551: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1552: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1553: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1554: END IF;
1555: --
1556: l_count := l_count + 1;
1557: --

Line 1608: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));

1604: --
1605: IF c_rec_employee_term_dues.description = 'Non Taxable Amount' THEN
1606: gXMLTable(l_count).Name := 'c_amount_exempted';
1607: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1608: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1609: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1610:
1611: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1612: gXMLTable(l_count).Name := 'c_taxable_amount';

Line 1609: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));

1605: IF c_rec_employee_term_dues.description = 'Non Taxable Amount' THEN
1606: gXMLTable(l_count).Name := 'c_amount_exempted';
1607: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1608: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1609: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1610:
1611: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1612: gXMLTable(l_count).Name := 'c_taxable_amount';
1613: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

Line 1614: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));

1610:
1611: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1612: gXMLTable(l_count).Name := 'c_taxable_amount';
1613: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1614: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1615: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1616:
1617: END IF;
1618:

Line 1615: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));

1611: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1612: gXMLTable(l_count).Name := 'c_taxable_amount';
1613: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1614: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1615: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1616:
1617: END IF;
1618:
1619: IF l_count = 3 THEN

Line 1648: IF fnd_number.canonical_to_number(NVL (c_rec_employee_dues_user.amount,0)) > 0 THEN

1644: ,p_bus_grp_id
1645: ,l_asg_max_run_action_id)
1646: LOOP
1647: --
1648: IF fnd_number.canonical_to_number(NVL (c_rec_employee_dues_user.amount,0)) > 0 THEN
1649: l_emp_dues_flag := 1;
1650: gXMLTable(1).Name := 'c_description';
1651: gXMLTable(1).Value := (c_rec_employee_dues_user.description);
1652: --

Line 1658: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));

1654: gXMLTable(2).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1655: --
1656: gXMLTable(3).Name := 'c_amount_paid';
1657: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1658: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1659: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1660: --
1661: gXMLTable(4).Name := 'c_taxable_amount';
1662: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

Line 1659: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));

1655: --
1656: gXMLTable(3).Name := 'c_amount_paid';
1657: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1658: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1659: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1660: --
1661: gXMLTable(4).Name := 'c_taxable_amount';
1662: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1663: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));

Line 1663: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));

1659: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1660: --
1661: gXMLTable(4).Name := 'c_taxable_amount';
1662: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1663: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1664: l_total_taxable := l_total_taxable + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1665: --
1666: multiColumnar('t_due_to_ee'
1667: ,gXMLTable

Line 1664: l_total_taxable := l_total_taxable + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));

1660: --
1661: gXMLTable(4).Name := 'c_taxable_amount';
1662: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1663: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1664: l_total_taxable := l_total_taxable + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1665: --
1666: multiColumnar('t_due_to_ee'
1667: ,gXMLTable
1668: ,4);

Line 1708: l_gross_earnings := l_gross_earnings + nvl(abs(fnd_number.canonical_to_number(c_rec_gross_deductions.amount)),0);

1704: ,p_bus_grp_id
1705: ,l_asg_max_run_action_id)
1706: LOOP
1707: --
1708: l_gross_earnings := l_gross_earnings + nvl(abs(fnd_number.canonical_to_number(c_rec_gross_deductions.amount)),0);
1709: --
1710: END LOOP;
1711:
1712: l_tag := getTag('c_gross_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

Line 1726: l_net_pay := l_net_pay + fnd_number.canonical_to_number(c_rec_balance_values.amount);

1722: )
1723: LOOP
1724: --
1725:
1726: l_net_pay := l_net_pay + fnd_number.canonical_to_number(c_rec_balance_values.amount);
1727: --
1728:
1729: l_gross_earnings := l_gross_earnings + fnd_number.canonical_to_number(nvl(c_rec_balance_values.amount,0));
1730: --

Line 1729: l_gross_earnings := l_gross_earnings + fnd_number.canonical_to_number(nvl(c_rec_balance_values.amount,0));

1725:
1726: l_net_pay := l_net_pay + fnd_number.canonical_to_number(c_rec_balance_values.amount);
1727: --
1728:
1729: l_gross_earnings := l_gross_earnings + fnd_number.canonical_to_number(nvl(c_rec_balance_values.amount,0));
1730: --
1731: --
1732: END LOOP;
1733: