DBA Data[Home] [Help]

APPS.GHR_NON_SF52_EXTRA_INFO dependencies on PQP_FEDHR_USPAY_INT_UTILS

Line 1276: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Health Benefits',l_bus_group_id,l_effective_date,null);

1272:
1273: IF l_family_code = 'CONV_APP' OR l_family_code = 'EXT_NTE' THEN
1274: fnd_profile.get('PER_BUSINESS_GROUP_ID',l_bus_group_id);
1275: -- Check if FEHB exists
1276: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('Health Benefits',l_bus_group_id,l_effective_date,null);
1277: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP
1278: l_fehb_exists := TRUE;
1279: hr_utility.set_location('Health benefits present',111);
1280: EXIT;

Line 1284: 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);

1280: EXIT;
1281: END LOOP;
1282: -- Check if FEHB Pre tax exists
1283: IF l_fehb_exists = FALSE THEN
1284: 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);
1285: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP
1286: l_fehb_exists := TRUE;
1287: hr_utility.set_location('Health benefits pre tax present',111);
1288: EXIT;

Line 1304: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('FEGLI',l_bus_group_id,l_effective_date,null);

1300: END IF;
1301: END LOOP;
1302: END IF;
1303: -- Bug 4702325
1304: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('FEGLI',l_bus_group_id,l_effective_date,null);
1305: FOR l_cur_element IN c_element_value(l_new_element_name,p_assignment_id, l_effective_date) LOOP
1306: IF l_cur_element.ipv_name = 'FEGLI' THEN
1307: l_prev_fegli:= l_cur_element.screen_entry_value;
1308: END IF;

Line 1361: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('TSP',l_bus_group_id,l_effective_date,null);

1357: END IF;
1358:
1359: -- Check if TSP exists
1360: l_new_element_name := NULL;
1361: l_new_element_name := pqp_fedhr_uspay_int_utils.return_new_element_name('TSP',l_bus_group_id,l_effective_date,null);
1362: FOR l_element_entry_cur IN c_element_entry(p_assignment_id , l_new_element_name, l_effective_date) LOOP
1363: l_tsp_exists := TRUE;
1364: hr_utility.set_location('TSP present',111);
1365: EXIT;