APPS.PAY_SE_WAGES_SALARIES dependencies on PAY_BALANCE_PKG

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 1590: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

Line 1646: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

Line 1671: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

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

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

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

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

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

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

Line 1813: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

Line 1857: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

Line 1882: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

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

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

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

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

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

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

Line 2027: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

Line 2073: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2521: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

Line 2577: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

Line 2602: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

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

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

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

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

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

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

Line 2741: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

Line 2786: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

Line 2811: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

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

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

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

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

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

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

Line 2958: l_value:=nvl(pay_balance_pkg.get_value

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

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

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

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

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

Line 3004: l_value:=nvl(pay_balance_pkg.get_value

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

Line 3418: (pay_balance_pkg.get_value

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