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