DBA Data[Home] [Help]

APPS.BEN_PBB_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 91: from per_contact_relationships

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