DBA Data[Home] [Help]

APPS.BEN_PPR_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 101: from per_contact_relationships

97: ;
98: --
99: cursor get_contacts(p_person_id in number) is
100: select person_id
101: from per_contact_relationships
102: where contact_person_id = p_person_id
103: and business_group_id = p_new.business_group_id
104: and l_session_date between nvl(date_start,l_session_date)
105: and nvl(date_end,l_session_date)