717: WHERE vendor_contact_id=p_contact_id;
718:
719: vendor_contact_rec vendor_contact_csr%ROWTYPE;
720:
721: -- Bug 6598261.Changed per_all_workforce_v to per_workforce_v.
722:
723: CURSOR employee_contact_csr IS
724: SELECT full_name contact_name
725: FROM per_workforce_v
721: -- Bug 6598261.Changed per_all_workforce_v to per_workforce_v.
722:
723: CURSOR employee_contact_csr IS
724: SELECT full_name contact_name
725: FROM per_workforce_v
726: WHERE person_id = p_contact_id;
727:
728: CURSOR employee_name_csr IS
729: SELECT per.full_name contact_name