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 1189: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);

1185: CLOSE csr_get_person_details;
1186:
1187: /* Setting Context */
1188: BEGIN
1189: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1190: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1191: IF rg_csr_rpt_header.emp_type = 'LU' THEN
1192: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1193: END IF;

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

1186:
1187: /* Setting Context */
1188: BEGIN
1189: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1190: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1191: IF rg_csr_rpt_header.emp_type = 'LU' THEN
1192: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1193: END IF;
1194:

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

1188: BEGIN
1189: pay_balance_pkg.set_context('ASSIGNMENT_ACTION_ID',p_assignment_action_id);
1190: pay_balance_pkg.set_context('TAX_UNIT_ID',g_legal_employer_id);
1191: IF rg_csr_rpt_header.emp_type = 'LU' THEN
1192: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id);
1193: END IF;
1194:
1195: END;
1196:

Line 1214: 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 ) ;

1210: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 5');
1211: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension1);
1212: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1213: CLOSE csr_Get_Defined_Balance_Id;
1214: 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 ) ;
1215:
1216: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_BASE'||l_dimension1);
1217: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1218: CLOSE csr_Get_Defined_Balance_Id;

Line 1219: 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 ) ;

1215:
1216: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_BASE'||l_dimension1);
1217: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1218: CLOSE csr_Get_Defined_Balance_Id;
1219: 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 ) ;
1220:
1221: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension1);
1222: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1223: CLOSE csr_Get_Defined_Balance_Id;

Line 1224: 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 ) ;

1220:
1221: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension1);
1222: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1223: CLOSE csr_Get_Defined_Balance_Id;
1224: 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 ) ;
1225:
1226: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 6');
1227:
1228:

Line 1258: 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 ) ;

1254: OPEN csr_Get_Defined_Balance_Id( 'BENEFITS_IN_KIND'||l_dimension1);
1255: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1256: CLOSE csr_Get_Defined_Balance_Id;
1257:
1258: 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 ) ;
1259:
1260:
1261: OPEN csr_Get_Defined_Balance_Id( 'SALARY_INCOME'||l_dimension1);
1262: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1265: 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 ) ;

1261: OPEN csr_Get_Defined_Balance_Id( 'SALARY_INCOME'||l_dimension1);
1262: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1263: CLOSE csr_Get_Defined_Balance_Id;
1264:
1265: 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 ) ;
1266:
1267: /*Low Paid Employees*/
1268: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension1);
1269: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1271: 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 ) ;

1267: /*Low Paid Employees*/
1268: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension1);
1269: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1270: CLOSE csr_Get_Defined_Balance_Id;
1271: 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 ) ;
1272:
1273: IF l_subsidy > 0 THEN
1274: l_subsidy_status:='Y' ;
1275: END IF;

Line 1291: l_ptp_1_wtax_base :=pay_balance_pkg.get_value

1287:
1288: IF l_tax_card_type in ('P', 'C' ) THEN
1289:
1290: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 12');
1291: l_ptp_1_wtax_base :=pay_balance_pkg.get_value
1292: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1293: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1294: ,P_TAX_UNIT_ID =>g_legal_employer_id
1295: ,P_JURISDICTION_CODE =>NULL

Line 1313: l_ptp_2_wtax_base :=pay_balance_pkg.get_value

1309: ,P_SOURCE_NUMBER2 =>NULL
1310: ,P_ORGANIZATION_ID =>NULL
1311: ) ;
1312:
1313: l_ptp_2_wtax_base :=pay_balance_pkg.get_value
1314: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1315: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1316: ,P_TAX_UNIT_ID =>g_legal_employer_id
1317: ,P_JURISDICTION_CODE =>NULL

Line 1340: l_pt1_1_wtax_base :=pay_balance_pkg.get_value

1336: END IF;
1337:
1338: IF l_tax_card_type in ('EI', 'FT','S' ) AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base) <=0 THEN
1339: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 14');
1340: l_pt1_1_wtax_base :=pay_balance_pkg.get_value
1341: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1342: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1343: ,P_TAX_UNIT_ID =>g_legal_employer_id
1344: ,P_JURISDICTION_CODE =>NULL

Line 1362: l_pt1_2_wtax_base :=pay_balance_pkg.get_value

1358: ,P_SOURCE_NUMBER2 =>NULL
1359: ,P_ORGANIZATION_ID =>NULL
1360: ) ;
1361:
1362: l_pt1_2_wtax_base :=pay_balance_pkg.get_value
1363: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1364: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1365: ,P_TAX_UNIT_ID =>g_legal_employer_id
1366: ,P_JURISDICTION_CODE =>NULL

Line 1389: l_ptp2_1_wtax_base :=pay_balance_pkg.get_value

1385:
1386: IF l_tax_card_type in ('C','FT','EI','P', 'S' )
1387: AND (l_ptp_1_wtax_base + l_ptp_2_wtax_base + l_pt1_1_wtax_base + l_pt1_2_wtax_base ) <=0 THEN
1388: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 16');
1389: l_ptp2_1_wtax_base :=pay_balance_pkg.get_value
1390: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1391: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1392: ,P_TAX_UNIT_ID =>g_legal_employer_id
1393: ,P_JURISDICTION_CODE =>NULL

Line 1411: l_ptp2_2_wtax_base :=pay_balance_pkg.get_value

1407: ,P_SOURCE_NUMBER2 =>NULL
1408: ,P_ORGANIZATION_ID =>NULL
1409: ) ;
1410:
1411: l_ptp2_2_wtax_base :=pay_balance_pkg.get_value
1412: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1413: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1414: ,P_TAX_UNIT_ID =>g_legal_employer_id
1415: ,P_JURISDICTION_CODE =>NULL

Line 1440: l_pth_1_wtax_base :=pay_balance_pkg.get_value

1436:
1437: IF l_tax_card_type in ('EI', 'FT','S' )
1438: 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
1439: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 18');
1440: l_pth_1_wtax_base :=pay_balance_pkg.get_value
1441: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1442: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1443: ,P_TAX_UNIT_ID =>g_legal_employer_id
1444: ,P_JURISDICTION_CODE =>NULL

Line 1462: l_pth_2_wtax_base :=pay_balance_pkg.get_value

1458: ,P_SOURCE_NUMBER2 =>NULL
1459: ,P_ORGANIZATION_ID =>NULL
1460: ) ;
1461:
1462: l_pth_2_wtax_base :=pay_balance_pkg.get_value
1463: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1464: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1465: ,P_TAX_UNIT_ID =>g_legal_employer_id
1466: ,P_JURISDICTION_CODE =>NULL

Line 1491: l_pth2_1_wtax_base :=pay_balance_pkg.get_value

1487: IF l_tax_card_type in ('EI', 'FT','S' )
1488: 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
1489: + l_ptp2_2_wtax_base + l_pth_1_wtax_base + l_pth_2_wtax_base ) <=0 THEN
1490: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 20');
1491: l_pth2_1_wtax_base :=pay_balance_pkg.get_value
1492: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1493: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1494: ,P_TAX_UNIT_ID =>g_legal_employer_id
1495: ,P_JURISDICTION_CODE =>NULL

Line 1513: l_pth2_2_wtax_base :=pay_balance_pkg.get_value

1509: ,P_SOURCE_NUMBER2 =>NULL
1510: ,P_ORGANIZATION_ID =>NULL
1511: ) ;
1512:
1513: l_pth2_2_wtax_base :=pay_balance_pkg.get_value
1514: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
1515: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
1516: ,P_TAX_UNIT_ID =>g_legal_employer_id
1517: ,P_JURISDICTION_CODE =>NULL

Line 1603: 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 ) ;

1599: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX'||l_dimension1);
1600: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1601: CLOSE csr_Get_Defined_Balance_Id;
1602:
1603: 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 ) ;
1604:
1605: OPEN csr_Get_Defined_Balance_Id( 'PENSION'||l_dimension1);
1606: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1607: CLOSE csr_Get_Defined_Balance_Id;

Line 1609: 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 ) ;

1605: OPEN csr_Get_Defined_Balance_Id( 'PENSION'||l_dimension1);
1606: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1607: CLOSE csr_Get_Defined_Balance_Id;
1608:
1609: 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 ) ;
1610:
1611: OPEN csr_Get_Defined_Balance_Id( 'UNEMPLOYMENT_INSURANCE'||l_dimension1);
1612: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1613: CLOSE csr_Get_Defined_Balance_Id;

Line 1615: 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 ) ;

1611: OPEN csr_Get_Defined_Balance_Id( 'UNEMPLOYMENT_INSURANCE'||l_dimension1);
1612: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1613: CLOSE csr_Get_Defined_Balance_Id;
1614:
1615: 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 ) ;
1616:
1617: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_CAR_BENEFIT'||l_dimension1);
1618: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1619: CLOSE csr_Get_Defined_Balance_Id;

Line 1621: 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 ) ;

1617: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_CAR_BENEFIT'||l_dimension1);
1618: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1619: CLOSE csr_Get_Defined_Balance_Id;
1620:
1621: 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 ) ;
1622:
1623: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_VEHICLE_MILEAGE'||l_dimension1);
1624: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1625: CLOSE csr_Get_Defined_Balance_Id;

Line 1627: 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 ) ;

1623: OPEN csr_Get_Defined_Balance_Id( 'CUMULATIVE_VEHICLE_MILEAGE'||l_dimension1);
1624: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1625: CLOSE csr_Get_Defined_Balance_Id;
1626:
1627: 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 ) ;
1628:
1629: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 23');
1630: BEGIN
1631: FOR balance_rec IN csr_balance('Mortgage Benefit' , rg_csr_get_person_details.business_group_id)

Line 1637: 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 ) ;

1633: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1634: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1635: CLOSE csr_bg_Get_Defined_Balance_Id;
1636: IF csr_balance%FOUND THEN
1637: 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 ) ;
1638: l_tot_mortgage_bik := l_tot_mortgage_bik + l_mortgage_bik;
1639: END IF;
1640: END LOOP ;
1641:

Line 1659: 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 ) ;

1655: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1656: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1657: CLOSE csr_bg_Get_Defined_Balance_Id;
1658: IF csr_balance%FOUND THEN
1659: 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 ) ;
1660: l_tot_other_bik := l_tot_other_bik + l_other_bik;
1661: END IF;
1662: END LOOP ;
1663:

Line 1683: 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 ) ;

1679: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1680: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1681: CLOSE csr_bg_Get_Defined_Balance_Id;
1682: IF csr_balance%FOUND THEN
1683: 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 ) ;
1684: l_tot_housing_bik := l_tot_housing_bik + l_housing_bik;
1685: END IF;
1686: END LOOP ;
1687:

Line 1705: 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 ) ;

1701: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1702: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1703: CLOSE csr_bg_Get_Defined_Balance_Id;
1704: IF csr_balance%FOUND THEN
1705: 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 ) ;
1706: l_tot_phone_bik := l_tot_phone_bik + l_phone_bik;
1707: END IF;
1708: END LOOP ;
1709:

Line 1725: 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 ) ;

1721: OPEN csr_Get_Defined_Balance_Id('LUNCH_BENEFIT'||l_dimension1);
1722: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1723: CLOSE csr_Get_Defined_Balance_Id;
1724:
1725: 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 ) ;
1726:
1727: IF l_lunch_bik > 0 THEN
1728: l_lunch_bik_status := 1;
1729: ELSE

Line 1737: 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 ) ;

1733: OPEN csr_Get_Defined_Balance_Id( 'HALF_DAY_ALLOWANCE_EXPENSES'||l_dimension1);
1734: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1735: CLOSE csr_Get_Defined_Balance_Id;
1736:
1737: 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 ) ;
1738:
1739: IF l_half_day_allowance_expenses > 0 THEN
1740: l_half_day_allowance_status :=1;
1741: ELSE

Line 1750: 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 ) ;

1746: OPEN csr_Get_Defined_Balance_Id( 'DAILY_ALLOWANCE_DOMESTIC_EXPENSES'||l_dimension1);
1747: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1748: CLOSE csr_Get_Defined_Balance_Id;
1749:
1750: 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 ) ;
1751: IF l_daily_allowance_d_expenses > 0 THEN
1752: l_daily_allowance_d_status :=1;
1753: ELSE
1754: l_daily_allowance_d_status :=0;

Line 1762: 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 ) ;

1758: OPEN csr_Get_Defined_Balance_Id( 'DAILY_ALLOWANCE_FOREIGN_EXPENSES'||l_dimension1);
1759: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1760: CLOSE csr_Get_Defined_Balance_Id;
1761:
1762: 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 ) ;
1763: IF l_daily_allowance_fe_expenses > 0 THEN
1764: l_daily_allowance_fe_status :=1;
1765: ELSE
1766: l_daily_allowance_fe_status :=0;

Line 1774: 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 ) ;

1770: OPEN csr_Get_Defined_Balance_Id( 'MEAL_COMPENSATION_EXPENSES'||l_dimension1);
1771: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1772: CLOSE csr_Get_Defined_Balance_Id;
1773:
1774: 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 ) ;
1775:
1776: IF l_meal_comp_expenses > 0 THEN
1777: l_meal_comp_status :=1;
1778: ELSE

Line 1786: 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 ) ;

1782: OPEN csr_Get_Defined_Balance_Id( 'TAX_FREE_MILEAGE_EXPENSES'||l_dimension1);
1783: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1784: CLOSE csr_Get_Defined_Balance_Id;
1785:
1786: 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 ) ;
1787:
1788:
1789: OPEN csr_Get_Defined_Balance_Id( 'TAX_FREE_MILEAGE'||l_dimension1);
1790: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1793: 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 ) ;

1789: OPEN csr_Get_Defined_Balance_Id( 'TAX_FREE_MILEAGE'||l_dimension1);
1790: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1791: CLOSE csr_Get_Defined_Balance_Id;
1792:
1793: 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 ) ;
1794:
1795: BEGIN
1796: FOR balance_rec IN csr_balance('Stock Options Benefit' , rg_csr_get_person_details.business_group_id)
1797: LOOP

Line 1802: 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 ) ;

1798: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1799: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1800: CLOSE csr_bg_Get_Defined_Balance_Id;
1801: IF csr_balance%FOUND THEN
1802: 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 ) ;
1803: l_tot_stock_option_bik := l_tot_stock_option_bik + l_stock_option_bik;
1804: END IF;
1805: END LOOP ;
1806: EXCEPTION

Line 1815: 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 ) ;

1811: OPEN csr_Get_Defined_Balance_Id( 'EMPLOYER_PENSION'||l_dimension1);
1812: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1813: CLOSE csr_Get_Defined_Balance_Id;
1814:
1815: 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 ) ;
1816:
1817: BEGIN
1818: FOR balance_rec IN csr_balance('Travel Ticket Benefit' , rg_csr_get_person_details.business_group_id)
1819: LOOP

Line 1824: 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 ) ;

1820: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1821: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1822: CLOSE csr_bg_Get_Defined_Balance_Id;
1823: IF csr_balance%FOUND THEN
1824: 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 ) ;
1825: l_tot_travel_ticket_bik := l_tot_travel_ticket_bik + l_travel_ticket_bik;
1826: END IF;
1827: END LOOP ;
1828:

Line 1847: 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 ) ;

1843: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1844: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1845: CLOSE csr_bg_Get_Defined_Balance_Id;
1846: IF csr_balance%FOUND THEN
1847: 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 ) ;
1848: l_tot_other_bik_ded := l_tot_other_bik_ded + l_other_bik_ded;
1849: END IF;
1850: END LOOP ;
1851:

Line 1865: 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 ) ;

1861: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1862: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1863: CLOSE csr_bg_Get_Defined_Balance_Id;
1864: IF csr_balance%FOUND THEN
1865: 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 ) ;
1866: l_tot_car_bik_ded := l_tot_car_bik_ded + l_car_bik_ded;
1867: END IF;
1868: END LOOP ;
1869:

Line 1882: 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 ) ;

1878: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1879: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1880: CLOSE csr_bg_Get_Defined_Balance_Id;
1881: IF csr_balance%FOUND THEN
1882: 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 ) ;
1883: l_tot_lunch_bik_ded := l_tot_lunch_bik_ded + l_lunch_bik_ded;
1884: END IF;
1885: END LOOP ;
1886:

Line 1901: 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 ) ;

1897: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_COMPENSATION'||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_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 ) ;
1902:
1903: BEGIN
1904: FOR balance_rec IN csr_balance('Payments for Elected Official' , rg_csr_get_person_details.business_group_id)
1905: LOOP

Line 1910: 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 ) ;

1906: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1907: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1908: CLOSE csr_bg_Get_Defined_Balance_Id;
1909: IF csr_balance%FOUND THEN
1910: 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 ) ;
1911: l_tot_pay_eoff := l_tot_pay_eoff + l_pay_eoff;
1912: END IF;
1913: END LOOP ;
1914: EXCEPTION

Line 1927: 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 ) ;

1923: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1924: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1925: CLOSE csr_bg_Get_Defined_Balance_Id;
1926: IF csr_balance%FOUND THEN
1927: 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 ) ;
1928: l_tot_vol_pi := l_tot_vol_pi + l_vol_pi;
1929: END IF;
1930: END LOOP ;
1931: EXCEPTION

Line 1943: 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 ) ;

1939: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1940: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1941: CLOSE csr_bg_Get_Defined_Balance_Id;
1942: IF csr_balance%FOUND THEN
1943: 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 ) ;
1944: l_tot_total_vol_pi := l_tot_total_vol_pi + l_total_vol_pi;
1945: END IF;
1946: END LOOP ;
1947: EXCEPTION

Line 1956: 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 ) ;

1952:
1953: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES'||l_dimension1);
1954: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1955: CLOSE csr_Get_Defined_Balance_Id;
1956: 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 ) ;
1957:
1958: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
1959: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1960: CLOSE csr_Get_Defined_Balance_Id;

Line 1961: 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 ) ;

1957:
1958: OPEN csr_Get_Defined_Balance_Id( 'TAXABLE_EXPENSES_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
1959: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1960: CLOSE csr_Get_Defined_Balance_Id;
1961: 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 ) ;
1962: l_te_exem_ss :=l_te - l_te_ss;
1963:
1964: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
1965: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1968: 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 ) ;

1964: OPEN csr_Get_Defined_Balance_Id( 'BIK_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
1965: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1966: CLOSE csr_Get_Defined_Balance_Id;
1967:
1968: 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 ) ;
1969: l_bik_exem_ss :=l_bik - l_bik_ss;
1970:
1971: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
1972: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 1975: 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 ) ;

1971: OPEN csr_Get_Defined_Balance_Id( 'SALARY_SUBJECT_TO_SOCIAL_SECURITY'||l_dimension1);
1972: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1973: CLOSE csr_Get_Defined_Balance_Id;
1974:
1975: 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 ) ;
1976: l_sm_exem_ss := l_salary_income - l_sm_ss;
1977:
1978: l_tot_exem_ss := l_te_exem_ss + l_bik_exem_ss + l_sm_exem_ss;
1979:

Line 1984: 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 ) ;

1980: OPEN csr_Get_Defined_Balance_Id( 'EXEMPTED_SOCIAL_SECURITY'||l_dimension1);
1981: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
1982: CLOSE csr_Get_Defined_Balance_Id;
1983:
1984: 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 ) ;
1985:
1986: BEGIN
1987: FOR balance_rec IN csr_balance('Social Security Fee Deductions' , rg_csr_get_person_details.business_group_id)
1988: LOOP

Line 1993: 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 ) ;

1989: OPEN csr_bg_Get_Defined_Balance_Id( balance_rec.balance_name||l_dimension1,rg_csr_get_person_details.business_group_id);
1990: FETCH csr_bg_Get_Defined_Balance_Id INTO rg_csr_bg_get_defined_bal_id;
1991: CLOSE csr_bg_Get_Defined_Balance_Id;
1992: IF csr_balance%FOUND THEN
1993: 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 ) ;
1994: l_tot_ss_ded := l_tot_ss_ded + l_ss_ded;
1995: END IF;
1996: END LOOP ;
1997: EXCEPTION

Line 2017: l_pta1_1_tstax_base :=pay_balance_pkg.get_value

2013: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE_BASE'||l_dimension);
2014: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2015: CLOSE csr_Get_Defined_Balance_Id;
2016:
2017: l_pta1_1_tstax_base :=pay_balance_pkg.get_value
2018: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2019: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2020: ,P_TAX_UNIT_ID =>g_legal_employer_id
2021: ,P_JURISDICTION_CODE =>NULL

Line 2040: l_pta1_2_tstax_base :=pay_balance_pkg.get_value

2036: ,P_ORGANIZATION_ID =>NULL
2037: ) ;
2038:
2039: IF l_pta1_1_tstax_base <= 0 THEN
2040: l_pta1_2_tstax_base :=pay_balance_pkg.get_value
2041: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2042: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2043: ,P_TAX_UNIT_ID =>g_legal_employer_id
2044: ,P_JURISDICTION_CODE =>NULL

Line 2068: l_pta4_1_tstax_base :=pay_balance_pkg.get_value

2064:
2065: l_pta2_2_tstax_base :=l_pta1_2_tstax_base;
2066:
2067: IF (l_pta1_1_tstax_base + l_pta1_2_tstax_base + l_pta2_1_tstax_base + l_pta2_2_tstax_base ) <= 0 THEN
2068: l_pta4_1_tstax_base :=pay_balance_pkg.get_value
2069: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2070: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2071: ,P_TAX_UNIT_ID =>g_legal_employer_id
2072: ,P_JURISDICTION_CODE =>NULL

Line 2092: l_pta5_1_tstax_base :=pay_balance_pkg.get_value

2088: ) ;
2089: END IF;
2090:
2091: 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
2092: l_pta5_1_tstax_base :=pay_balance_pkg.get_value
2093: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2094: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2095: ,P_TAX_UNIT_ID =>g_legal_employer_id
2096: ,P_JURISDICTION_CODE =>NULL

Line 2116: l_pta6_1_tstax_base :=pay_balance_pkg.get_value

2112: ) ;
2113: END IF;
2114:
2115: 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
2116: l_pta6_1_tstax_base :=pay_balance_pkg.get_value
2117: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2118: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2119: ,P_TAX_UNIT_ID =>g_legal_employer_id
2120: ,P_JURISDICTION_CODE =>NULL

Line 2140: l_pta7_1_tstax_base :=pay_balance_pkg.get_value

2136: ) ;
2137: END IF;
2138:
2139: 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
2140: l_pta7_1_tstax_base :=pay_balance_pkg.get_value
2141: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2142: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2143: ,P_TAX_UNIT_ID =>g_legal_employer_id
2144: ,P_JURISDICTION_CODE =>NULL

Line 2224: 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 ) ;

2220: OPEN csr_Get_Defined_Balance_Id( 'TAX_AT_SOURCE'||l_dimension1);
2221: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2222: CLOSE csr_Get_Defined_Balance_Id;
2223:
2224: 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 ) ;
2225:
2226:
2227: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY'||l_dimension1);
2228: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 2231: 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 ) ;

2227: OPEN csr_Get_Defined_Balance_Id( 'SOCIAL_SECURITY'||l_dimension1);
2228: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2229: CLOSE csr_Get_Defined_Balance_Id;
2230:
2231: 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 ) ;
2232:
2233: /* Cursor to fetch country code against which Tax Agreement is present*/
2234: OPEN csr_country( rg_csr_get_person_details.place_residence);
2235: FETCH csr_country INTO rg_csr_country;

Line 2267: l_pt5_1_wtax_base :=pay_balance_pkg.get_value

2263: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension);
2264: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2265: CLOSE csr_Get_Defined_Balance_Id;
2266:
2267: l_pt5_1_wtax_base :=pay_balance_pkg.get_value
2268: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2269: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2270: ,P_TAX_UNIT_ID =>g_legal_employer_id
2271: ,P_JURISDICTION_CODE =>NULL

Line 2288: l_pt5_2_wtax_base :=pay_balance_pkg.get_value

2284: ,P_LOCAL_UNIT_ID =>g_local_unit_id
2285: ,P_SOURCE_NUMBER2 =>NULL
2286: ,P_ORGANIZATION_ID =>NULL
2287: ) ;
2288: l_pt5_2_wtax_base :=pay_balance_pkg.get_value
2289: (P_DEFINED_BALANCE_ID =>rg_csr_get_defined_balance_id.creator_id
2290: ,P_ASSIGNMENT_ACTION_ID =>l_assignment_action_id
2291: ,P_TAX_UNIT_ID =>g_legal_employer_id
2292: ,P_JURISDICTION_CODE =>NULL

Line 2325: 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 ) ;

2321:
2322: OPEN csr_Get_Defined_Balance_Id( 'NOTIONAL_SALARY'||l_dimension1);
2323: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2324: CLOSE csr_Get_Defined_Balance_Id;
2325: 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 ) ;
2326: l_tax := 0;
2327: l_mtax_base := l_tax_base ;
2328: l_mtax := l_tax;
2329:

Line 2340: 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 ) ;

2336: OPEN csr_Get_Defined_Balance_Id( 'OTHER_PAYMENTS_SUBJECT_TO_TAX'||l_dimension1);
2337: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2338: CLOSE csr_Get_Defined_Balance_Id;
2339:
2340: 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 ) ;
2341:
2342: OPEN csr_Get_Defined_Balance_Id( 'COMPENSATION_FOR_USE_OF_ITEM'||l_dimension1);
2343: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2344: CLOSE csr_Get_Defined_Balance_Id;

Line 2346: 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 ) ;

2342: OPEN csr_Get_Defined_Balance_Id( 'COMPENSATION_FOR_USE_OF_ITEM'||l_dimension1);
2343: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2344: CLOSE csr_Get_Defined_Balance_Id;
2345:
2346: 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 ) ;
2347:
2348: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 32');
2349:
2350: IF l_tax_card_type <>'TS' THEN

Line 2357: 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 ) ;

2353: OPEN csr_Get_Defined_Balance_Id( 'CAPITAL_INCOME_BASE'||l_dimension1);
2354: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2355: CLOSE csr_Get_Defined_Balance_Id;
2356:
2357: 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 ) ;
2358:
2359: OPEN csr_Get_Defined_Balance_Id( 'CAPITAL_INCOME_TAX'||l_dimension1);
2360: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2361: CLOSE csr_Get_Defined_Balance_Id;

Line 2363: 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 ) ;

2359: OPEN csr_Get_Defined_Balance_Id( 'CAPITAL_INCOME_TAX'||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_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 ) ;
2364:
2365:
2366: END IF;
2367:

Line 2398: 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 ) ;

2394: OPEN csr_Get_Defined_Balance_Id( 'DEDUCTIONS_BEFORE_TAX'||l_dimension1);
2395: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2396: CLOSE csr_Get_Defined_Balance_Id;
2397:
2398: 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 ) ;
2399:
2400: OPEN csr_Get_Defined_Balance_Id( 'EXTERNAL_EXPENSES'||l_dimension1);
2401: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2402: CLOSE csr_Get_Defined_Balance_Id;

Line 2404: 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 ) ;

2400: OPEN csr_Get_Defined_Balance_Id( 'EXTERNAL_EXPENSES'||l_dimension1);
2401: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2402: CLOSE csr_Get_Defined_Balance_Id;
2403:
2404: 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 ) ;
2405: fnd_file.put_line(fnd_file.log,'ARCHIVE CODE 35');
2406: END IF;
2407:
2408: IF l_payment_type IS NOT NULL THEN

Line 2436: 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) ;

2432:
2433: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX'||l_dimension2);
2434: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2435: CLOSE csr_Get_Defined_Balance_Id;
2436: 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) ;
2437:
2438:
2439: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension2);
2440: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;

Line 2442: 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) ;

2438:
2439: OPEN csr_Get_Defined_Balance_Id( 'WITHHOLDING_TAX_BASE'||l_dimension2);
2440: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2441: CLOSE csr_Get_Defined_Balance_Id;
2442: 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) ;
2443:
2444: pay_action_information_api.create_action_information (
2445: p_action_information_id=> l_action_info_id,
2446: p_action_context_id=> p_assignment_action_id,

Line 2865: 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) ;

2861: OPEN csr_Get_Defined_Balance_Id( 'PART_TIME_PENSIONER_AMOUNT'||l_dimension2);
2862: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2863: CLOSE csr_Get_Defined_Balance_Id;
2864:
2865: 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) ;
2866:
2867: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension2);
2868: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2869: CLOSE csr_Get_Defined_Balance_Id;

Line 2870: 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) ;

2866:
2867: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_FOR_LOW_PAID_EMPLOYEES'||l_dimension2);
2868: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2869: CLOSE csr_Get_Defined_Balance_Id;
2870: 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) ;
2871:
2872:
2873: IF l_subsidy_amt > 0 THEN
2874:

Line 2878: 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) ;

2874:
2875: OPEN csr_Get_Defined_Balance_Id( 'SUBSIDY_BASIS'||l_dimension2);
2876: FETCH csr_Get_Defined_Balance_Id INTO rg_csr_get_defined_balance_id;
2877: CLOSE csr_Get_Defined_Balance_Id;
2878: 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) ;
2879:
2880:
2881: IF l_pt_pension_amt > 0 THEN
2882: CODE_015:= l_subsidy_basis;