[Home] [Help]
1507: --8793163 For Dual Actions Benefits need to defaulted even if second action is conversion to appointment
1508: IF (l_family_code = 'CONV_APP' OR nvl(l_second_noa_family_code,hr_api.g_varchar2) = 'CONV_APP') OR l_family_code = 'EXT_NTE' THEN
1509: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
1510: -- Check if FEHB exists
1511: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Health Benefits',l_bus_group_id,l_effective_date,null);
1512: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP
1513: l_fehb_exists := TRUE;
1514: hr_utility.set_location('Health benefits present',111);
1515: EXIT;
1515: EXIT;
1516: END LOOP;
1517: -- Check if FEHB Pre tax exists
1518: IF l_fehb_exists = FALSE THEN
1519: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Health Benefits Pre tax',l_bus_group_id,l_effective_date,null);
1520: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP
1521: l_fehb_exists := TRUE;
1522: hr_utility.set_location('Health benefits pre tax present',111);
1523: EXIT;
1535: END IF;
1536: END LOOP;
1537: END IF;
1538: -- Bug 4702325
1539: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('FEGLI',l_bus_group_id,l_effective_date,null);
1540: FOR l_cur_element IN c_element_value(l_new_element_name,p_assignment_id, l_effective_date) LOOP
1541: IF l_cur_element.ipv_name = 'FEGLI' THEN
1542: l_prev_fegli:= l_cur_element.screen_entry_value;
1543: END IF;
1609: END IF;
1610:
1611: -- Check if TSP exists
1612: l_new_element_name := NULL;
1613: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('TSP',l_bus_group_id,l_effective_date,null);
1614: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP
1615: l_tsp_exists := TRUE;
1616: hr_utility.set_location('TSP present',111);
1617: EXIT;