DBA Data[Home] [Help]

APPS.BEN_ABS_LER dependencies on PER_CONTACT_RELATIONSHIPS

Line 363: from per_contact_relationships

359: and nvl(trgr_table_pk_id,-1) = nvl(p_trgr_table_pk_id,-1);
360: --
361: cursor get_contacts(p_person_id in number) is
362: select person_id
363: from per_contact_relationships
364: where contact_person_id = p_person_id
365: and business_group_id = nvl(p_new.business_group_id,p_old.business_group_id)
366: and l_session_date
367: between nvl(date_start,l_session_date)