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 441: --AND fnd_number.canonical_to_number(prrv.result_value) <> 0)

437: AND pet.element_name <> 'Loan Recovery'
438: AND prr.status IN ('P', 'PA')
439: AND prr.run_result_id = prrv.run_result_id
440: AND prrv.input_value_id = piv.input_value_id
441: --AND fnd_number.canonical_to_number(prrv.result_value) <> 0)
442: AND prrv.result_value <> '0'
443: AND ppos.actual_termination_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
444: AND ppos.actual_termination_date BETWEEN paf.effective_start_date AND paf.effective_end_date
445: AND ppos.actual_termination_date BETWEEN pet.effective_start_date AND pet.effective_end_date

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

638: AND pel.element_link_id = pee.element_link_id
639: AND pel.business_group_id = paf.business_group_id
640: AND (pel.payroll_id = paf.payroll_id OR pel.link_to_all_payrolls_flag IS NOT NULL)
641: AND piv.element_type_id = pet.element_type_id
642: AND ((piv.name = 'Pay Value' ) --AND fnd_number.canonical_to_number(prrv.result_value) < 0)
643: OR piv.name = 'Loan Type')
644: AND paa.source_action_id = p_asg_action_id
645: AND prr.assignment_action_id = paa.assignment_action_id
646: AND ppa.payroll_action_id = paa.payroll_action_id

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

797: AND pec.classification_name = 'Termination Payments'
798: AND pet.legislation_code = 'IN'
799: AND pec.classification_id = pet.classification_id
800: AND pec.legislation_code = 'IN'
801: AND ((piv.name = 'Pay Value') --AND fnd_number.canonical_to_number(prrv.result_value) > 0
802: OR piv.name IN ('Taxable Amount'
803: , 'Non Taxable Amount'))
804: AND piv.element_type_id = pet.element_type_id
805: AND paa.source_action_id = p_max_asg_id

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

900: AND (pet.business_group_id = ppf.business_group_id OR pet.legislation_code = 'IN')
901: AND pec.classification_id = pet.classification_id
902: AND pec.legislation_code = 'IN'
903: AND piv.name = 'Pay Value'
904: -- AND fnd_number.canonical_to_number(prrv.result_value) > 0
905: AND piv.element_type_id = pet.element_type_id
906: AND paa.source_action_id = p_max_asg_id
907: AND paa.assignment_id = paf.assignment_id
908: AND prr.assignment_action_id = paa.assignment_action_id

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

942: ,p_bus_grp_id NUMBER
943: ,p_max_asg_id NUMBER)
944: IS
945: SELECT /*+ ORDERED */
946: SUM(ABS(fnd_number.canonical_to_number(prrv.result_value))) amount
947: FROM per_assignments_f paf
948: ,per_people_f ppf
949: ,pay_element_types_f pet
950: ,pay_input_values_f piv

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

959: AND ppf.person_id = paf.person_id
960: AND paf.period_of_service_id = ppos.period_of_service_id
961: AND ppf.person_id = ppos.person_id
962: AND ((pec.classification_name IN ( 'Termination Payments'
963: , 'Earnings') AND fnd_number.canonical_to_number(prrv.result_value) < 0)
964: OR (pec.classification_name IN ( 'Tax Deductions') AND fnd_number.canonical_to_number(prrv.result_value) > 0))
965: AND (pet.business_group_id = paf.business_group_id OR pet.legislation_code = 'IN')
966: AND pec.classification_id = pet.classification_id
967: AND pec.legislation_code = 'IN'

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

960: AND paf.period_of_service_id = ppos.period_of_service_id
961: AND ppf.person_id = ppos.person_id
962: AND ((pec.classification_name IN ( 'Termination Payments'
963: , 'Earnings') AND fnd_number.canonical_to_number(prrv.result_value) < 0)
964: OR (pec.classification_name IN ( 'Tax Deductions') AND fnd_number.canonical_to_number(prrv.result_value) > 0))
965: AND (pet.business_group_id = paf.business_group_id OR pet.legislation_code = 'IN')
966: AND pec.classification_id = pet.classification_id
967: AND pec.legislation_code = 'IN'
968: AND piv.name = 'Pay Value'

Line 1275: ,fnd_number.canonical_to_number(c_rec_run_results.amount)); /* bug no: 14753072 */

1271:
1272: --Amount
1273: gXMLTable(l_count).Name := 'c_amount';
1274: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1275: ,fnd_number.canonical_to_number(c_rec_run_results.amount)); /* bug no: 14753072 */
1276: l_count := l_count + 1 ;
1277:
1278: --Classification
1279: gXMLTable(l_count).Name := 'c_classification';

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

1289: or c_rec_run_results.classification = 'Allowances' THEN
1290: multiColumnar('t_earnings'
1291: ,gXMLTable
1292: ,l_count);
1293: l_total_earnings := l_total_earnings + fnd_number.canonical_to_number(c_rec_run_results.amount);
1294: --
1295: ELSIF c_rec_run_results.classification = 'Deductions'
1296: or c_rec_run_results.classification = 'Involuntary Deductions'
1297: or c_rec_run_results.classification = 'Voluntary Deductions'

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

1299: or c_rec_run_results.classification = 'Tax Deductions' THEN
1300: multiColumnar('t_deductions'
1301: ,gXMLTable
1302: ,l_count);
1303: l_total_deductions := l_total_deductions + fnd_number.canonical_to_number(c_rec_run_results.amount);
1304: --
1305: ELSIF c_rec_run_results.classification = 'Employer Charges' THEN
1306: multiColumnar('t_er_charges'
1307: ,gXMLTable

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

1305: ELSIF c_rec_run_results.classification = 'Employer Charges' THEN
1306: multiColumnar('t_er_charges'
1307: ,gXMLTable
1308: ,l_count);
1309: l_total_employer_charges := l_total_employer_charges + fnd_number.canonical_to_number(c_rec_run_results.amount);
1310: --
1311: ELSIF c_rec_run_results.classification = 'Perquisites' THEN
1312: multiColumnar('t_perquisites'
1313: ,gXMLTable

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

1311: ELSIF c_rec_run_results.classification = 'Perquisites' THEN
1312: multiColumnar('t_perquisites'
1313: ,gXMLTable
1314: ,l_count);
1315: l_total_perquisites := l_total_perquisites + fnd_number.canonical_to_number(c_rec_run_results.amount);
1316: --
1317: ELSIF c_rec_run_results.classification = 'Termination Payments'
1318: AND fnd_number.canonical_to_number(c_rec_run_results.amount) < 0 THEN
1319: multiColumnar('t_other_deductions'

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

1314: ,l_count);
1315: l_total_perquisites := l_total_perquisites + fnd_number.canonical_to_number(c_rec_run_results.amount);
1316: --
1317: ELSIF c_rec_run_results.classification = 'Termination Payments'
1318: AND fnd_number.canonical_to_number(c_rec_run_results.amount) < 0 THEN
1319: multiColumnar('t_other_deductions'
1320: ,gXMLTable
1321: ,l_count);
1322: l_total_other_deductions := l_total_other_deductions

Line 1323: + (fnd_number.canonical_to_number((c_rec_run_results.amount)));

1319: multiColumnar('t_other_deductions'
1320: ,gXMLTable
1321: ,l_count);
1322: l_total_other_deductions := l_total_other_deductions
1323: + (fnd_number.canonical_to_number((c_rec_run_results.amount)));
1324: -- /*Added code for bug fix 6660147*/
1325: ELSIF c_rec_run_results.classification = 'Advances' THEN
1326: multiColumnar('t_advances'
1327: ,gXMLTable

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

1326: multiColumnar('t_advances'
1327: ,gXMLTable
1328: ,l_count);
1329: l_total_advance := l_total_advance
1330: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));
1331: --
1332: ELSIF c_rec_run_results.classification = 'Fringe Benefits' THEN
1333: multiColumnar('t_fringe_benefits'
1334: ,gXMLTable

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

1333: multiColumnar('t_fringe_benefits'
1334: ,gXMLTable
1335: ,l_count);
1336: l_total_fringe_benefit := l_total_fringe_benefit
1337: + abs(fnd_number.canonical_to_number((c_rec_run_results.amount)));
1338: --
1339: END IF;
1340: --
1341: END LOOP;

Line 1395: ,(fnd_number.canonical_to_number(l_total_other_deductions))));

1391: END IF;
1392:
1393: IF l_total_other_deductions <> 0 THEN
1394: l_tag := getTag('c_total_other_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1395: ,(fnd_number.canonical_to_number(l_total_other_deductions))));
1396: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1397: ELSE
1398: gXMLTable(1).Name := 'No Data Exists.';
1399: gXMLTable(1).Value := ' ';

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

1404: -- /*Added code for bug fix 6660147*/
1405: --Bugfix 66660147 start
1406: IF l_total_advance <> 0 THEN
1407: l_tag := getTag('c_total_advance', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1408: ,abs(fnd_number.canonical_to_number(l_total_advance))));
1409: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1410: ELSE
1411: gXMLTable(1).Name := 'No Data Exists.';
1412: gXMLTable(1).Value := ' ';

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

1416: END IF;
1417:
1418: IF l_total_fringe_benefit <> 0 THEN
1419: l_tag := getTag('c_total_fringe_benefit', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1420: ,abs(fnd_number.canonical_to_number(l_total_fringe_benefit))));
1421: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1422: ELSE
1423: gXMLTable(1).Name := 'No Data Exists.';
1424: gXMLTable(1).Value := ' ';

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

1453: IF c_rec_loan.description = 'Loan Type' THEN
1454: --
1455: gXMLTable(l_count).Name := c_rec_loan.loan_type;
1456: --
1457: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1458: --
1459: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1460: ,(fnd_number.canonical_to_number(c_rec_loan.amount)));
1461: l_total_loan_recovery := l_total_loan_recovery + (fnd_number.canonical_to_number(c_rec_loan.amount));

Line 1460: ,(fnd_number.canonical_to_number(c_rec_loan.amount)));

1456: --
1457: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1458: --
1459: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1460: ,(fnd_number.canonical_to_number(c_rec_loan.amount)));
1461: l_total_loan_recovery := l_total_loan_recovery + (fnd_number.canonical_to_number(c_rec_loan.amount));
1462: l_count := l_count + 1;
1463: --
1464: END IF;

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

1457: ELSIF c_rec_loan.description = 'Pay Value' AND fnd_number.canonical_to_number(c_rec_loan.amount) < 0 THEN
1458: --
1459: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1460: ,(fnd_number.canonical_to_number(c_rec_loan.amount)));
1461: l_total_loan_recovery := l_total_loan_recovery + (fnd_number.canonical_to_number(c_rec_loan.amount));
1462: l_count := l_count + 1;
1463: --
1464: END IF;
1465: --

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

1475: -- If there is no data then 'No Data Exists.' is printed
1476: --
1477: IF l_total_loan_recovery <> 0 THEN
1478: l_tag := getTag('c_total_perquisites_loan_recovery', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1479: ,fnd_number.canonical_to_number(l_total_loan_recovery)));
1480: dbms_lob.writeAppend(p_xml_data, length(l_tag), l_tag);
1481: ELSE
1482: gXMLTable(1).Name := 'No Data Exists.';
1483: gXMLTable(1).Value := ' ';

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

1519: --
1520: ELSIF c_rec_leave_encashment.description = 'Encashment Amount' THEN
1521: gXMLTable(l_count).Name := 'c_amount';
1522: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1523: ,nvl(fnd_number.canonical_to_number(c_rec_leave_encashment.amount),0));
1524: END IF;
1525: l_count := l_count + 1;
1526: --
1527: IF l_count = 5 THEN

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

1525: l_count := l_count + 1;
1526: --
1527: IF l_count = 5 THEN
1528: gXMLTable(l_count).Name := 'c_remaining_leave_balance';
1529: gXMLTable(l_count).Value := to_char(fnd_number.canonical_to_number(gXMLTable(2).Value) - fnd_number.canonical_to_number(gXMLTable(3).Value)) ;
1530: multiColumnar('t_leave_encashment'
1531: ,gXMLTable
1532: ,l_count);
1533: l_count := 1;

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

1572: LOOP
1573: l_grat_elig_sal := c_rec_grat_elig_sal.amount;
1574: END LOOP;
1575: ELSE
1576: l_grat_elig_sal := fnd_number.canonical_to_number(c_rec_gratuity_payment.amount);
1577: END IF;
1578: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1579: ,(l_grat_elig_sal));
1580: --

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

1584: --
1585: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Amount' THEN
1586: gXMLTable(l_count).Name := 'c_forfeiture_amount';
1587: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1588: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1589: --
1590: ELSIF c_rec_gratuity_payment.description = 'Forfeiture Reason' THEN
1591: gXMLTable(l_count).Name := 'c_forfeiture_reason';
1592: gXMLTable(l_count).Value := hr_general.decode_lookup('IN_GRATUITY_FORFEITURE_REASON',c_rec_gratuity_payment.amount);

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

1593: --
1594: ELSIF c_rec_gratuity_payment.description = 'Pay Value' THEN
1595: gXMLTable(l_count).Name := 'c_gratuity_amount';
1596: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1597: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1598: --
1599: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1600: gXMLTable(l_count).Name := 'c_calculated_amount';
1601: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

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

1598: --
1599: ELSIF c_rec_gratuity_payment.description = 'Calculated Amount' THEN
1600: gXMLTable(l_count).Name := 'c_calculated_amount';
1601: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1602: ,nvl(fnd_number.canonical_to_number(c_rec_gratuity_payment.amount),0));
1603: --
1604: END IF;
1605: --
1606: l_count := l_count + 1;

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

1651: --
1652: IF c_rec_employee_dues.description = 'Non Taxable Amount' THEN
1653: gXMLTable(l_count).Name := 'c_amount_exempted';
1654: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1655: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1656: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1657: --
1658: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1659:

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

1652: IF c_rec_employee_dues.description = 'Non Taxable Amount' THEN
1653: gXMLTable(l_count).Name := 'c_amount_exempted';
1654: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1655: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1656: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1657: --
1658: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1659:
1660: gXMLTable(l_count).Name := 'c_amount_paid';

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

1654: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1655: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1656: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1657: --
1658: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1659:
1660: gXMLTable(l_count).Name := 'c_amount_paid';
1661: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1662: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));

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

1658: ELSIF c_rec_employee_dues.description = 'Pay Value' AND fnd_number.canonical_to_number(NVL(c_rec_employee_dues.amount,0)) > 0 THEN
1659:
1660: gXMLTable(l_count).Name := 'c_amount_paid';
1661: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1662: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1663: l_paid := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1664: --
1665: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN
1666: --

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

1659:
1660: gXMLTable(l_count).Name := 'c_amount_paid';
1661: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1662: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1663: l_paid := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1664: --
1665: ELSIF c_rec_employee_dues.description = 'Taxable Amount' THEN
1666: --
1667: IF l_count = 3 THEN

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

1672: END IF;
1673: --
1674: gXMLTable(l_count).Name := 'c_taxable_amount';
1675: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1676: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1677: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1678: END IF;
1679: --
1680: l_count := l_count + 1;

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

1673: --
1674: gXMLTable(l_count).Name := 'c_taxable_amount';
1675: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1676: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues.amount),0));
1677: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_dues.amount,0));
1678: END IF;
1679: --
1680: l_count := l_count + 1;
1681: --

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

1730: --
1731: IF c_rec_employee_term_dues.description = 'Non Taxable Amount' THEN
1732: gXMLTable(l_count).Name := 'c_amount_exempted';
1733: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1734: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1735: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1736:
1737: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1738: gXMLTable(l_count).Name := 'c_taxable_amount';

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

1731: IF c_rec_employee_term_dues.description = 'Non Taxable Amount' THEN
1732: gXMLTable(l_count).Name := 'c_amount_exempted';
1733: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1734: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1735: l_exempted := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1736:
1737: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1738: gXMLTable(l_count).Name := 'c_taxable_amount';
1739: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

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

1736:
1737: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1738: gXMLTable(l_count).Name := 'c_taxable_amount';
1739: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1740: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1741: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1742:
1743: END IF;
1744:

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

1737: ELSIF c_rec_employee_term_dues.description = 'Taxable Amount' THEN
1738: gXMLTable(l_count).Name := 'c_taxable_amount';
1739: gXMLTable(l_count).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1740: ,nvl(fnd_number.canonical_to_number(c_rec_employee_term_dues.amount),0));
1741: l_taxable := fnd_number.canonical_to_number(nvl(c_rec_employee_term_dues.amount,0));
1742:
1743: END IF;
1744:
1745: IF l_count = 3 THEN

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

1770: ,p_bus_grp_id
1771: ,l_asg_max_run_action_id)
1772: LOOP
1773: --
1774: IF fnd_number.canonical_to_number(NVL (c_rec_employee_dues_user.amount,0)) > 0 THEN
1775: l_emp_dues_flag := 1;
1776: gXMLTable(1).Name := 'c_description';
1777: gXMLTable(1).Value := (c_rec_employee_dues_user.description);
1778: --

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

1780: gXMLTable(2).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id,0);
1781: --
1782: gXMLTable(3).Name := 'c_amount_paid';
1783: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1784: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1785: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1786: --
1787: gXMLTable(4).Name := 'c_taxable_amount';
1788: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

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

1781: --
1782: gXMLTable(3).Name := 'c_amount_paid';
1783: gXMLTable(3).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1784: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1785: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1786: --
1787: gXMLTable(4).Name := 'c_taxable_amount';
1788: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1789: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));

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

1785: l_total_paid := l_total_paid + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1786: --
1787: gXMLTable(4).Name := 'c_taxable_amount';
1788: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1789: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1790: l_total_taxable := l_total_taxable + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1791: --
1792: gXMLTable(5).Name := 'c_elementname';
1793: gXMLTable(5).Value := (c_rec_employee_dues_user.elename);

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

1786: --
1787: gXMLTable(4).Name := 'c_taxable_amount';
1788: gXMLTable(4).Value := pay_us_employee_payslip_web.get_format_value(p_bus_grp_id
1789: ,nvl(fnd_number.canonical_to_number(c_rec_employee_dues_user.amount),0));
1790: l_total_taxable := l_total_taxable + fnd_number.canonical_to_number(nvl(c_rec_employee_dues_user.amount,0));
1791: --
1792: gXMLTable(5).Name := 'c_elementname';
1793: gXMLTable(5).Value := (c_rec_employee_dues_user.elename);
1794: --

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

1833: ,p_bus_grp_id
1834: ,l_asg_max_run_action_id)
1835: LOOP
1836: --
1837: l_gross_earnings := l_gross_earnings + nvl(abs(fnd_number.canonical_to_number(c_rec_gross_deductions.amount)),0);
1838: --
1839: END LOOP;
1840:
1841: l_tag := getTag('c_gross_deductions', pay_us_employee_payslip_web.get_format_value(p_bus_grp_id

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

1851: )
1852: LOOP
1853: --
1854:
1855: l_net_pay := l_net_pay + fnd_number.canonical_to_number(c_rec_balance_values.amount);
1856: --
1857:
1858: l_gross_earnings := l_gross_earnings + fnd_number.canonical_to_number(nvl(c_rec_balance_values.amount,0));
1859: --

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

1854:
1855: l_net_pay := l_net_pay + fnd_number.canonical_to_number(c_rec_balance_values.amount);
1856: --
1857:
1858: l_gross_earnings := l_gross_earnings + fnd_number.canonical_to_number(nvl(c_rec_balance_values.amount,0));
1859: --
1860: --
1861: END LOOP;
1862: l_net_pay := round(l_net_pay,2); /* rounded to two digits after decimal point to write amount in words */