DBA Data[Home] [Help]

APPS.BEN_PRO_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 125: from per_contact_relationships

121: order by 1;
122: --
123: cursor get_contacts(p_person_id in number) is
124: select person_id
125: from per_contact_relationships
126: where contact_person_id = p_person_id
127: and business_group_id = p_new.business_group_id
128: and l_session_date between nvl(date_start,l_session_date)
129: and nvl(date_end,l_session_date)