APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_BALANCE_PKG

Line 1381: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

1377: end if;
1378: -- FOR csr_person IN csr_person_local_unit(g_business_group_id, g_local_unit_id, g_end_date /*g_effective_date*/) LOOP
1379: --l_person_id:=csr_person.person_id;
1380: --fnd_file.put_line(fnd_file.LOG,'l_person_id'||l_person_id);
1381: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1382: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id); --3621);
1383: FOR csr_assignment IN csr_wage_assignment(g_business_group_id, g_local_unit_id, g_end_date) LOOP
1384: l_assignment_id:=csr_assignment.assignment_id;
1385: l_working_percentage:=csr_assignment.working_percentage;

Line 1382: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id); --3621);

1378: -- FOR csr_person IN csr_person_local_unit(g_business_group_id, g_local_unit_id, g_end_date /*g_effective_date*/) LOOP
1379: --l_person_id:=csr_person.person_id;
1380: --fnd_file.put_line(fnd_file.LOG,'l_person_id'||l_person_id);
1381: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
1382: pay_balance_pkg.set_context('LOCAL_UNIT_ID',g_local_unit_id); --3621);
1383: FOR csr_assignment IN csr_wage_assignment(g_business_group_id, g_local_unit_id, g_end_date) LOOP
1384: l_assignment_id:=csr_assignment.assignment_id;
1385: l_working_percentage:=csr_assignment.working_percentage;
1386: l_asg_hour_sal:=csr_assignment.hourly_salaried_code;

Line 1460: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1456: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1457: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1458: CLOSE csr_get_defined_balance;
1459:
1460: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1461: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1462: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
1463: END IF;
1464: IF l_period='Week' THEN

Line 1497: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1493: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1494: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1495: CLOSE csr_get_defined_balance;
1496:
1497: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1498: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1499: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
1500: END IF;
1501: IF l_period='Week' THEN

Line 1533: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1529: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1530: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1531: CLOSE csr_get_defined_balance;
1532:
1533: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1534: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1535: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
1536: END IF;
1537: IF l_period='Week' THEN

Line 1569: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1565: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1566: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1567: CLOSE csr_get_defined_balance;
1568:
1569: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1570: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1571: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
1572: END IF;
1573: IF l_period='Week' THEN

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

1581: l_type:=NULL;
1582: END IF;
1583: END LOOP;
1584: /*Retroactive payment _ASG_LU_PTD */
1585: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1586: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_PTD');
1587: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1588: CLOSE csr_Get_Defined_Balance_Id;
1589: l_value:=nvl(pay_balance_pkg.get_value

Line 1589: l_value:=nvl(pay_balance_pkg.get_value

1585: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1586: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_PTD');
1587: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1588: CLOSE csr_Get_Defined_Balance_Id;
1589: l_value:=nvl(pay_balance_pkg.get_value
1590: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1591: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
1592: P_VIRTUAL_DATE =>l_period_end-- '31-jan-2000'
1593: ),0);

Line 1624: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1620: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1621: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1622: CLOSE csr_get_defined_balance;
1623:
1624: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1625: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1626: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
1627: END IF;
1628: IF l_period='Week' THEN

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

1637: END IF;
1638: END LOOP;
1639:
1640: /*Total Sick Pay _ASG_LU_PTD */
1641: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1642: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_PTD');
1643: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1644: CLOSE csr_Get_Defined_Balance_Id;
1645: l_value:=nvl(pay_balance_pkg.get_value

Line 1645: l_value:=nvl(pay_balance_pkg.get_value

1641: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1642: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_PTD');
1643: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1644: CLOSE csr_Get_Defined_Balance_Id;
1645: l_value:=nvl(pay_balance_pkg.get_value
1646: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1647: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
1648: P_VIRTUAL_DATE =>l_period_end-- '31-jan-2000'
1649: ),0);

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

1662:
1663: /* Blue Collar Salaried Employee */
1664: ELSIF l_employee_category='BC' AND l_asg_hour_sal='S' THEN
1665: /*Gross Pay _ASG_LU_MONTH */
1666: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1667: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
1668: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1669: CLOSE csr_Get_Defined_Balance_Id;
1670: l_value:=nvl(pay_balance_pkg.get_value

Line 1670: l_value:=nvl(pay_balance_pkg.get_value

1666: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1667: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
1668: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1669: CLOSE csr_Get_Defined_Balance_Id;
1670: l_value:=nvl(pay_balance_pkg.get_value
1671: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1672: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
1673: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
1674: ),0);

Line 1707: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1703: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1704: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1705: CLOSE csr_get_defined_balance;
1706:
1707: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1708: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1709: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1710: END IF;
1711: --l_bs_tcdp_value:=l_value;

Line 1738: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1734: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1735: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1736: CLOSE csr_get_defined_balance;
1737:
1738: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1739: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1740: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1741: END IF;
1742: --l_bs_tcow_value:=l_value;

Line 1766: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1762: ELSE
1763: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1764: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1765: CLOSE csr_get_defined_balance;
1766: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1767: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1768: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1769: END IF;
1770: --l_bs_nha_value:=l_value;

Line 1795: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1791: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1792: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1793: CLOSE csr_get_defined_balance;
1794:
1795: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1796: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1797: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1798: END IF;
1799: --l_bs_nho_value:=l_value;

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

1804:
1805: END IF;
1806: END LOOP;
1807: /*Retroactive payment _ASG_LU_MONTH */
1808: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1809: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
1810: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1811: CLOSE csr_Get_Defined_Balance_Id;
1812: l_value:=nvl(pay_balance_pkg.get_value

Line 1812: l_value:=nvl(pay_balance_pkg.get_value

1808: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1809: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
1810: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1811: CLOSE csr_Get_Defined_Balance_Id;
1812: l_value:=nvl(pay_balance_pkg.get_value
1813: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1814: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
1815: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
1816: ),0);

Line 1841: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1837: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1838: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1839: CLOSE csr_get_defined_balance;
1840:
1841: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1842: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1843: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1844: END IF;
1845: --l_bs_ppo_value:=l_value;

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

1848: l_type:=NULL;
1849: END IF;
1850: END LOOP;
1851: /*Total Sick Pay _ASG_LU_MONTH */
1852: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1853: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
1854: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1855: CLOSE csr_Get_Defined_Balance_Id;
1856: l_value:=nvl(pay_balance_pkg.get_value

Line 1856: l_value:=nvl(pay_balance_pkg.get_value

1852: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1853: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
1854: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1855: CLOSE csr_Get_Defined_Balance_Id;
1856: l_value:=nvl(pay_balance_pkg.get_value
1857: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1858: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
1859: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
1860: ),0);

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

1873: l_ws_full_time_employee:=l_ws_full_time_employee+round(nvl(l_working_percentage,100)/100,2);
1874: --END IF;
1875:
1876: /*Gross Pay _ASG_LU_MONTH */
1877: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1878: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
1879: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1880: CLOSE csr_Get_Defined_Balance_Id;
1881: l_value:=nvl(pay_balance_pkg.get_value

Line 1881: l_value:=nvl(pay_balance_pkg.get_value

1877: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
1878: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
1879: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
1880: CLOSE csr_Get_Defined_Balance_Id;
1881: l_value:=nvl(pay_balance_pkg.get_value
1882: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1883: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
1884: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
1885: ),0);

Line 1918: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1914: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1915: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1916: CLOSE csr_get_defined_balance;
1917:
1918: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1919: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1920: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1921: END IF;
1922: --l_ws_tcdp_value:=l_value;

Line 1949: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1945: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1946: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1947: CLOSE csr_get_defined_balance;
1948:
1949: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1950: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1951: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1952: END IF;
1953: --l_ws_tcow_value:=l_value;

Line 1980: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

1976: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
1977: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
1978: CLOSE csr_get_defined_balance;
1979:
1980: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
1981: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
1982: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
1983: END IF;
1984: --l_ws_nha_value:=l_value;

Line 2011: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2007: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2008: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2009: CLOSE csr_get_defined_balance;
2010:
2011: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2012: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2013: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2014: END IF;
2015: --l_ws_nho_value:=l_value;

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

2018: l_type:=NULL;
2019: END IF;
2020: END LOOP;
2021: /*Retroactive payment _ASG_LU_MONTH */
2022: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2023: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
2024: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2025: CLOSE csr_Get_Defined_Balance_Id;
2026: l_value:=nvl(pay_balance_pkg.get_value

Line 2026: l_value:=nvl(pay_balance_pkg.get_value

2022: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2023: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
2024: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2025: CLOSE csr_Get_Defined_Balance_Id;
2026: l_value:=nvl(pay_balance_pkg.get_value
2027: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2028: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2029: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
2030: ),0);

Line 2057: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2053: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2054: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2055: CLOSE csr_get_defined_balance;
2056:
2057: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2058: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2059: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2060: --l_ws_ppo_value:=l_value;
2061: l_ws_ppo_value:=l_ws_ppo_value+round(nvl(l_value,0));

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

2064: END IF;
2065: END IF;
2066: END LOOP;
2067: /*Total Sick Pay _ASG_LU_MONTH */
2068: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2069: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
2070: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2071: CLOSE csr_Get_Defined_Balance_Id;
2072: l_value:=nvl(pay_balance_pkg.get_value

Line 2072: l_value:=nvl(pay_balance_pkg.get_value

2068: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2069: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
2070: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2071: CLOSE csr_Get_Defined_Balance_Id;
2072: l_value:=nvl(pay_balance_pkg.get_value
2073: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2074: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2075: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
2076: ),0);

Line 2312: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);

2308: end if;
2309: -- FOR csr_person IN csr_person_local_unit(g_business_group_id, g_local_unit_id, g_end_date /*g_effective_date*/) LOOP
2310: --l_person_id:=csr_person.person_id;
2311: --fnd_file.put_line(fnd_file.LOG,'l_person_id'||l_person_id);
2312: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
2313: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
2314: FOR csr_assignment IN csr_wage_assignment(g_business_group_id, l_local_unit_id, g_end_date) LOOP
2315: l_assignment_id:=csr_assignment.assignment_id;
2316: l_working_percentage:=csr_assignment.working_percentage;

Line 2313: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);

2309: -- FOR csr_person IN csr_person_local_unit(g_business_group_id, g_local_unit_id, g_end_date /*g_effective_date*/) LOOP
2310: --l_person_id:=csr_person.person_id;
2311: --fnd_file.put_line(fnd_file.LOG,'l_person_id'||l_person_id);
2312: pay_balance_pkg.set_context('ASSIGNMENT_ID',l_assignment_id); --133942);
2313: pay_balance_pkg.set_context('LOCAL_UNIT_ID',l_local_unit_id); --3621);
2314: FOR csr_assignment IN csr_wage_assignment(g_business_group_id, l_local_unit_id, g_end_date) LOOP
2315: l_assignment_id:=csr_assignment.assignment_id;
2316: l_working_percentage:=csr_assignment.working_percentage;
2317: l_asg_hour_sal:=csr_assignment.hourly_salaried_code;

Line 2391: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2387: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2388: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2389: CLOSE csr_get_defined_balance;
2390:
2391: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2392: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2393: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
2394: END IF;
2395: IF l_period='Week' THEN

Line 2428: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2424: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2425: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2426: CLOSE csr_get_defined_balance;
2427:
2428: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2429: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2430: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
2431: END IF;
2432: IF l_period='Week' THEN

Line 2464: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2460: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2461: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2462: CLOSE csr_get_defined_balance;
2463:
2464: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2465: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2466: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
2467: END IF;
2468: IF l_period='Week' THEN

Line 2500: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2496: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2497: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2498: CLOSE csr_get_defined_balance;
2499:
2500: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2501: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2502: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
2503: END IF;
2504: IF l_period='Week' THEN

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

2512: l_type:=NULL;
2513: END IF;
2514: END LOOP;
2515: /*Retroactive payment _ASG_LU_PTD */
2516: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2517: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_PTD');
2518: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2519: CLOSE csr_Get_Defined_Balance_Id;
2520: l_value:=nvl(pay_balance_pkg.get_value

Line 2520: l_value:=nvl(pay_balance_pkg.get_value

2516: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2517: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_PTD');
2518: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2519: CLOSE csr_Get_Defined_Balance_Id;
2520: l_value:=nvl(pay_balance_pkg.get_value
2521: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2522: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2523: P_VIRTUAL_DATE =>l_period_end-- '31-jan-2000'
2524: ),0);

Line 2555: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2551: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2552: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2553: CLOSE csr_get_defined_balance;
2554:
2555: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2556: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2557: P_VIRTUAL_DATE=>l_period_end/*TO_DATE('31-jan-2001')*/),0);
2558: END IF;
2559: IF l_period='Week' THEN

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

2568: END IF;
2569: END LOOP;
2570:
2571: /*Total Sick Pay _ASG_LU_PTD */
2572: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2573: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_PTD');
2574: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2575: CLOSE csr_Get_Defined_Balance_Id;
2576: l_value:=nvl(pay_balance_pkg.get_value

Line 2576: l_value:=nvl(pay_balance_pkg.get_value

2572: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
2573: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_PTD');
2574: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2575: CLOSE csr_Get_Defined_Balance_Id;
2576: l_value:=nvl(pay_balance_pkg.get_value
2577: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2578: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2579: P_VIRTUAL_DATE =>l_period_end-- '31-jan-2000'
2580: ),0);

Line 2597: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);

2593:
2594: /* Blue Collar Salaried Employee */
2595: ELSIF l_employee_category='BC' AND l_asg_hour_sal='S' THEN
2596: /*Gross Pay _ASG_LU_MONTH */
2597: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2598: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
2599: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2600: CLOSE csr_Get_Defined_Balance_Id;
2601: l_value:=nvl(pay_balance_pkg.get_value

Line 2601: l_value:=nvl(pay_balance_pkg.get_value

2597: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2598: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
2599: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2600: CLOSE csr_Get_Defined_Balance_Id;
2601: l_value:=nvl(pay_balance_pkg.get_value
2602: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2603: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2604: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
2605: ),0);

Line 2636: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2632: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2633: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2634: CLOSE csr_get_defined_balance;
2635:
2636: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2637: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2638: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2639: END IF;
2640: --l_bs_tcdp_value:=l_value;

Line 2667: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2663: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2664: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2665: CLOSE csr_get_defined_balance;
2666:
2667: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2668: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2669: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2670: END IF;
2671: --l_bs_tcow_value:=l_value;

Line 2695: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2691: ELSE
2692: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2693: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2694: CLOSE csr_get_defined_balance;
2695: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2696: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2697: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2698: END IF;
2699: --l_bs_nha_value:=l_value;

Line 2724: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2720: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2721: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2722: CLOSE csr_get_defined_balance;
2723:
2724: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2725: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2726: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2727: --l_bs_nho_value:=l_value;
2728: l_bs_nho_value:=l_bs_nho_value+round(nvl(l_value,0));

Line 2736: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);

2732: END IF;
2733: END IF;
2734: END LOOP;
2735: /*Retroactive payment _ASG_LU_MONTH */
2736: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2737: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
2738: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2739: CLOSE csr_Get_Defined_Balance_Id;
2740: l_value:=nvl(pay_balance_pkg.get_value

Line 2740: l_value:=nvl(pay_balance_pkg.get_value

2736: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2737: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
2738: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2739: CLOSE csr_Get_Defined_Balance_Id;
2740: l_value:=nvl(pay_balance_pkg.get_value
2741: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2742: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2743: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
2744: ),0);

Line 2770: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2766: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2767: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2768: CLOSE csr_get_defined_balance;
2769:
2770: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2771: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2772: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2773: END IF;
2774: --l_bs_ppo_value:=l_value;

Line 2781: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);

2777: l_type:=NULL;
2778: END IF;
2779: END LOOP;
2780: /*Total Sick Pay _ASG_LU_MONTH */
2781: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2782: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
2783: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2784: CLOSE csr_Get_Defined_Balance_Id;
2785: l_value:=nvl(pay_balance_pkg.get_value

Line 2785: l_value:=nvl(pay_balance_pkg.get_value

2781: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2782: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
2783: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2784: CLOSE csr_Get_Defined_Balance_Id;
2785: l_value:=nvl(pay_balance_pkg.get_value
2786: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2787: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2788: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
2789: ),0);

Line 2806: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);

2802: --l_ws_full_time_employee:=l_ws_full_time_employee+round(nvl(l_working_percentage,100)* nvl(l_normal_hours,0)/100,2);
2803: --END IF;
2804:
2805: /*Gross Pay _ASG_LU_MONTH */
2806: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2807: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
2808: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2809: CLOSE csr_Get_Defined_Balance_Id;
2810: l_value:=nvl(pay_balance_pkg.get_value

Line 2810: l_value:=nvl(pay_balance_pkg.get_value

2806: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2807: OPEN csr_Get_Defined_Balance_Id( 'GROSS_PAY_ASG_LU_MONTH');
2808: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2809: CLOSE csr_Get_Defined_Balance_Id;
2810: l_value:=nvl(pay_balance_pkg.get_value
2811: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2812: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2813: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
2814: ),0);

Line 2849: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2845: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2846: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2847: CLOSE csr_get_defined_balance;
2848:
2849: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2850: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2851: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2852: END IF;
2853: --l_ws_tcdp_value:=l_value;

Line 2880: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2876: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2877: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2878: CLOSE csr_get_defined_balance;
2879:
2880: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2881: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2882: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2883: END IF;
2884: --l_ws_tcow_value:=l_value;

Line 2911: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2907: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2908: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2909: CLOSE csr_get_defined_balance;
2910:
2911: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2912: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2913: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2914: END IF;
2915: --l_ws_nha_value:=l_value;

Line 2942: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2938: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2939: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2940: CLOSE csr_get_defined_balance;
2941:
2942: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2943: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2944: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2945: END IF;
2946: --l_ws_nho_value:=l_value;

Line 2953: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);

2949: l_type:=NULL;
2950: END IF;
2951: END LOOP;
2952: /*Retroactive payment _ASG_LU_MONTH */
2953: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2954: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
2955: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2956: CLOSE csr_Get_Defined_Balance_Id;
2957: l_value:=nvl(pay_balance_pkg.get_value

Line 2957: l_value:=nvl(pay_balance_pkg.get_value

2953: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',l_local_unit_id);
2954: OPEN csr_Get_Defined_Balance_Id( 'RETROSPECTIVE_PAYMENTS_ASG_LU_MONTH');
2955: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
2956: CLOSE csr_Get_Defined_Balance_Id;
2957: l_value:=nvl(pay_balance_pkg.get_value
2958: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2959: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
2960: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
2961: ),0);

Line 2988: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,

2984: OPEN csr_get_defined_balance(l_balance_type_id, l_balance_dimension_id);
2985: FETCH csr_get_defined_balance INTO lr_Get_Defined_Balance_Id;
2986: CLOSE csr_get_defined_balance;
2987:
2988: l_value:=nvl(pay_balance_pkg.get_value(P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
2989: P_ASSIGNMENT_ID =>l_assignment_id, --21348,
2990: P_VIRTUAL_DATE=>g_end_date/*TO_DATE('31-jan-2001')*/),0);
2991: --l_ws_ppo_value:=l_value;
2992: l_ws_ppo_value:=l_ws_ppo_value+round(nvl(l_value,0));

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

2995: END IF;
2996: END IF;
2997: END LOOP;
2998: /*Total Sick Pay _ASG_LU_MONTH */
2999: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
3000: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
3001: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
3002: CLOSE csr_Get_Defined_Balance_Id;
3003: l_value:=nvl(pay_balance_pkg.get_value

Line 3003: l_value:=nvl(pay_balance_pkg.get_value

2999: pay_balance_pkg.set_context ('LOCAL_UNIT_ID',g_local_unit_id);
3000: OPEN csr_Get_Defined_Balance_Id( 'TOTAL_SICK_PAY_ASG_LU_MONTH');
3001: FETCH csr_Get_Defined_Balance_Id INTO lr_Get_Defined_Balance_Id;
3002: CLOSE csr_Get_Defined_Balance_Id;
3003: l_value:=nvl(pay_balance_pkg.get_value
3004: (P_DEFINED_BALANCE_ID =>lr_Get_Defined_Balance_Id,
3005: P_ASSIGNMENT_ID =>l_assignment_id, --32488,
3006: P_VIRTUAL_DATE =>g_end_date-- '31-jan-2000'
3007: ),0);

Line 3417: (pay_balance_pkg.get_value

3413: CLOSE csr_def_bal_id;
3414:
3415: l_return_balance_value :=
3416: TO_CHAR
3417: (pay_balance_pkg.get_value
3418: (p_defined_balance_id => l_defined_balance_id
3419: , p_assignment_id => p_in_assignment_id
3420: , p_virtual_date => p_in_virtual_date
3421: )