[Home] [Help]
1437: l_effective_start_date := null;
1438: -- Begin Bug# 4753092
1439: g_message_name := 'Fetch Element: Retirement Plan';
1440: -- End Bug# 4753092
1441: ghr_per_sum.get_element_details (p_element_name => 'Retirement Plan'
1442: ,p_input_value_name => 'Plan'
1443: ,p_assignment_id => p_sr_assignment_id
1444: ,p_effective_date => p_sr_report_date
1445: ,p_value => l_value
1452: l_effective_start_date := null;
1453: -- Begin Bug# 4753092
1454: g_message_name := 'Fetch Element: FEGLI';
1455: -- End Bug# 4753092
1456: ghr_per_sum.get_element_details(p_element_name => 'FEGLI'
1457: ,p_input_value_name => 'FEGLI'
1458: ,p_assignment_id => p_sr_assignment_id
1459: ,p_effective_date => p_sr_report_date
1460: ,p_value => l_value
1469: l_effective_start_date := null;
1470: -- Begin Bug# 4753092
1471: g_message_name := 'Fetch Element: TSP Amount';
1472: -- End Bug# 4753092
1473: ghr_per_sum.get_element_details(p_element_name => 'TSP'
1474: ,p_input_value_name => 'Amount'
1475: ,p_assignment_id => p_sr_assignment_id
1476: ,p_effective_date => p_sr_report_date
1477: ,p_value => l_value
1487: l_effective_start_date := null;
1488: -- Begin Bug# 4753092
1489: g_message_name := 'Fetch Element: TSP Rate';
1490: -- End Bug# 4753092
1491: ghr_per_sum.get_element_details (p_element_name => 'TSP'
1492: ,p_input_value_name => 'Rate'
1493: ,p_assignment_id => p_sr_assignment_id
1494: ,p_effective_date => p_sr_report_date
1495: ,p_value => l_value
1505: l_effective_start_date := null;
1506: --Begin Bug# 4753092
1507: g_message_name := 'Fetch Element: TSP Elig Date';
1508: --End Bug# 4753092
1509: ghr_per_sum.get_element_details (p_element_name => 'TSP'
1510: ,p_input_value_name => 'Agncy Contrib Elig Date'
1511: ,p_assignment_id => p_sr_assignment_id
1512: ,p_effective_date => p_sr_report_date
1513: ,p_value => l_value
1521: l_effective_start_date := null;
1522: --Begin Bug# 4753092
1523: g_message_name := 'Fetch Element: HB Pre Tax plan';
1524: --End Bug# 4753092
1525: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits Pre tax'
1526: ,p_input_value_name => 'Health Plan'
1527: ,p_assignment_id => p_sr_assignment_id
1528: ,p_effective_date => p_sr_report_date
1529: ,p_value => l_value
1541: l_effective_start_date := null;
1542: --Begin Bug# 4753092
1543: g_message_name := 'Fetch Element: HB Pre tax Enrl';
1544: --End Bug# 4753092
1545: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits Pre tax'
1546: ,p_input_value_name => 'Enrollment'
1547: ,p_assignment_id => p_sr_assignment_id
1548: ,p_effective_date => p_sr_report_date
1549: ,p_value => l_value
1559: l_effective_start_date := null;
1560: --Begin Bug# 4753092
1561: g_message_name := ' Fetch Element: HB plan';
1562: --End Bug# 4753092
1563: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits'
1564: ,p_input_value_name => 'Health Plan'
1565: ,p_assignment_id => p_sr_assignment_id
1566: ,p_effective_date => p_sr_report_date
1567: ,p_value => l_value
1578: l_effective_start_date := null;
1579: --Begin Bug# 4753092
1580: g_message_name := ' Fetch Element: HB Enrollment';
1581: --End Bug# 4753092
1582: ghr_per_sum.get_element_details (p_element_name => 'Health Benefits'
1583: ,p_input_value_name => 'Enrollment'
1584: ,p_assignment_id => p_sr_assignment_id
1585: ,p_effective_date => p_sr_report_date
1586: ,p_value => l_value
1594: l_effective_start_date := null;
1595: --Begin Bug# 4753092
1596: g_message_name := 'Fetch Element: Total Pay';
1597: --End Bug# 4753092
1598: ghr_per_sum.get_element_details (p_element_name => 'Total Pay'
1599: ,p_input_value_name => 'Amount'
1600: ,p_assignment_id => p_sr_assignment_id
1601: ,p_effective_date => p_sr_report_date
1602: ,p_value => l_value
1609: l_effective_start_date := null;
1610: --Begin Bug# 4753092
1611: g_message_name := 'Fetch Element: Basic Salary';
1612: --End Bug# 4753092
1613: ghr_per_sum.get_element_details (p_element_name => 'Basic Salary Rate'
1614: ,p_input_value_name => 'Rate'
1615: ,p_assignment_id => p_sr_assignment_id
1616: ,p_effective_date => p_sr_report_date
1617: ,p_value => l_value
1624: l_effective_start_date := null;
1625: --Begin Bug# 4753092
1626: g_message_name := 'Fetch Element: Adj Basic Pay';
1627: --End Bug# 4753092
1628: ghr_per_sum.get_element_details (p_element_name => 'Adjusted Basic Pay'
1629: ,p_input_value_name => 'Amount'
1630: ,p_assignment_id => p_sr_assignment_id
1631: ,p_effective_date => p_sr_report_date
1632: ,p_value => l_value
1640: --Begin Bug# 4753092
1641: g_message_name := 'Fetch Element: Locality Pay';
1642: --End Bug# 4753092
1643: -- FWFA Changes Bug#4444609
1644: ghr_per_sum.get_element_details (p_element_name => 'Locality Pay or SR Supplement'
1645: -- FWFA Changes Modify 'Locality Pay' to 'Locality Pay or SR Supplement'
1646: ,p_input_value_name => 'Rate'
1647: ,p_assignment_id => p_sr_assignment_id
1648: ,p_effective_date => p_sr_report_date
1661: l_effective_start_date := null;
1662: --Begin Bug# 4753092
1663: g_message_name := 'Fetch Element: Staffing Diff';
1664: --End Bug# 4753092
1665: ghr_per_sum.get_element_details (p_element_name => 'Staffing Differential'
1666: ,p_input_value_name => 'Amount'
1667: ,p_assignment_id => p_sr_assignment_id
1668: ,p_effective_date => p_sr_report_date
1669: ,p_value => l_value
1676: l_effective_start_date := null;
1677: --Begin Bug# 4753092
1678: g_message_name := 'Fetch Element:Supervisory Diff';
1679: --End Bug# 4753092
1680: ghr_per_sum.get_element_details (p_element_name => 'Supervisory Differential'
1681: ,p_input_value_name => 'Amount'
1682: ,p_assignment_id => p_sr_assignment_id
1683: ,p_effective_date => p_sr_report_date
1684: ,p_value => l_value
1690: l_effective_start_date := null;
1691: --Begin Bug# 4753092
1692: g_message_name := 'Fetch Element:Retention Allow';
1693: --End Bug# 4753092
1694: ghr_per_sum.get_element_details (p_element_name => 'Retention Allowance'
1695: ,p_input_value_name => 'Amount'
1696: ,p_assignment_id => p_sr_assignment_id
1697: ,p_effective_date => p_sr_report_date
1698: ,p_value => l_value