DBA Data[Home] [Help]

APPS.BEN_ASG_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 96: from per_contact_relationships

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