[Home] [Help]
5904: where person_id = p_person_id
5905: and business_group_id = p_business_group_id
5906: union
5907: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date
5908: from per_contact_relationships
5909: where person_id = p_person_id
5910: and business_group_id = p_business_group_id
5911: union
5912: select max(nvl(psl.last_update_date,p_pil_last_upd_date)) last_update_date