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_FI_ARCHIVE_DPSA dependencies on PAY_BALANCE_PKG

Line 1251: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

1247: CLOSE csr_get_person_details;
1248:
1249: /* Setting Context */
1250: BEGIN
1251: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1252: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1253: IF rg_csr_rpt_header.emp_type = 'LU' THEN
1254: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1255: END IF;

Line 1252: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);

1248:
1249: /* Setting Context */
1250: BEGIN
1251: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1252: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1253: IF rg_csr_rpt_header.emp_type = 'LU' THEN
1254: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1255: END IF;
1256:

Line 1254: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);

1250: BEGIN
1251: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1252: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1253: IF rg_csr_rpt_header.emp_type = 'LU' THEN
1254: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1255: END IF;
1256:
1257: END;
1258:

Line 1276: l_wtax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1272: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 5');
1273: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension1);
1274: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1275: CLOSE csr_Get_Defined_Balance_Id;
1276: l_wtax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1277:
1278: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_BASE'||l_dimension1);
1279: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1280: CLOSE csr_Get_Defined_Balance_Id;

Line 1281: l_tstax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1277:
1278: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_BASE'||l_dimension1);
1279: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1280: CLOSE csr_Get_Defined_Balance_Id;
1281: l_tstax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1282:
1283: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension1);
1284: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1285: CLOSE csr_Get_Defined_Balance_Id;

Line 1286: l_notional_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1282:
1283: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension1);
1284: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1285: CLOSE csr_Get_Defined_Balance_Id;
1286: l_notional_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1287:
1288: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6');
1289:
1290:

Line 1389: l_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1385: OPEN csr_Get_Defined_Balance_Id( 'BENEFITS_IN_KIND'||l_dimension1);
1386: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1387: CLOSE csr_Get_Defined_Balance_Id;
1388:
1389: l_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1390:
1391:
1392: OPEN csr_Get_Defined_Balance_Id( 'SALARY_INCOME'||l_dimension1);
1393: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1396: l_salary_income :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1392: OPEN csr_Get_Defined_Balance_Id( 'SALARY_INCOME'||l_dimension1);
1393: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1394: CLOSE csr_Get_Defined_Balance_Id;
1395:
1396: l_salary_income :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1397:
1398: /*Low Paid Employees*/
1399: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension1);
1400: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1402: l_subsidy :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1398: /*Low Paid Employees*/
1399: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension1);
1400: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1401: CLOSE csr_Get_Defined_Balance_Id;
1402: l_subsidy :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1403:
1404: IF l_subsidy > 0 THEN
1405: l_subsidy_status:='Y' ;
1406: END IF;

Line 1422: l_ptp_1_wtax_base :=pay_balance_pkg.get_value

1418:
1419: IF l_tax_card_type in ('P', 'C' ) THEN
1420:
1421: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');
1422: l_ptp_1_wtax_base :=pay_balance_pkg.get_value
1423: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1424: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1425: ,P_TAX_UNIT_ID =>g_legal_employer_id
1426: ,P_JURISDICTION_CODE =>NULL

Line 1444: l_ptp_2_wtax_base :=pay_balance_pkg.get_value

1440: ,P_SOURCE_NUMBER2 =>NULL
1441: ,P_ORGANIZATION_ID =>NULL
1442: ) ;
1443:
1444: l_ptp_2_wtax_base :=pay_balance_pkg.get_value
1445: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1446: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1447: ,P_TAX_UNIT_ID =>g_legal_employer_id
1448: ,P_JURISDICTION_CODE =>NULL

Line 1471: l_pt1_1_wtax_base :=pay_balance_pkg.get_value

1467: END IF;
1468:
1469: IF l_tax_card_type in ('EI', 'FT','S' ) AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base) <=0 THEN
1470: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
1471: l_pt1_1_wtax_base :=pay_balance_pkg.get_value
1472: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1473: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1474: ,P_TAX_UNIT_ID =>g_legal_employer_id
1475: ,P_JURISDICTION_CODE =>NULL

Line 1493: l_pt1_2_wtax_base :=pay_balance_pkg.get_value

1489: ,P_SOURCE_NUMBER2 =>NULL
1490: ,P_ORGANIZATION_ID =>NULL
1491: ) ;
1492:
1493: l_pt1_2_wtax_base :=pay_balance_pkg.get_value
1494: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1495: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1496: ,P_TAX_UNIT_ID =>g_legal_employer_id
1497: ,P_JURISDICTION_CODE =>NULL

Line 1520: l_ptp2_1_wtax_base :=pay_balance_pkg.get_value

1516:
1517: IF l_tax_card_type in ('C','FT','EI','P', 'S' )
1518: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base ) <=0 THEN
1519: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
1520: l_ptp2_1_wtax_base :=pay_balance_pkg.get_value
1521: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1522: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1523: ,P_TAX_UNIT_ID =>g_legal_employer_id
1524: ,P_JURISDICTION_CODE =>NULL

Line 1542: l_ptp2_2_wtax_base :=pay_balance_pkg.get_value

1538: ,P_SOURCE_NUMBER2 =>NULL
1539: ,P_ORGANIZATION_ID =>NULL
1540: ) ;
1541:
1542: l_ptp2_2_wtax_base :=pay_balance_pkg.get_value
1543: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1544: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1545: ,P_TAX_UNIT_ID =>g_legal_employer_id
1546: ,P_JURISDICTION_CODE =>NULL

Line 1571: l_pth_1_wtax_base :=pay_balance_pkg.get_value

1567:
1568: IF l_tax_card_type in ('EI', 'FT','S' )
1569: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base + l_ptp2_2_wtax_base + l_ptp2_2_wtax_base) <=0 THEN
1570: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 18');
1571: l_pth_1_wtax_base :=pay_balance_pkg.get_value
1572: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1573: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1574: ,P_TAX_UNIT_ID =>g_legal_employer_id
1575: ,P_JURISDICTION_CODE =>NULL

Line 1593: l_pth_2_wtax_base :=pay_balance_pkg.get_value

1589: ,P_SOURCE_NUMBER2 =>NULL
1590: ,P_ORGANIZATION_ID =>NULL
1591: ) ;
1592:
1593: l_pth_2_wtax_base :=pay_balance_pkg.get_value
1594: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1595: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1596: ,P_TAX_UNIT_ID =>g_legal_employer_id
1597: ,P_JURISDICTION_CODE =>NULL

Line 1622: l_pth2_1_wtax_base :=pay_balance_pkg.get_value

1618: IF l_tax_card_type in ('EI', 'FT','S' )
1619: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base + l_ptp2_2_wtax_base
1620: + l_ptp2_2_wtax_base + l_pth_1_wtax_base + l_pth_2_wtax_base ) <=0 THEN
1621: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20');
1622: l_pth2_1_wtax_base :=pay_balance_pkg.get_value
1623: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1624: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1625: ,P_TAX_UNIT_ID =>g_legal_employer_id
1626: ,P_JURISDICTION_CODE =>NULL

Line 1644: l_pth2_2_wtax_base :=pay_balance_pkg.get_value

1640: ,P_SOURCE_NUMBER2 =>NULL
1641: ,P_ORGANIZATION_ID =>NULL
1642: ) ;
1643:
1644: l_pth2_2_wtax_base :=pay_balance_pkg.get_value
1645: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1646: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1647: ,P_TAX_UNIT_ID =>g_legal_employer_id
1648: ,P_JURISDICTION_CODE =>NULL

Line 1734: l_tax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1730: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX'||l_dimension1);
1731: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1732: CLOSE csr_Get_Defined_Balance_Id;
1733:
1734: l_tax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1735:
1736: OPEN csr_Get_Defined_Balance_Id( 'PENSION'||l_dimension1);
1737: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1738: CLOSE csr_Get_Defined_Balance_Id;

Line 1740: l_empl_pension :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1736: OPEN csr_Get_Defined_Balance_Id( 'PENSION'||l_dimension1);
1737: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1738: CLOSE csr_Get_Defined_Balance_Id;
1739:
1740: l_empl_pension :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1741:
1742: OPEN csr_Get_Defined_Balance_Id( 'UNEMPLOYMENT_INSURANCE'||l_dimension1);
1743: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1744: CLOSE csr_Get_Defined_Balance_Id;

Line 1746: l_empl_unemp_ins :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1742: OPEN csr_Get_Defined_Balance_Id( 'UNEMPLOYMENT_INSURANCE'||l_dimension1);
1743: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1744: CLOSE csr_Get_Defined_Balance_Id;
1745:
1746: l_empl_unemp_ins :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1747:
1748: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_CAR_BENEFIT'||l_dimension1);
1749: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1750: CLOSE csr_Get_Defined_Balance_Id;

Line 1752: l_cum_car_benefit :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1748: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_CAR_BENEFIT'||l_dimension1);
1749: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1750: CLOSE csr_Get_Defined_Balance_Id;
1751:
1752: l_cum_car_benefit :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1753:
1754: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_VEHICLE_MILEAGE'||l_dimension1);
1755: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1756: CLOSE csr_Get_Defined_Balance_Id;

Line 1758: l_cum_mileage :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1754: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_VEHICLE_MILEAGE'||l_dimension1);
1755: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1756: CLOSE csr_Get_Defined_Balance_Id;
1757:
1758: l_cum_mileage :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1759:
1760: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 23');
1761: BEGIN
1762: FOR balance_rec IN csr_balance('Mortgage Benefit' , rg_csr_get_person_details.business_group_id)

Line 1768: l_mortgage_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1764: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1765: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1766: CLOSE csr_bg_Get_Defined_Balance_Id;
1767: IF csr_balance%FOUND THEN
1768: l_mortgage_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1769: l_tot_mortgage_bik := l_tot_mortgage_bik + l_mortgage_bik;
1770: END IF;
1771: END LOOP ;
1772:

Line 1790: l_other_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1786: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1787: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1788: CLOSE csr_bg_Get_Defined_Balance_Id;
1789: IF csr_balance%FOUND THEN
1790: l_other_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1791: l_tot_other_bik := l_tot_other_bik + l_other_bik;
1792: END IF;
1793: END LOOP ;
1794:

Line 1814: l_housing_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1810: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1811: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1812: CLOSE csr_bg_Get_Defined_Balance_Id;
1813: IF csr_balance%FOUND THEN
1814: l_housing_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1815: l_tot_housing_bik := l_tot_housing_bik + l_housing_bik;
1816: END IF;
1817: END LOOP ;
1818:

Line 1836: l_phone_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1832: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1833: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1834: CLOSE csr_bg_Get_Defined_Balance_Id;
1835: IF csr_balance%FOUND THEN
1836: l_phone_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1837: l_tot_phone_bik := l_tot_phone_bik + l_phone_bik;
1838: END IF;
1839: END LOOP ;
1840:

Line 1846: l_phone_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1842: -- Bug 8425533
1843: OPEN csr_Get_Defined_Balance_Id( 'PHONE_BENEFIT'||l_dimension1);
1844: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1845: CLOSE csr_Get_Defined_Balance_Id;
1846: l_phone_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1847: l_tot_phone_bik := l_tot_phone_bik + l_phone_bik;
1848:
1849: IF l_tot_phone_bik > 0 THEN
1850: l_phone_bik_status := 1;

Line 1864: l_lunch_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1860: OPEN csr_Get_Defined_Balance_Id('LUNCH_BENEFIT'||l_dimension1);
1861: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1862: CLOSE csr_Get_Defined_Balance_Id;
1863:
1864: l_lunch_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1865:
1866: IF l_lunch_bik > 0 THEN
1867: l_lunch_bik_status := 1;
1868: ELSE

Line 1876: l_half_day_allowance_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1872: OPEN csr_Get_Defined_Balance_Id( 'HALF_DAY_ALLOWANCE_EXPENSES'||l_dimension1);
1873: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1874: CLOSE csr_Get_Defined_Balance_Id;
1875:
1876: l_half_day_allowance_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1877:
1878: IF l_half_day_allowance_expenses > 0 THEN
1879: l_half_day_allowance_status :=1;
1880: ELSE

Line 1889: l_daily_allowance_d_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1885: OPEN csr_Get_Defined_Balance_Id( 'DAILY_ALLOWANCE_DOMESTIC_EXPENSES'||l_dimension1);
1886: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1887: CLOSE csr_Get_Defined_Balance_Id;
1888:
1889: l_daily_allowance_d_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1890: IF l_daily_allowance_d_expenses > 0 THEN
1891: l_daily_allowance_d_status :=1;
1892: ELSE
1893: l_daily_allowance_d_status :=0;

Line 1901: l_daily_allowance_fe_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1897: OPEN csr_Get_Defined_Balance_Id( 'DAILY_ALLOWANCE_FOREIGN_EXPENSES'||l_dimension1);
1898: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1899: CLOSE csr_Get_Defined_Balance_Id;
1900:
1901: l_daily_allowance_fe_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1902: IF l_daily_allowance_fe_expenses > 0 THEN
1903: l_daily_allowance_fe_status :=1;
1904: ELSE
1905: l_daily_allowance_fe_status :=0;

Line 1913: l_meal_comp_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1909: OPEN csr_Get_Defined_Balance_Id( 'MEAL_COMPENSATION_EXPENSES'||l_dimension1);
1910: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1911: CLOSE csr_Get_Defined_Balance_Id;
1912:
1913: l_meal_comp_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1914:
1915: IF l_meal_comp_expenses > 0 THEN
1916: l_meal_comp_status :=1;
1917: ELSE

Line 1925: l_tax_free_mileage_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1921: OPEN csr_Get_Defined_Balance_Id( 'TAX_FREE_MILEAGE_EXPENSES'||l_dimension1);
1922: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1923: CLOSE csr_Get_Defined_Balance_Id;
1924:
1925: l_tax_free_mileage_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1926:
1927:
1928: OPEN csr_Get_Defined_Balance_Id( 'TAX_FREE_MILEAGE'||l_dimension1);
1929: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1932: l_tax_free_mileage :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1928: OPEN csr_Get_Defined_Balance_Id( 'TAX_FREE_MILEAGE'||l_dimension1);
1929: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1930: CLOSE csr_Get_Defined_Balance_Id;
1931:
1932: l_tax_free_mileage :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1933:
1934: BEGIN
1935: FOR balance_rec IN csr_balance('Stock Options Benefit' , rg_csr_get_person_details.business_group_id)
1936: LOOP

Line 1941: l_stock_option_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1937: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1938: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1939: CLOSE csr_bg_Get_Defined_Balance_Id;
1940: IF csr_balance%FOUND THEN
1941: l_stock_option_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1942: l_tot_stock_option_bik := l_tot_stock_option_bik + l_stock_option_bik;
1943: END IF;
1944: END LOOP ;
1945: EXCEPTION

Line 1954: l_emp_pension :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1950: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_PENSION'||l_dimension1);
1951: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1952: CLOSE csr_Get_Defined_Balance_Id;
1953:
1954: l_emp_pension :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1955:
1956: BEGIN
1957: FOR balance_rec IN csr_balance('Travel Ticket Benefit' , rg_csr_get_person_details.business_group_id)
1958: LOOP

Line 1963: l_travel_ticket_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1959: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1960: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1961: CLOSE csr_bg_Get_Defined_Balance_Id;
1962: IF csr_balance%FOUND THEN
1963: l_travel_ticket_bik :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1964: l_tot_travel_ticket_bik := l_tot_travel_ticket_bik + l_travel_ticket_bik;
1965: END IF;
1966: END LOOP ;
1967:

Line 1986: l_other_bik_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

1982: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1983: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1984: CLOSE csr_bg_Get_Defined_Balance_Id;
1985: IF csr_balance%FOUND THEN
1986: l_other_bik_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
1987: l_tot_other_bik_ded := l_tot_other_bik_ded + l_other_bik_ded;
1988: END IF;
1989: END LOOP ;
1990:

Line 2004: l_car_bik_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2000: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
2001: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
2002: CLOSE csr_bg_Get_Defined_Balance_Id;
2003: IF csr_balance%FOUND THEN
2004: l_car_bik_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2005: l_tot_car_bik_ded := l_tot_car_bik_ded + l_car_bik_ded;
2006: END IF;
2007: END LOOP ;
2008:

Line 2021: l_lunch_bik_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2017: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
2018: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
2019: CLOSE csr_bg_Get_Defined_Balance_Id;
2020: IF csr_balance%FOUND THEN
2021: l_lunch_bik_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2022: l_tot_lunch_bik_ded := l_tot_lunch_bik_ded + l_lunch_bik_ded;
2023: END IF;
2024: END LOOP ;
2025:

Line 2040: l_tax_comp :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2036: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_COMPENSATION'||l_dimension1);
2037: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2038: CLOSE csr_Get_Defined_Balance_Id;
2039:
2040: l_tax_comp :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2041:
2042: BEGIN
2043: FOR balance_rec IN csr_balance('Payments for Elected Official' , rg_csr_get_person_details.business_group_id)
2044: LOOP

Line 2049: l_pay_eoff :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2045: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
2046: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
2047: CLOSE csr_bg_Get_Defined_Balance_Id;
2048: IF csr_balance%FOUND THEN
2049: l_pay_eoff :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2050: l_tot_pay_eoff := l_tot_pay_eoff + l_pay_eoff;
2051: END IF;
2052: END LOOP ;
2053: EXCEPTION

Line 2066: l_vol_pi :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2062: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
2063: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
2064: CLOSE csr_bg_Get_Defined_Balance_Id;
2065: IF csr_balance%FOUND THEN
2066: l_vol_pi :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2067: l_tot_vol_pi := l_tot_vol_pi + l_vol_pi;
2068: END IF;
2069: END LOOP ;
2070: EXCEPTION

Line 2082: l_total_vol_pi :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2078: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
2079: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
2080: CLOSE csr_bg_Get_Defined_Balance_Id;
2081: IF csr_balance%FOUND THEN
2082: l_total_vol_pi :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2083: l_tot_total_vol_pi := l_tot_total_vol_pi + l_total_vol_pi;
2084: END IF;
2085: END LOOP ;
2086: EXCEPTION

Line 2095: l_te :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2091:
2092: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES'||l_dimension1);
2093: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2094: CLOSE csr_Get_Defined_Balance_Id;
2095: l_te :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2096:
2097: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
2098: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2099: CLOSE csr_Get_Defined_Balance_Id;

Line 2100: l_te_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2096:
2097: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
2098: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2099: CLOSE csr_Get_Defined_Balance_Id;
2100: l_te_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2101: l_te_exem_ss :=l_te - l_te_ss;
2102:
2103: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
2104: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 2107: l_bik_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2103: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
2104: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2105: CLOSE csr_Get_Defined_Balance_Id;
2106:
2107: l_bik_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2108: l_bik_exem_ss :=l_bik - l_bik_ss;
2109:
2110: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
2111: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 2114: l_sm_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2110: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
2111: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2112: CLOSE csr_Get_Defined_Balance_Id;
2113:
2114: l_sm_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2115: l_sm_exem_ss := l_salary_income - l_sm_ss;
2116:
2117: l_tot_exem_ss := l_te_exem_ss + l_bik_exem_ss + l_sm_exem_ss;
2118:

Line 2123: l_exem_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2119: OPEN csr_Get_Defined_Balance_Id( 'EXEMPTED_SOCIAL_SECURITY'||l_dimension1);
2120: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2121: CLOSE csr_Get_Defined_Balance_Id;
2122:
2123: l_exem_ss :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2124:
2125: BEGIN
2126: FOR balance_rec IN csr_balance('Social Security Fee Deductions' , rg_csr_get_person_details.business_group_id)
2127: LOOP

Line 2132: l_ss_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2128: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
2129: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
2130: CLOSE csr_bg_Get_Defined_Balance_Id;
2131: IF csr_balance%FOUND THEN
2132: l_ss_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_bg_get_defined_bal_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2133: l_tot_ss_ded := l_tot_ss_ded + l_ss_ded;
2134: END IF;
2135: END LOOP ;
2136: EXCEPTION

Line 2156: l_pta1_1_tstax_base :=pay_balance_pkg.get_value

2152: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_BASE'||l_dimension);
2153: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2154: CLOSE csr_Get_Defined_Balance_Id;
2155:
2156: l_pta1_1_tstax_base :=pay_balance_pkg.get_value
2157: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2158: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2159: ,P_TAX_UNIT_ID =>g_legal_employer_id
2160: ,P_JURISDICTION_CODE =>NULL

Line 2179: l_pta1_2_tstax_base :=pay_balance_pkg.get_value

2175: ,P_ORGANIZATION_ID =>NULL
2176: ) ;
2177:
2178: IF l_pta1_1_tstax_base <= 0 THEN
2179: l_pta1_2_tstax_base :=pay_balance_pkg.get_value
2180: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2181: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2182: ,P_TAX_UNIT_ID =>g_legal_employer_id
2183: ,P_JURISDICTION_CODE =>NULL

Line 2207: l_pta4_1_tstax_base :=pay_balance_pkg.get_value

2203:
2204: l_pta2_2_tstax_base :=l_pta1_2_tstax_base;
2205:
2206: IF (l_pta1_1_tstax_base + l_pta1_2_tstax_base + l_pta2_1_tstax_base + l_pta2_2_tstax_base ) <= 0 THEN
2207: l_pta4_1_tstax_base :=pay_balance_pkg.get_value
2208: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2209: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2210: ,P_TAX_UNIT_ID =>g_legal_employer_id
2211: ,P_JURISDICTION_CODE =>NULL

Line 2231: l_pta5_1_tstax_base :=pay_balance_pkg.get_value

2227: ) ;
2228: END IF;
2229:
2230: IF (l_pta1_1_tstax_base + l_pta1_2_tstax_base + l_pta2_1_tstax_base + l_pta2_2_tstax_base + l_pta4_1_tstax_base ) <= 0 THEN
2231: l_pta5_1_tstax_base :=pay_balance_pkg.get_value
2232: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2233: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2234: ,P_TAX_UNIT_ID =>g_legal_employer_id
2235: ,P_JURISDICTION_CODE =>NULL

Line 2255: l_pta6_1_tstax_base :=pay_balance_pkg.get_value

2251: ) ;
2252: END IF;
2253:
2254: IF (l_pta1_1_tstax_base + l_pta1_2_tstax_base + l_pta2_1_tstax_base + l_pta2_2_tstax_base + l_pta4_1_tstax_base + l_pta5_1_tstax_base ) <= 0 THEN
2255: l_pta6_1_tstax_base :=pay_balance_pkg.get_value
2256: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2257: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2258: ,P_TAX_UNIT_ID =>g_legal_employer_id
2259: ,P_JURISDICTION_CODE =>NULL

Line 2279: l_pta7_1_tstax_base:=pay_balance_pkg.get_value

2275: ) ;
2276: END IF;
2277:
2278: IF (l_pta1_1_tstax_base + l_pta1_2_tstax_base + l_pta2_1_tstax_base + l_pta2_2_tstax_base + l_pta4_1_tstax_base + l_pta5_1_tstax_base + l_pta6_1_tstax_base) <= 0 THEN
2279: l_pta7_1_tstax_base:=pay_balance_pkg.get_value
2280: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2281: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2282: ,P_TAX_UNIT_ID =>g_legal_employer_id
2283: ,P_JURISDICTION_CODE =>NULL

Line 2363: l_tax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2359: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE'||l_dimension1);
2360: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2361: CLOSE csr_Get_Defined_Balance_Id;
2362:
2363: l_tax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2364:
2365:
2366: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY'||l_dimension1);
2367: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 2370: l_social_security :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2366: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY'||l_dimension1);
2367: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2368: CLOSE csr_Get_Defined_Balance_Id;
2369:
2370: l_social_security :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2371:
2372: /* Cursor to fetch country code against which Tax Agreement is present*/
2373: OPEN csr_country( rg_csr_get_person_details.place_residence);
2374: FETCH csr_country INTO rg_csr_country;

Line 2406: l_pt5_1_wtax_base :=pay_balance_pkg.get_value

2402: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension);
2403: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2404: CLOSE csr_Get_Defined_Balance_Id;
2405:
2406: l_pt5_1_wtax_base :=pay_balance_pkg.get_value
2407: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2408: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2409: ,P_TAX_UNIT_ID =>g_legal_employer_id
2410: ,P_JURISDICTION_CODE =>NULL

Line 2427: l_pt5_2_wtax_base :=pay_balance_pkg.get_value

2423: ,P_LOCAL_UNIT_ID =>g_local_unit_id
2424: ,P_SOURCE_NUMBER2 =>NULL
2425: ,P_ORGANIZATION_ID =>NULL
2426: ) ;
2427: l_pt5_2_wtax_base :=pay_balance_pkg.get_value
2428: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2429: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2430: ,P_TAX_UNIT_ID =>g_legal_employer_id
2431: ,P_JURISDICTION_CODE =>NULL

Line 2464: l_tax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2460:
2461: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension1);
2462: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2463: CLOSE csr_Get_Defined_Balance_Id;
2464: l_tax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2465: l_tax := 0;
2466: l_mtax_base := l_tax_base ;
2467: l_mtax := l_tax;
2468:

Line 2479: l_pth4_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2475: OPEN csr_Get_Defined_Balance_Id( 'OTHER_PAYMENTS_SUBJECT_TO_TAX'||l_dimension1);
2476: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2477: CLOSE csr_Get_Defined_Balance_Id;
2478:
2479: l_pth4_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2480:
2481: OPEN csr_Get_Defined_Balance_Id( 'COMPENSATION_FOR_USE_OF_ITEM'||l_dimension1);
2482: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2483: CLOSE csr_Get_Defined_Balance_Id;

Line 2485: l_ptg_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2481: OPEN csr_Get_Defined_Balance_Id( 'COMPENSATION_FOR_USE_OF_ITEM'||l_dimension1);
2482: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2483: CLOSE csr_Get_Defined_Balance_Id;
2484:
2485: l_ptg_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2486:
2487: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 32');
2488:
2489: IF l_tax_card_type <>'TS' THEN

Line 2496: l_ptg1_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2492: OPEN csr_Get_Defined_Balance_Id( 'CAPITAL_INCOME_BASE'||l_dimension1);
2493: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2494: CLOSE csr_Get_Defined_Balance_Id;
2495:
2496: l_ptg1_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2497:
2498: OPEN csr_Get_Defined_Balance_Id( 'CAPITAL_INCOME_TAX'||l_dimension1);
2499: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2500: CLOSE csr_Get_Defined_Balance_Id;

Line 2502: l_ptg1_tax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2498: OPEN csr_Get_Defined_Balance_Id( 'CAPITAL_INCOME_TAX'||l_dimension1);
2499: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2500: CLOSE csr_Get_Defined_Balance_Id;
2501:
2502: l_ptg1_tax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2503:
2504:
2505: END IF;
2506:

Line 2537: l_pretax_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2533: OPEN csr_Get_Defined_Balance_Id( 'DEDUCTIONS_BEFORE_TAX'||l_dimension1);
2534: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2535: CLOSE csr_Get_Defined_Balance_Id;
2536:
2537: l_pretax_ded :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2538:
2539: OPEN csr_Get_Defined_Balance_Id( 'EXTERNAL_EXPENSES'||l_dimension1);
2540: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2541: CLOSE csr_Get_Defined_Balance_Id;

Line 2543: l_external_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;

2539: OPEN csr_Get_Defined_Balance_Id( 'EXTERNAL_EXPENSES'||l_dimension1);
2540: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2541: CLOSE csr_Get_Defined_Balance_Id;
2542:
2543: l_external_expenses :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id ) ;
2544: -- fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 35');
2545: END IF;
2546:
2547: IF l_payment_type IS NOT NULL THEN

Line 2575: l_wtax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;

2571:
2572: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX'||l_dimension2);
2573: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2574: CLOSE csr_Get_Defined_Balance_Id;
2575: l_wtax :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;
2576:
2577:
2578: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension2);
2579: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 2581: l_wtax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id, P_VIRTUAL_DATE => l_bal_date) ;

2577:
2578: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension2);
2579: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2580: CLOSE csr_Get_Defined_Balance_Id;
2581: l_wtax_base :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id, P_VIRTUAL_DATE => l_bal_date) ;
2582:
2583: pay_action_information_api.create_action_information (
2584: p_action_information_id=> l_action_info_id,
2585: p_action_context_id=> p_assignment_action_id,

Line 3004: l_pt_pension_amt :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;

3000: OPEN csr_Get_Defined_Balance_Id( 'PART_TIME_PENSIONER_AMOUNT'||l_dimension2);
3001: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
3002: CLOSE csr_Get_Defined_Balance_Id;
3003:
3004: l_pt_pension_amt :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;
3005:
3006: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension2);
3007: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
3008: CLOSE csr_Get_Defined_Balance_Id;

Line 3009: l_subsidy_amt :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;

3005:
3006: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension2);
3007: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
3008: CLOSE csr_Get_Defined_Balance_Id;
3009: l_subsidy_amt :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;
3010:
3011:
3012: IF l_subsidy_amt > 0 THEN
3013:

Line 3017: l_subsidy_basis :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;

3013:
3014: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_BASIS'||l_dimension2);
3015: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
3016: CLOSE csr_Get_Defined_Balance_Id;
3017: l_subsidy_basis :=pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id, P_ASSIGNMENT_ID =>rg_csr_get_person_details.assignment_id , P_VIRTUAL_DATE => l_bal_date) ;
3018:
3019:
3020: IF l_pt_pension_amt > 0 THEN
3021: CODE_015:= l_subsidy_basis;