APPS.BEN_EGD_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 111: FROM per_contact_relationships pcr

107: AND bp.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
108: --
109: CURSOR get_contacts(p_person_id IN per_all_people_f.person_id%TYPE) IS
110: SELECT pcr.contact_person_id
111: FROM per_contact_relationships pcr
112: WHERE pcr.person_id = p_person_id
113: AND pcr.business_group_id = p_new.business_group_id
114: AND l_session_date BETWEEN NVL(pcr.date_start, l_session_date)
115: AND NVL(pcr.date_end, l_session_date);