726: WHERE person_id = p_contact_id;
727:
728: CURSOR employee_name_csr IS
729: SELECT per.full_name contact_name
730: FROM per_all_people_f per
731: WHERE per.person_id = p_contact_id
732: AND per.effective_start_date = (SELECT MAX(effective_start_date)
733: FROM per_all_people_f
734: WHERE person_id = per.person_id);
729: SELECT per.full_name contact_name
730: FROM per_all_people_f per
731: WHERE per.person_id = p_contact_id
732: AND per.effective_start_date = (SELECT MAX(effective_start_date)
733: FROM per_all_people_f
734: WHERE person_id = per.person_id);
735:
736:
737: employee_contact_rec employee_contact_csr%ROWTYPE;