APPS.PQP_GB_AD_EE dependencies on HR_GENERAL

Line 251: OR pee.effective_end_date = hr_general.end_of_time)

247: AND pete.information_type = 'PQP_VEHICLE_MILEAGE_INFO'
248: AND pete.eei_information1 <>'L'
249: AND pee.effective_start_date >= p_ele_start_date
250: AND (pee.effective_end_date <= p_ele_end_date
251: OR pee.effective_end_date = hr_general.end_of_time)
252: ORDER BY 1,2 desc;
253:
254: -- Cursor to check for Car and Mileage element entries
255:

Line 1307: ELSIF l_rec_curr_asg_dtls.effective_end_date < hr_general.end_of_time

1303: IF p_effective_start_date = l_rec_curr_asg_dtls.effective_start_date
1304: THEN
1305: hr_utility.set_location('Call update asg API in correction mode', 19);
1306: l_call_mode := 'CORRECTION';
1307: ELSIF l_rec_curr_asg_dtls.effective_end_date < hr_general.end_of_time
1308: THEN
1309: hr_utility.set_location('Call update asg API in update_change_insert mode', 20);
1310: l_call_mode := 'UPDATE_CHANGE_INSERT';
1311: ELSE