[Home] [Help]
258: SELECT *
259: FROM ghr_pa_history
260: WHERE person_id = p_person_id
261: AND (
262: (table_name = 'PER_PEOPLE_EXTRA_INFO' and information5 = 'GHR_US_PER_GROUP1') OR
263: (table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
264: AND information4 IN (SELECT b.input_value_id
265: FROM pay_element_types_f a,pay_input_values_f b
266: WHERE a.element_type_id = b.element_type_id
342:
343: BEGIN
344: hr_utility.set_location('Entering build_benefits_rec',0);
345: l_benefits_eit_rec := p_benefits_eit_rec;
346: IF p_pa_history_rec.table_name = 'PER_PEOPLE_EXTRA_INFO' AND p_pa_history_rec.information5 = 'GHR_US_PER_GROUP1' THEN
347: hr_utility.set_location('Assigning values for FEHB Person EIT',5);
348: p_benefits_eit_rec.FEHB_Date_Eligibility_expires := p_pa_history_rec.information19;
349: p_benefits_eit_rec.FEHB_Date_temp_eligibility := p_pa_history_rec.information20;
350: p_benefits_eit_rec.FEHB_Date_dependent_cert_expir := p_pa_history_rec.information21;
393: PROCEDURE insert_benefits_eit_rec(p_person_id IN NUMBER,
394: p_benefits_eit_rec IN ghr_api.per_benefit_info_type,
395: p_effective_date IN DATE) IS
396:
397: l_information_type per_people_extra_info.information_type%type;
398: l_person_extra_info_id NUMBER;
399: l_object_version_number NUMBER;
400:
401: CURSOR c_person_extra_info(p_person_id NUMBER) IS
400:
401: CURSOR c_person_extra_info(p_person_id NUMBER) IS
402: SELECT person_extra_info_id,
403: object_version_number
404: FROM per_people_extra_info
405: WHERE person_id = p_person_id
406: AND information_type = 'GHR_US_PER_BENEFIT_INFO';
407:
408: