[Home] [Help]
1506: l_effective_start_date := null;
1507: -- Begin Bug# 4753092
1508: g_message_name := 'Fetch Element: Retirement Plan';
1509: -- End Bug# 4753092
1510: ghr_per_sum.get_element_details (p_element_name => 'Retirement Plan'
1511: ,p_input_value_name => 'Plan'
1512: ,p_assignment_id => p_sr_assignment_id
1513: ,p_effective_date => p_sr_report_date
1514: ,p_value => l_value
1521: l_effective_start_date := null;
1522: -- Begin Bug# 4753092
1523: g_message_name := 'Fetch Element: FEGLI';
1524: -- End Bug# 4753092
1525: ghr_per_sum.get_element_details(p_element_name => 'FEGLI'
1526: ,p_input_value_name => 'FEGLI'
1527: ,p_assignment_id => p_sr_assignment_id
1528: ,p_effective_date => p_sr_report_date
1529: ,p_value => l_value
1546: l_effective_start_date := null;
1547: -- Begin Bug# 4753092
1548: g_message_name := 'Fetch Element: TSP Amount';
1549: -- End Bug# 4753092
1550: ghr_per_sum.get_element_details(p_element_name => 'TSP'
1551: ,p_input_value_name => 'Amount'
1552: ,p_assignment_id => p_sr_assignment_id
1553: ,p_effective_date => p_sr_report_date
1554: ,p_value => l_value
1564: l_effective_start_date := null;
1565: -- Begin Bug# 4753092
1566: g_message_name := 'Fetch Element: TSP Rate';
1567: -- End Bug# 4753092
1568: ghr_per_sum.get_element_details (p_element_name => 'TSP'
1569: ,p_input_value_name => 'Rate'
1570: ,p_assignment_id => p_sr_assignment_id
1571: ,p_effective_date => p_sr_report_date
1572: ,p_value => l_value
1582: l_effective_start_date := null;
1583: --Begin Bug# 4753092
1584: g_message_name := 'Fetch Element: TSP Elig Date';
1585: --End Bug# 4753092
1586: ghr_per_sum.get_element_details (p_element_name => 'TSP'
1587: ,p_input_value_name => 'Agncy Contrib Elig Date'
1588: ,p_assignment_id => p_sr_assignment_id
1589: ,p_effective_date => p_sr_report_date
1590: ,p_value => l_value
1598: l_effective_start_date := null;
1599: --Begin Bug# 4753092
1600: g_message_name := 'Fetch Element: HB Pre Tax plan';
1601: --End Bug# 4753092
1602: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits Pre tax'
1603: ,p_input_value_name => 'Health Plan'
1604: ,p_assignment_id => p_sr_assignment_id
1605: ,p_effective_date => p_sr_report_date
1606: ,p_value => l_value
1618: l_effective_start_date := null;
1619: --Begin Bug# 4753092
1620: g_message_name := 'Fetch Element: HB Pre tax Enrl';
1621: --End Bug# 4753092
1622: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits Pre tax'
1623: ,p_input_value_name => 'Enrollment'
1624: ,p_assignment_id => p_sr_assignment_id
1625: ,p_effective_date => p_sr_report_date
1626: ,p_value => l_value
1636: l_effective_start_date := null;
1637: --Begin Bug# 4753092
1638: g_message_name := ' Fetch Element: HB plan';
1639: --End Bug# 4753092
1640: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits'
1641: ,p_input_value_name => 'Health Plan'
1642: ,p_assignment_id => p_sr_assignment_id
1643: ,p_effective_date => p_sr_report_date
1644: ,p_value => l_value
1655: l_effective_start_date := null;
1656: --Begin Bug# 4753092
1657: g_message_name := ' Fetch Element: HB Enrollment';
1658: --End Bug# 4753092
1659: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits'
1660: ,p_input_value_name => 'Enrollment'
1661: ,p_assignment_id => p_sr_assignment_id
1662: ,p_effective_date => p_sr_report_date
1663: ,p_value => l_value
1671: l_effective_start_date := null;
1672: --Begin Bug# 4753092
1673: g_message_name := 'Fetch Element: Total Pay';
1674: --End Bug# 4753092
1675: ghr_per_sum.get_element_details (p_element_name => 'Total Pay'
1676: ,p_input_value_name => 'Amount'
1677: ,p_assignment_id => p_sr_assignment_id
1678: ,p_effective_date => p_sr_report_date
1679: ,p_value => l_value
1686: l_effective_start_date := null;
1687: --Begin Bug# 4753092
1688: g_message_name := 'Fetch Element: Basic Salary';
1689: --End Bug# 4753092
1690: ghr_per_sum.get_element_details (p_element_name => 'Basic Salary Rate'
1691: ,p_input_value_name => 'Rate'
1692: ,p_assignment_id => p_sr_assignment_id
1693: ,p_effective_date => p_sr_report_date
1694: ,p_value => l_value
1701: l_effective_start_date := null;
1702: --Begin Bug# 4753092
1703: g_message_name := 'Fetch Element: Adj Basic Pay';
1704: --End Bug# 4753092
1705: ghr_per_sum.get_element_details (p_element_name => 'Adjusted Basic Pay'
1706: ,p_input_value_name => 'Amount'
1707: ,p_assignment_id => p_sr_assignment_id
1708: ,p_effective_date => p_sr_report_date
1709: ,p_value => l_value
1717: --Begin Bug# 4753092
1718: g_message_name := 'Fetch Element: Locality Pay';
1719: --End Bug# 4753092
1720: -- FWFA Changes Bug#4444609
1721: ghr_per_sum.get_element_details (p_element_name => 'Locality Pay or SR Supplement'
1722: -- FWFA Changes Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
1723: ,p_input_value_name => 'Rate'
1724: ,p_assignment_id => p_sr_assignment_id
1725: ,p_effective_date => p_sr_report_date
1738: l_effective_start_date := null;
1739: --Begin Bug# 4753092
1740: g_message_name := 'Fetch Element: Staffing Diff';
1741: --End Bug# 4753092
1742: ghr_per_sum.get_element_details (p_element_name => 'Staffing Differential'
1743: ,p_input_value_name => 'Amount'
1744: ,p_assignment_id => p_sr_assignment_id
1745: ,p_effective_date => p_sr_report_date
1746: ,p_value => l_value
1753: l_effective_start_date := null;
1754: --Begin Bug# 4753092
1755: g_message_name := 'Fetch Element:Supervisory Diff';
1756: --End Bug# 4753092
1757: ghr_per_sum.get_element_details (p_element_name => 'Supervisory Differential'
1758: ,p_input_value_name => 'Amount'
1759: ,p_assignment_id => p_sr_assignment_id
1760: ,p_effective_date => p_sr_report_date
1761: ,p_value => l_value
1767: l_effective_start_date := null;
1768: --Begin Bug# 4753092
1769: g_message_name := 'Fetch Element:Retention Allow';
1770: --End Bug# 4753092
1771: ghr_per_sum.get_element_details (p_element_name => 'Retention Allowance'
1772: ,p_input_value_name => 'Amount'
1773: ,p_assignment_id => p_sr_assignment_id
1774: ,p_effective_date => p_sr_report_date
1775: ,p_value => l_value