Line 5788: from per_pay_proposals psl, per_all_assignments_f asn
5784: where person_id = p_person_id
5785: and business_group_id = p_business_group_id
5786: union
5787: select max(nvl(psl.last_update_date,p_pil_last_upd_date)) last_update_date 5788: from per_pay_proposals psl, per_all_assignments_f asn 5789: where psl.assignment_id = asn.assignment_id
5790: and asn.person_id = p_person_id
5791: and asn.business_group_id = p_business_group_id
5792: union