2321: l_result NUMBER;
2322: l_pps_rec per_periods_of_service%ROWTYPE;
2323: l_per_rec per_all_people_f%ROWTYPE;
2324: l_dummy_num NUMBER;
2325: l_aei_rec per_assignment_extra_info%ROWTYPE;
2326: l_ass_rec per_all_assignments_f%ROWTYPE;
2327: l_oiplip_rec ben_cobj_cache.g_oiplip_inst_row;
2328: --
2329: BEGIN
2618: l_loc_rec hr_locations_all%ROWTYPE;
2619: l_per_rec per_all_people_f%ROWTYPE;
2620: l_person_id NUMBER;
2621: l_jurisdiction_code VARCHAR2(30);
2622: l_aei_rec per_assignment_extra_info%ROWTYPE;
2623: --
2624: --bug#3274130 - added date condition for relationship to pick the right spouse
2625: CURSOR c_per_spouse IS
2626: SELECT per.person_id