DBA Data[Home] [Help]

APPS.BEN_CRT_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 92: from per_contact_relationships

88: and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;
89: --
90: cursor get_contacts(p_person_id in number) is
91: select person_id
92: from per_contact_relationships
93: where contact_person_id = p_person_id
94: and business_group_id = p_new.business_group_id
95: and l_session_date between nvl(date_start,l_session_date)
96: and nvl(date_end,l_session_date)