237: and asn.person_id = p_person_id
238: and asn.business_group_id = p_business_group_id
239: union
240: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date
241: from per_periods_of_service
242: where person_id = p_person_id
243: and business_group_id = p_business_group_id
244: union
245: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date